DRAG DROP
You administer a Microsoft SQL Server instance. You use a two-node SQL Server failover cluster.
Node B is primary, and Node A is secondary. You need to install a security patch on both nodes. You
need to ensure that the following requirements are met:
• Both nodes receive the update.
• Downtime is minimized.
• No data is lost.
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.)

DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to
use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a
SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL
Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on
a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS
package. 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.)

You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database
of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00
hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the
week. Backups are performed as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch
process will take a maximum of 8 hours to complete. The batch process will update three tables that
are 10 GB in size. The batch process will update these tables multiple times. When the batch process
completes, the Finance department runs a report to find out whether the batch process has
completed correctly. You need to ensure that if the Finance department disapproves the batch
process, the batch operation can be rolled back in the minimum amount of time. What should you
do on Saturday?

DRAG DROP
You administer a Microsoft SQL Server 2012 database. All database traffic to the SQL Server must be
encrypted by using secure socket layer (SSL) certificates or the connection must be refused. Network
administrators have deployed server certificates to the Windows store of all Windows servers on the
network from a trusted Certificate Authority. This is the only Certificate Authority allowed to
distribute certificates on the network.
You enable the Force Encryption flag for the MSSQLServer protocols, but client computers are
unable to connect. They receive the following error message:
“A connection was successfully established with the server, but then an error occurred during the
pre-login handshake, (provider: SSL Provider, error: 0 – The certificate chain was issued by an
authority that is not trusted.) (Microsoft SQL Server)”
You notice the following entry in the SQL Server log:
“A self-generated certificate was successfully loaded for encryption.”
You need to configure SQL Server to encrypt all client traffic across the network. You also need to
ensure that client computers are able to connect to the server by using a trusted certificate. 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.)

DRAG DROP
You administer a database named SalesDb that has users named UserA, userB, and UserC. You need
to ensure that the following requirements are met:
• UserA must be able to provide Windows logins access to the database.
• UserB must be able to select, update, delete, and insert data to the database tables.
• UserC must be able to create new tables and stored procedures.
You need to achieve this goal by granting only the minimum permissions required. To which fixed
database role or roles should you add the users? (To answer, drag the appropriate use role or roles.
Answer choices may be used once, more than once, or not at all. Answer targets may be
additionally, you may need to drag the split bar between panes or scroll to view content.)