070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
You plan to create a database named DB1.
You need to ensure that all the data in DB1 is encrypted when the database is at rest.
Which four actions should you perform in sequence after you create DB1? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to ensure that all the data in DB1 is encrypted when the database is at rest.
Which four actions should you perform in sequence after you create DB1? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=
You have an application named App1 that connects to a Microsoft Azure SQL database named AppDB1.
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
正解：C
解答を投票する
Your company identifies a stored procedure that runs slowly.
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
正解：B
解答を投票する
You need to migrate an on-premises postgreSQL database to Microsoft Azure Database for PostgreSQL servers.
Which tool should you use to complete each migration task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Which tool should you use to complete each migration task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
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, white 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 are managing a Microsoft Azure SQL database.
Users of the database report that queries to the database are slow to return results.
You need to recommend a solution to identify the most likely cause of the slow queries and to archive all database events for at least 90 days.
Solution: You deploy Application Insights to identify the slow queries and Query Store to archive all the database events.
Does this meet the goal?
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 are managing a Microsoft Azure SQL database.
Users of the database report that queries to the database are slow to return results.
You need to recommend a solution to identify the most likely cause of the slow queries and to archive all database events for at least 90 days.
Solution: You deploy Application Insights to identify the slow queries and Query Store to archive all the database events.
Does this meet the goal?
正解：A
解答を投票する
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the server resource in Azure.
Does this meet the goal?
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the server resource in Azure.
Does this meet the goal?
正解：B
解答を投票する
You need to implement monitoring for the ListTest database.
Which three statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Which three statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
正解：
Explanation
You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
正解：
Explanation
You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed.
You need to increase the disk space available to store database files on the virtual machine.
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.
You need to increase the disk space available to store database files on the virtual machine.
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.
正解：
Explanation
