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

Install an Azure on-premises data gateway at the primary location

Answer

Install a standalone on-premises Azure data gateway at each location

Answer

Install an on-premises data gateway in personal mode at each location

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

Azure Databricks

Answer

Azure Traffic Manager

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

Data Migration Assistant (DMA)

Answer

backup and restore

Answer

transactional replication

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

Number of databases only

Answer

Number of transactions only

Answer

CPU usage only

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 Cosmos DB

Answer

Azure SQL Database single database

Answer

Azure SQL Data Warehouse

Question 6

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?

Accepted Answer

AzCopy Tool

Answer

Azure Event Grid

Answer

Azure Data Factory

Answer

Azure Event Hubs

Question 7

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?

Accepted Answer

Azure Data Factory

Answer

Azure Event Hubs

Answer

Azure Event Grid

Answer

AzCopy Tool

Question 8

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?

Accepted Answer

A two-minute Tumbling window

Answer

A two-minute Hopping window that has one-minute hop

Answer

A two-minute Session window

Answer

A two-minute Sliding window

Question 9

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?

Accepted Answer

self-hosted integration runtime

Answer

Azure-SSIS integration runtime

Answer

Azure integration runtime

Answer

None of the above