May 2014 462 ADMIN SAMPLE

Topics: SQL, Microsoft SQL Server, Database Pages: 47 (8857 words) Published: November 10, 2014
Microsoft 70-462 Exam Questions & Answers
Number: 70-462
Passing Score: 700
Time Limit: 300 min
File Version: 52.2

Microsoft 70-462 Exam Questions & Answers
Exam Name: Administering Microsoft SQL Server 2012 Databases

Exam A
QUESTION 1
DRAG AND DROP
You administer several Microsoft SQL Server 2012 servers. Your company has a number of offices across the world connected by using a wide area network (WAN). Connections between offices vary significantly in both bandwidth and reliability. You need to identify the correct replication method for each scenario. What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.) Select and Place:

Correct Answer:

Section: (none)
Explanation
Explanation/Reference:
According to this reference, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms151198.aspx QUESTION 2
DRAG AND DROP
You administer several Microsoft SQL Server 2012 servers. Your company has a number of offices across the world connected by using a wide area network (WAN). Connections between offices vary significantly in both bandwidth and reliability. You need to identify the correct replication method for each scenario. What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.) Select and Place:

Correct Answer:

Section: (none)
Explanation
Explanation/Reference:
According to this reference, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms151198.aspx QUESTION 3
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01. You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring. You need to prepare the Contoso database for database mirroring. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Build List and Reorder:

Correct Answer:

Section: (none)
Explanation
Explanation/Reference:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://msdn.microsoft.com/en-us/library/ms189852.aspx
QUESTION 4
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks. You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA. Which three actions should you perform in

sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:

Correct Answer:

Section: (none)
Explanation
Explanation/Reference:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://msdn.microsoft.com/en-us/library/ms189852.aspx

QUESTION 5
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data. You need to encrypt the database files at the page level. You also need to encrypt the transaction log files. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Build List and Reorder:

Correct Answer:

Section: (none)
Explanation
Explanation/Reference:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/bb510663.aspx...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • admin Essay
  • MAY TOK 2014 help Research Paper
  • Admin Essay
  • admin Essay
  • Sample Essay
  • sample Essay
  • Sample Essay
  • Sample Essay

Become a StudyMode Member

Sign Up - It's Free