DP-200

DP-200 Test 2

0%

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?

Correct! Wrong!

Explanation:
To ensure that your organization can access on-premises data resources used in Power BI reports and dashboards, you can construct high-availability clusters of On-premises data gateway installations. Gateway managers can use such clusters to group gateways together to eliminate single points of failure when accessing on-premises data resources. Unless the primary gateway in the cluster is unavailable, the Power BI service utilizes it. The service then moves on to the next gateway in the cluster, and so on.

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?

Correct! Wrong!

Explanation:
A Resource Manager template makes it simple to create the following resources in a single, coordinated action for your application:
✑ HDInsight clusters and the resources they rely on (such as the default storage account).
✑ Additional resources (such as Azure SQL Database to use Apache Sqoop).
The resources required for the application are defined in the template. You can also define deployment parameters for distinct environments' input values.
The JSON and expressions in the template are used to create values for your deployment.

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?

Correct! Wrong!

Explanation:
SQL Data Sync is an Azure SQL Database service that allows you to synchronize data across various SQL databases and SQL Server instances bi-directionally.
To allow hybrid applications, you can use Data Sync to keep data synchronized between your on-premises databases and Azure SQL databases.
Consider the differences between data synchronization and transactional replication.

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?

Correct! Wrong!

Explanation:
The ideal pool size is determined by the total resources required by all databases in the pool. This entails figuring out the following:
✑ All databases in the pool are using the most resources possible (either maximum DTUs or maximum vCores depending on your choice of resourcing model).
✑ The total amount of storage bytes used by all databases in the pool.
Note: Elastic pools allow a developer to buy resources for a pool that is shared by numerous databases, allowing for variable durations of usage by individual databases. You can either use the DTU-based purchasing model or the vCore-based purchasing model to configure resources for the pool.

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?

Correct! Wrong!

Explanation:
Managed instance is a new Azure SQL Database deployment option that offers near-complete compatibility with the latest SQL Server on-premises (Enterprise Edition) Database Engine, as well as a native virtual network (VNet) implementation that addresses common security concerns and a business model that is appealing to on-premises SQL Server customers. Existing SQL Server users can use the managed instance deployment methodology to move their on-premises applications to the cloud with minimal application and database changes.

You're a data engineer for a corporation, and you've been tasked with setting up an Azure Data Lake Gen 2 storage account. Your organization wishes to ingest data from a variety of sources into the storage account.
To ingest data from a local workstation, what should you use?

Correct! Wrong!

Explanation:
The AzCopy tool is a simple and free tool for copying and moving data to and from Azure storage. It's a fantastic command-line tool that automates and streamlines the procedure, but it does take some setup.

An Azure Data Lake Gen 2 storage account has been created by a corporation. They wish to ingest data from numerous data sources into the storage account.
Which of the following methods may they utilize to consume data from web server log files?

Correct! Wrong!

Explanation:
The Azure Data Factory platform is the solution to such data problems. It's a cloud-based data integration tool that lets you develop data-driven processes for orchestrating and automating data transportation and transformation in the cloud.

Andy is employed by TPT Ltd. He receives Twitter data through Azure Event and outputs it to an Azure Blob storage account using Azure Stream Analytics.
Every two minutes, Andy is to output the total number of tweets received in the previous two minutes; each tweet is tallied just once.
Andy should utilize which of the provided windowing functions to achieve the requirement?

Correct! Wrong!

The correct answer:
A two-minute Tumbling window

You have Microsoft SQL Server installed on an Azure virtual computer. There is a table named Table1 on the server. Using an Azure Data Factory V2 copy activity, copy the data from Table1 to an Azure Data Lake Storage Gen2 account. What kind of integration runtime should you go with?

Correct! Wrong!

Explanation:
A self-hosted integration runtime can perform copy operations between a cloud data store and a local data store. It can also run transform operations against compute resources in an on-premises or Azure virtual network.