Don't forget to create account on our site to get access to more material made only for free registered user.  

Azure 70-532 Azure 70 533

Question 9 :  You need to test an update to the website. You create a new SQL server database. You need to copy the customer and holiday provider data to the new database for testing purposes. Which of the following actions should you perform to populate the test database?

  1.     Configure disk mirroring between the live database and the test database.

  2.   Configure SQL Replication between the live database and the test database.

  3.   Configure SQL Server data synchronization between the live database and the test database.

  4.   Configure Azure SQL Database Active Geo-Replication between the live database and the test database.

Correct Answer : 3 Exp : Business continuity is the ability to continue business operations when a crisis or disaster occurs. Business continuity planning requires processes, procedures, and measures to ensure that business operations can continue without interruption. This topic focuses on the Azure SQL Database features that enable business continuity and disaster recovery.

By storing your data in Azure SQL Database, you take advantage of many fault tolerance and secure infrastructure capabilities that you would otherwise have to design, acquire, implement, and manage. Azure SQL Database has a built-in high availability subsystem that protects your database from failures of individual servers and devices in a datacenter. Azure SQL Database maintains multiple copies of all data in different physical nodes located across fully independent physical sub-systems to mitigate outages due to failures of individual server components, such as hard drives, network interface adapters, or even entire servers. At any one time, three database replicas are running-one primary replica and two or more secondary replicas. Data is written to the primary and one secondary replica using a quorum based commit scheme before the transaction is considered committed. If the hardware fails on the primary replica, Azure SQL Database detects the failure and fails over to the secondary replica. In case of a physical loss of a replica, a new replica is automatically created. So there are always at minimum two physical, transactionally consistent copies of your data in the datacenter.

You have no rights to post comments