070-473試験無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions 認定」
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You need to ensure that the performance statistics for the research department are collected. What should you enable?
You need to ensure that the performance statistics for the research department are collected. What should you enable?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Microsoft Azure SQL database named DB1 attached to a server named Server 1. A web application named App1 connects to Server1.
You configure Active Geo-Replication for DB1. For the replica, you deploy another Azure SQL database server named ServerFailover to a different region.
You plan to use a failover group named FG1 that will have a read-write listener.
You need to configure App1 to reconnect to the database automatically after a failover.
Which value should you include in the connection string of App1?
You configure Active Geo-Replication for DB1. For the replica, you deploy another Azure SQL database server named ServerFailover to a different region.
You plan to use a failover group named FG1 that will have a read-write listener.
You need to configure App1 to reconnect to the database automatically after a failover.
Which value should you include in the connection string of App1?
正解：D
解答を投票する
You need to design a highly available Microsoft SQL Server environment in Microsoft Azure that meets the following requirements.
* Prevents data loss if an Azure data center becomes unavailable
* Fails over to another Azure region without causing data loss if an Azure region becomes unavailable Which solution should you include in the environment? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
* Prevents data loss if an Azure data center becomes unavailable
* Fails over to another Azure region without causing data loss if an Azure region becomes unavailable Which solution should you include in the environment? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
You plan to deploy a Microsoft Azure SQL database named DB1 to support a new application named Appl.
You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
* DB1 must remain available.
* App1 must reconnect automatically.
What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
* DB1 must remain available.
* App1 must reconnect automatically.
What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
You need to deploy a new Microsoft Azure SQL database that must meet the following requirements:
* Will be available it a single Azure region becomes unavailable
* Will be able to fail over to another Azure region automatically
Which two configuration tasks should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
* Will be available it a single Azure region becomes unavailable
* Will be able to fail over to another Azure region automatically
Which two configuration tasks should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：A,C
解答を投票する
You have four Microsoft Azure SQL databases located on the same database server.
You need to configure the databases to be in an elastic database pool.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You need to configure the databases to be in an elastic database pool.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
正解：
Explanation
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-pool-create-portal/
You are evaluating whether to replace CRM-B with an Azure virtual machine.
You need to identify the required virtual machine service tier to replace CRM-. The solution must meet the following requirements:
Which virtual machine service tier should you identify?
You need to identify the required virtual machine service tier to replace CRM-. The solution must meet the following requirements:
Which virtual machine service tier should you identify?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Microsoft SQL Server instance that hosts a database named DB1.
You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：A,C
解答を投票する