- Home
- Microsoft
- Designing and Implementing Cloud Data Platform Solutions
- Microsoft.70-473.v2018-10-23.q56
- Question 2
Valid 70-473 Dumps shared by EduDump.com for Helping Passing 70-473 Exam! EduDump.com now offer the newest 70-473 exam dumps, the EduDump.com 70-473 exam questions have been updated and answers have been corrected get the newest EduDump.com 70-473 dumps with Test Engine here:
Access 70-473 Dumps Premium Version
(170 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 2/56
You need to deploy a new Microsoft Azure SQL database that must meet the following requirements:
Will be available if 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 if 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.
Correct Answer: C,D
Explanation/Reference:
Explanation:
C: An availability group requires a load balancer when the SQL Server instances are on Azure virtual machines. The load balancer stores the IP address for the availability group listener. If an availability group spans multiple regions, each region needs a load balancer.
D: To test listener connectivity to the remote region, you can fail over the replica to the remote region.
While the replica is asynchronous, failover is vulnerable to potential data loss. To fail over without data loss, change the availability mode to synchronous and set the failover mode to automatic.
Reference: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines- windows-portal-sql-availability-group-dr
Explanation:
C: An availability group requires a load balancer when the SQL Server instances are on Azure virtual machines. The load balancer stores the IP address for the availability group listener. If an availability group spans multiple regions, each region needs a load balancer.
D: To test listener connectivity to the remote region, you can fail over the replica to the remote region.
While the replica is asynchronous, failover is vulnerable to potential data loss. To fail over without data loss, change the availability mode to synchronous and set the failover mode to automatic.
Reference: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines- windows-portal-sql-availability-group-dr
- Question List (56q)
- Question 1: You need to tell the research project leaders how to migrate...
- Question 2: You need to deploy a new Microsoft Azure SQL database that m...
- Question 3: You need to recommend a solution to meet the reporting requi...
- Question 4: You recently implemented a Microsoft Azure SQL data warehous...
- Question 5: You need to recommend a disaster recovery solution for the C...
- Question 6: You are evaluating moving the data from WebData1 to an Azure...
- Question 7: You plan to deploy a data platform solution for 4 TB of data...
- Question 8: You are evaluating the use of active geo-replication for one...
- Question 9: You plan to create a data warehouse in Microsoft Azure for d...
- Question 10: You manage a large Microsoft Azure SQL database. The databas...
- Question 11: Your company has a Microsoft Azure MySQL database that is us...
- Question 12: You have a Microsoft Azure SQL database named DB1 and a copy...
- Question 13: You have a Microsoft SQL Server instance on a Microsoft Azur...
- Question 14: You have a Microsoft Azure SQL database named DB1. You need ...
- Question 15: You plan to implement a Microsoft Azure SQL database. You ne...
- Question 16: You are evaluating whether to replace CRM-B with an Azure vi...
- Question 17: Your environment contains a Microsoft Azure virtual machine ...
- Question 18: You need to recommend an auditing solution that meets the bu...
- Question 19: You have 10 Microsoft Azure SQL database. One of the databas...
- Question 20: You have an application named App1 that uses a Microsoft Azu...
- Question 21: Note: This question is part of a series of questions that pr...
- Question 22: You need to recommend a solution to meet the network require...
- Question 23: What should you use to schedule the nightly jobs to meet the...
- Question 24: You need to recommend a backup solution for the ListTest dat...
- Question 25: You have a Microsoft SQL Server 2014 instance on a Microsoft...
- Question 26: You need to ensure that the performance statistics for the r...
- Question 27: You are planning the consolidation of the databases from Hos...
- Question 28: You need to configure a runbook to execute when a Microsoft ...
- Question 29: Your company has two offices located in London and New York....
- Question 30: Note: This question is part of a series of questions that pr...
- Question 31: You need to create a Microsoft Azure Resource Manager templa...
- Question 32: You need to recommend a solution to migrate the Listings dat...
- Question 33: Your company has a Microsoft SQL Server database hosted on a...
- Question 34: Note: This question is part of a series of questions that pr...
- Question 35: You have a Microsoft Azure SQL database named DB1. You plan ...
- Question 36: You are evaluating whether an Azure SQL Database elastic dat...
- Question 37: You need to recommend a solution to migrate the Listings dat...
- Question 38: You have a Microsoft Azure Infrastructure as a Service (IaaS...
- Question 39: Note: This question is part of a series of questions that pr...
- Question 40: You have Microsoft SQL Server installed on a Microsoft Azure...
- Question 41: In this section you will see one or more sets of questions w...
- Question 42: You implement Microsoft Azure ExpressRoute. You need to ensu...
- Question 43: You have a Microsoft Azure SQL database. The database is hos...
- Question 44: Your company register the domain name of contoso.com. You pl...
- Question 45: You have Microsoft SQL Server installed on a Microsoft Azure...
- Question 46: You are evaluating the migration of an on-premises Microsoft...
- Question 47: You are designing the data warehouse. You need to recommend ...
- Question 48: You have a Microsoft Azure SQL database that is used for rep...
- Question 49: Your company has two offices. The offices are located in Lon...
- Question 50: You deploy a Microsoft SQL Server instance on a Microsoft Az...
- Question 51: You have a failover cluster deployed to Microsoft Azure virt...
- Question 52: Your company has a data warehouse that contains a database n...
- Question 53: You have a Microsoft Azure SQL database. You need to ensure ...
- Question 54: You have a hybrid Microsoft SQL Server environment that has ...
- Question 55: You have an on-premises Microsoft SQL Server 2014 database i...
- Question 56: You have an organizational data mart that contains 3.5 TB of...
