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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it As a result, these questions wilt not appear in the review screen.
You have a database named DB1 that contains a table named Table1. You need to audit all updates to Table1.
Solution: You create an UPDATEl trigger on Table1 that insert modified data into an audit table.
Does this meet the goal?

• A.No
• B.Yes

You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization's SQL Server 2016 deployment.
Which of the following tools would you use to accomplish this goal?

• A.SQLIO
• B.SQLIOSim
• C.SQLIOStress
• D.chkdsk

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.
You need to ensure that you can perform auditing at the database level for DB1.
Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition.
Does the solution meet the goal?

• A.No
• B.Yes

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2016.
You attempt to add the [Corpnet\User1] login to the database.
However, you receive the following error message:
"User already exists in current database."
You need to configure the [Corpnet\User1] login to be able to access the Orders database and retain the original permissions.
You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

• A.DROP USER [User1]; CREATE USER [Corpnet\User1] FOR LOGIN [Corpnet\User1]; ALTER ROLE
  [db_owner] ADD MEM3ER [Corpnet\User1];
• B.ALTER ROLE [db owner] ADD MEMBBR [Corpnet\User1];
• C.ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];
• D.ALTER SERVER RCLS Isysadmin] ADD MEMBER [Corpnet\User1];

You plan to deploy a database to SQL Azure. You are designing two stored procedures named USP_1 and USP_2 that have the following requirements:
* Prevent data read by USP_1 from being modified by other active processes.
* Allow USP_2 to perform dirty reads.
You need to recommend the isolation level for the stored procedures.
The solution must maximize concurrency.
Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct stored procedure in the answer area.

正解：

Explanation
SP1 - repeatable read; SP2 - read uncommited
Note:
- SP1: repeatable read a repeatable read scan retains locks on every row it touches until the end of the transaction. Even rows that do not qualify for the query result remain locked. These locks ensure that the rows touched by the query cannot be updated or deleted by a concurrent session until the current transaction completes (whether it is committed or rolled back).
- SP2: read uncommitted permits repeatable reads