70-469 試験問題を無料オンラインアクセス

DRAG DROP
You have a table named Table1 that contains 1 million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type.
You have a certificate named Cert1.
You need to replace Column1 with a new encrypted column that uses two-way encryption.
Which code segment should you execute before you remove Column1?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.

正解：

DRAG DROP
You plan to deploy a database by using SQL Server 2014.
Your company identifies the following requirements for the database: - The name of all stored procedures must start with "usp_"always. - All distribution statistics must be updated daily. You need to identify which feature must be used to meet each database requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct database requirement in the answer
area.

正解：

You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?

• A.The collation of the ProductName column
• B.The collation of the Products table
• C.The data type of the ProductName column
• D.The index on the ProductName column

You are troubleshooting an application that runs a query. The application frequently causes deadlocks.
You need to identify the isolation level used by the query when a deadlock occurs.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Query the sys.dm_exec_sessions dynamic management view.
• B.Enable trace flag 1222, and then view the SQL Server error log.
• C.Create a trace in SQL Server Profiler that contains the Deadlock graph event.
• D.Query the sys.dm_exec_requests dynamic management view.

You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on a backup server in the company's data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
• B.Put the differential backup on tape and send it to the third-party backup storage system.
• C.Set up SQL Server Always On with a SQL Azure database as a replica.
• D.Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.