READ Free Dumps For Microsoft- 70-462
| Question ID 18929 | 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.)
|
| Option A | Answer :
|
| Correct Answer | A |
Explanation
| Question ID 18930 | You create an availability group that has replicas named HA/Server01 and HA/Server02.
Currently, HA/Server01 is the primary replica.
You have multiple queries that read data and produce reports from the database.
You need to offload the reporting workload to the secondary replica when HA/Server01 is
the primary replica.
What should you do?
|
| Option A | Set the Availability Mode property of HA/Server02 to Asynchronous commit.
|
| Option B | Set the Readable Secondary property of HA/Server02 to Read-intent only.
|
| Option C | Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
|
| Option D | Set the Availability Mode property of HA/Server01 to Asynchronous commit.
|
| Correct Answer | B |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/jj542414.aspx