You have a database that stores information for a shipping company. You create a table named Customers by
running the following Transact-SQL statement. (Line numbers are included for reference only.)

You need to ensure that salespeople can view data only for the customers that are assigned to them.
Which Transact-SQL segment should you insert at line 07?

HOTSPOT
You manage a Microsoft SQL Server instance. You have a user named User1.
You need to grant the minimum permissions necessary to allow User1 to review audit logs.
For each action, which option should you use? To answer, select the appropriate options in the answer area.
Hot Area:

HOTSPOT
You are planning to deploy log shipping for Microsoft SQL Server and store all backups on a dedicated
fileshare.
You need to configure the servers to perform each log shipping step.
Which server instance should you configure to perform each action? To answer, select the appropriate server
instances in the dialog box in the answer area.
Hot Area:

HOTSPOT
You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL
Server to a single Windows Server Cluster with three nodes. The planned configuration for the cluster is shown
in the Server Layout exhibit. (Click the Exhibit button.)

The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in
the SAN Team Email exhibit. (Click the Exhibit button.)

Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the
Exhibit button.)

All local storage is on SSD.
You need to plan specific configurations for the new cluster.
For each of the following statement, select Yes if the statement is true. Otherwise, select No.
Hot Area:

DRAG DROP
You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared
network location at \\\\DATA-CI1\\SQL.
You need to create an availability group listener named AGL1 on port 1433.In which order should you perform the actions? To answer, move all actions from the list of actions to the
answer area and arrange them in the correct order.
Select and Place:

HOTSPOT
You are configuring log shipping for a Microsoft SQL Server database named salesOrders.
You run the following Transact-SQL script:

You need to determine the changes that the script has on the environment.
How does the script affect the environment? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.Hot Area:

HOTSPOT
You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a
table named Table1.
Table1 becomes corrupt. You repair the table.
You need to verify that all the data in Table1 complies with the schema.
How should you complete the Transact-SQL code statement? To answer, select the appropriate Transact-SQL
code segments in the dialog box in the answer area.
Hot Area:

HOTSPOT
You manage a Microsoft-SQL Server database named sales Orders.
You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not
cause any data to be lost in the database.
How should you complete the DBCC command? To answer, select the appropriate options in the answer area.
Hot Area:

DRAG DROP
You have a test server that contains a database named DB1. Backups of the database are written to a single
backup device. The backup device has a full, differential, and transaction log backup.
You discover that the database is damaged. You restore the database to the point at which the differential
backup was taken.
You need to rebuild the database with data stored in the latest transaction logs.
How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL
segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at
all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup
job that runs at 02:00. The job backs up data from DB1 to the file B:\\DB1.bak.
You need to restore the DB1 database to the point in time of May 25, 2016 at 02:23 and ensure that the
database is functional and starts to accept connections.
Which Transact-SQL statement should you run?