최신 070-473 무료덤프 - Microsoft Designing and Implementing Cloud Data Platform Solutions
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 plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.
You need to audit all of the SELECT statements that are executed against all of the databases. The solution must ensure that all gathered information is written to the application log.
Solution: You create a Database Audit Specification in each database.
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 plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.
You need to audit all of the SELECT statements that are executed against all of the databases. The solution must ensure that all gathered information is written to the application log.
Solution: You create a Database Audit Specification in each database.
Does this meet the goal?
정답: B
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?
정답: B
You need to prepare the Azure environment for the planned migration of DB1. The solution must meet the requirements of the finance department.
Which two tasks should you perform in Azure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Which two tasks should you perform in Azure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: C,D
설명: (DumpTOP 회원만 볼 수 있음)
You need to configure a runbook to execute when a Microsoft Azure SQL database uses more than 80 percent of the Database Throughput Unit (DTU) resources.
What should you configure in the runbook?
What should you configure in the runbook?
정답: C
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 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 Intelligent Insights to identify the slow queries and an Azure event hub 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 Intelligent Insights to identify the slow queries and an Azure event hub to archive all the database events.
Does this meet the goal?
정답: A
Your company registers the domain name of contoso.com.
You plan to deploy two web servers, two application servers, and two Microsoft SQL server instances on Microsoft Azure virtual machines. All of the virtual machines will be located on the same Azure virtual network. The SQL Server instances will be in an AlwaysOn availability group.
You need to ensure that the web servers and the application servers can access the availability group listener by using a fully qualified domain name (FQDN) from the contoso.com domain.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to deploy two web servers, two application servers, and two Microsoft SQL server instances on Microsoft Azure virtual machines. All of the virtual machines will be located on the same Azure virtual network. The SQL Server instances will be in an AlwaysOn availability group.
You need to ensure that the web servers and the application servers can access the availability group listener by using a fully qualified domain name (FQDN) from the contoso.com domain.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: B,D,E
You have an on-premises database hosted on a Microsoft SQL Server instance.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
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 plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
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
You need to implement a solution to meet the technical requirements for the database administrators.
Which three actions should you perform in sequence from the Azure portal? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Which three actions should you perform in sequence from the Azure portal? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
정답:
Explanation
Your company has two offices located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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 tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the az sql db create command from Azure Cloud Shell.
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 tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the az sql db create command from Azure Cloud Shell.
Does this meet the goal?
정답: A