70-469 무료 덤프문제 온라인 액세스

You need to add a new column named Confirmed to the Attendees table.
The solution must meet the following requirements:
- Have a default value of false.
- Minimize the amount of disk space used.
Which code block should you use?

• A.ALTER TABLE Attendees
  ADD Confirmed char(l) DEFAULT '1';
• B.ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 1;
• C.ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 0;
• D.ALTER TABLE Attendees
  ADD Confirmed char(l) DEFAULT '1';

You have a table named Rooms that contains three columns. You execute the following query:

You discover the execution plan shown in the exhibit. (Click the Exhibit button.)

You need to recommend a solution to reduce the amount of time it takes to execute the query.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Create a clustered index for Id.
• B.Use the WITH (INDEX(Room_IX),NOLOCK) query hint.
• C.Create a nonclustered index for RoomName, Id, and Position.
• D.Include the RoomName column and the Position column in the Room_IX index.

An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?

• A.USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
• B.USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY ENCRYPTION BY SERVER CERTIFICATE DBCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
• C.USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE DBCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO
• D.USE PRODUCTSDB; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT; GO ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON; GO

DRAG DROP
You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements:
- SProc1 must return a table.
- SProc2 must return a status code.
You need to identify which options must be implemented to meet each stored procedure requirement.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be used once, more than once, or not at all.)

정답:

You have a database that is accessed by 300 concurrent users.
You need to log all of the queries that become deadlocked. The solution must meet the following requirements:
- Provide a representation of the deadlock in XML format.
- Minimize the impact on the server.
What should you create?

• A.A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views
• B.A SQL Server Profiler trace
• C.A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views
• D.A script that enables trace flags