Ensurepass

QUESTION 71

You administer a database that has User A, B and C. User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data, User C must be able to provide windows logins to the database.

 

db_accessadmin

db_ddladmin

db_datawriter

db_datareader

db_owner

 

To which role or roles should you add the users?

 

A.      ddladmin

B.      datawriter, datareader

C.      accessadmin

D.      None of the above

 

Correct Answer: D

 

 

QUESTION 72

DRAG DROP

You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC. ServerA is the acting principal and ServerB is the mirror. You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB. You need to achieve this goal without delaying synchronization. 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:

clip_image002

 

Correct Answer:

clip_image003

 

 

QUESTION 73

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:

clip_image005

 

Correct Answer:

clip_image007

 

 

QUESTION 74

DRAG AND DROP

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:

clip_image009

 

Correct Answer:

clip_image010

 

 

QUESTION 75

DRAG AND DROP

You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application. You need to migrate the database without affecting the production environment. 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:

clip_image012

 

Correct Answer:

clip_image013

 

 

QUESTION 76

DRAG AND DROP

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following definition:

 

clip_image014

 

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the CarrierTrackingNumber column. Which four Transact- SQL statements should you use?

 

To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

 

Build List and Reorder:

clip_image016

 

Correct Answer:

clip_image017

 

 

QUESTION 77

DRAG AND DROP

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following definition:

 

clip_image018

 

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the SpecialOfferID column. Which four Transact-SQL statements should you use?

 

To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

 

Build List and Reorder:

clip_image020

 

Correct Answer:

clip_image021

 

 

 

QUESTION 78

DRAG AND 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.

 

Build List and Reorder:

clip_image023

 

Correct Answer:

clip_image024

 

 

QUESTION 79

DRAG AND DROP

You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. 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:

clip_image026

Correct Answer:

clip_image027

 

 

QUESTION 80

DRAG AND DROP

You administer a Microsoft SQL Server database. You want to import data from a text file to the database. You need to ensure that the following requirements are met:

 

Ÿ   Data import is performed by using a stored procedure.

Ÿ   Data is loaded as a unit and is minimally logged.

 

Which data import command and recovery model should you choose?

 

To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Each data import command or recovery model 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:

clip_image029

 

Correct Answer:

clip_image031

 

 

Comments are closed.