070-764 試験問題を無料オンラインアクセス
| 試験コード: | 070-764 |
| 試験名称: | Administering a SQL Database Infrastructure |
| 認定資格: | Microsoft |
| 無料問題数: | 452 |
| 更新日: | 2025-10-18 |
You have two databases named DB1 and DB2 that are located on the same server.
You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2.
You need to recommend a solution to ensure that SProc1 can access Table2 without granting users direct access to Table2.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
Which task should you perform before you can create a utility control point by using the service account option?
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.
You administer a SQL Server Instance at Contoso Ltd.
A new employee named Kim Ralls must be able to read data only from the dbo.Order table in the SalesDB database.
You create a SQL login named KimRalls. You then create a SQL user account named KimRalls in SalesDB.
The user account is associated with the SQL login.
You need to grant KimRalls the necessary permission or permissions. Your solution must follow the principle of least privilege.
Solution: You perform the following actions:
* Create a custom database role named OrderReader in SalesDB.
* Grant the View Definition permission on dbo.Order to the OrderReader role.
* Add KimRalls to the OrderReader role.
Does the solution meet the goal?
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 that runs Microsoft SQL Server 2016 Enterprise edition.
Does the solution meet the goal?
You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements:
* Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.
* Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify? To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
