DP-200 Test 2

Question 1

For a corporation, you create data engineering solutions. Multiple sites in the firm have on-premises Microsoft SQL Server databases.
Microsoft Power BI and Microsoft Azure Logic Apps must be used to integrate data. During the connection and transfer to the cloud, the solution must avoid single points of failure. Latency must also be minimized in the solution.
Data communication between on-premises databases and Microsoft Azure must be safe.
What are your options?

Accepted Answer

Install an Azure on-premises data gateway as a cluster at each location

Answer

To ensure high availability, minimize latency, and avoid single points of failure when integrating on-premises SQL Server databases with Azure services like Power BI and Logic Apps, you should install an Azure on-premises data gateway as a cluster at each location. A gateway cluster provides redundancy and load balancing, while placing gateways at each site reduces network latency for data access. This setup ensures secure and resilient data communication.

Question 2

Azure HDInsight clusters are managed by the data engineering team. Because much of the data pipeline process happens in minutes, the team spends a lot of time constructing and removing clusters on a regular basis.
You must implement a system that allows you to quickly deploy additional HDInsight clusters.
What changes should you make?

Accepted Answer

Azure Resource Manager templates

Answer

To quickly and consistently deploy additional Azure HDInsight clusters, Azure Resource Manager (ARM) templates are the most effective solution. ARM templates allow you to define the entire infrastructure and configuration of your HDInsight clusters declaratively in a JSON file. This enables automated, repeatable, and standardized deployments, significantly reducing the time and effort spent on manual cluster setup and teardown.

Question 3

You're a data architect, right? The data engineering team must set up data synchronization between an on-premises Microsoft SQL Server database and a cloud-based Microsoft SQL Server database.
SQL Database on Azure.
The on-premises production instance is overburdened with ad-hoc and reporting queries. The synchronization process must include the following steps:
With minimal downtime, perform an initial data synchronization to Azure SQL Database.
After initial synchronization, perform bi-directional data synchronization.
This synchronization solution must be implemented.
Which method of synchronization should you use?

Accepted Answer

Azure SQL Data Sync

Answer

Azure SQL Data Sync is the ideal solution for implementing bi-directional data synchronization between an on-premises Microsoft SQL Server database and an Azure SQL Database. It supports both initial data synchronization with minimal downtime and continuous bi-directional synchronization thereafter. This service is specifically designed for hybrid scenarios requiring ongoing data consistency between cloud and on-premises SQL environments.

Question 4

A business has a SaaS solution that makes use of Azure SQL Database and elastic pools. Each customer organization has its own database in the solution.
Peak consumption periods for customer organizations occur at various times throughout the year.
To save money, you should use the Azure SQL Database elastic pool.
Which option, if any, should you set up?

Accepted Answer

eDTUs and max data size

Answer

To save money with Azure SQL Database elastic pools, especially when customer peak consumption periods vary, you should configure the eDTUs (elastic Database Transaction Units) and the max data size. eDTUs represent the combined measure of CPU, memory, and I/O resources, allowing databases within the pool to share resources and burst when needed. By setting appropriate eDTU limits and maximum storage, you can optimize costs by provisioning for the aggregate demand rather than individual peaks.

Question 5

Several on-premises Microsoft SQL Server databases are managed by a corporation.
You must use a Microsoft SQL Server backup method to move the databases to Microsoft Azure.
What type of data technology should you employ?

Accepted Answer

Azure SQL Database Managed Instance

Answer

Azure SQL Database Managed Instance is the most suitable Azure data technology for migrating on-premises Microsoft SQL Server databases using a native SQL Server backup method. Managed Instance offers near 100% compatibility with the latest SQL Server database engine, allowing direct backup and restore operations (via Azure Blob Storage). This minimizes migration effort and ensures compatibility with existing applications and features.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Test 2