What is this exam about?

Implementing Azure data solutions.

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly. You must implement a solution that meets the following requirements: ✑ Provide data warehousing ✑ Reduce ongoing management activities ✑ Deliver SQL query responses in less than one second You need to create an HDInsight cluster to meet the requirements. Which type of cluster should you create?

Correct Answer: Interactive Query

You configure monitoring for an Azure Synapse Analytics implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Storage Gen 2 using an external table. Files with an invalid schema cause errors to occur. You need to monitor for an invalid schema error. For which error should you monitor?

Correct Answer: EXTERNAL TABLE access failed due to internal error: 'Java exception raised on call to HdfsBridge_Connect: Error [Unable to instantiate LoginClass] occurred while accessing external file.'

You manage a process that performs analysis of daily web traffic logs on an HDInsight cluster. Each of the 250 web servers generates approximately 10 megabytes (MB) of log data each day. All log data is stored in a single folder in Microsoft Azure Data Lake Storage Gen 2. You need to improve the performance of the process. Which two changes should you make? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer: Combine the daily log files for all servers into one file

You have to create a new single database instance of Microsoft Azure SQL database. You must ensure that client connections are accepted via a workstation. The workstation will use SQL Server Management Studio to connect to the database instance. Which of the following Powershell commands would you execute to create and configure the database? (Choose three.)

Correct Answer: New-AzureRmSqlServerFirewallRule

You are monitoring the Data Factory pipeline that runs from Cosmos DB to SQL Database for Race Central. You discover that the job takes 45 minutes to run. What should you do to improve the performance of the job?

Correct Answer: Decrease parallelism for the copy activities.

You need to ensure that phone-based poling data can be analyzed in the PollingData database. How should you configure Azure Data Factory?

Correct Answer: Use an event-based trigger

You need to process and query ingested Tier 9 data. Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Azure Notification Hub

What should you include in the Data Factory pipeline for Race Central?

Correct Answer: a copy activity that uses a stored procedure as a source

You develop data engineering solutions for a company. You must integrate the company's on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally. You need to implement the data integration solution. Which tool should you use to configure a pipeline to copy data?

Correct Answer: Use Azure Data Factory UI with Blob storage linked service as a source

You have a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the issue. Which two metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Cache used percentage

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You need setup monitoring for tiers 6 through 8. What should you configure?

Correct Answer: an alert rule to monitor CPU percentage in elastic pools that emails data engineers

What should you implement to optimize SQL Database for Race Central to meet the technical requirements?

Correct Answer: automatic tuning

On which data store should you configure TDE to meet the technical requirements?

Correct Answer: Azure SQL Database

You need to implement event processing by using Stream Analytics to produce consistent JSON documents. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Define a query that contains a JavaScript user-defined aggregates (UDA) function.

You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency. You need to secure the transfer of data between on-premises databases and Microsoft Azure. What should you do?

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

You create an Azure Databricks cluster and specify an additional library to install. When you attempt to load the library to a notebook, the library is not found. You need to identify the cause of the issue. What should you review?

Correct Answer: cluster event logs

Which two metrics should you use to identify the appropriate RU/s for the telemetry data? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Number of requests

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?

Correct Answer: Azure-SSIS Integration Runtime

You are a data architect. The data engineering team needs to configure a synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database. Ad-hoc and reporting queries are being overutilized the on-premises production instance. The synchronization process must: ✑ Perform an initial data synchronization to Azure SQL Database with minimal downtime ✑ Perform bi-directional data synchronization after initial synchronization You need to implement this synchronization solution. Which synchronization method should you use?

Correct Answer: transactional replication

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead. What should you do?

Correct Answer: From Microsoft SQL Server Management Studio, set an email mask on the Email column.

You are monitoring an Azure Stream Analytics job. You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events. What should you do?

Correct Answer: Remove any named consumer groups from the connection and use $default.

You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key Sale Key column to retrieve data as displayed in the following table: You need to distribute the large fact table across multiple nodes to optimize performance of the table. Which technology should you use?

Correct Answer: hash distributed table with clustered ColumnStore index

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. You need to implement the Azure SQL Database elastic pool to minimize cost. Which option or options should you configure?

Correct Answer: eDTUs per database only

You develop data engineering solutions for a company. You need to ingest and visualize real-time Twitter data by using Microsoft Azure. Which three technologies should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Event Grid topic

A company has an Azure SQL data warehouse. They want to use PolyBase to retrieve data from an Azure Blob storage account and ingest into the Azure SQL data warehouse. The files are stored in parquet format. The data needs to be loaded into a table called XYZ_sales. Which of the following actions need to be performed to implement this requirement? (Choose four.)

Correct Answer: Load the data into a staging table

You have an Azure Stream Analytics job. You need to ensure that the job has enough streaming units provisioned. You configure monitoring of the SU% Utilization metric. Which two additional metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Watermark Delay

A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the data. The cloud job is configured to use 120 Streaming Units (SU). You need to optimize performance for the Azure Stream Analytics job. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Implement Azure Stream Analytics user-defined functions (UDF)

A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?

Correct Answer: Azure Cosmos DB

You develop data engineering solutions for a company. A project requires the deployment of data to Azure Data Lake Storage. You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Configure service-to-service authentication for the Azure Data Lake Storage account.

The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes. You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. What should you implement?

Correct Answer: Ambari web user interface

You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID. You monitor the Stream Analytics job and discover high latency. You need to reduce the latency. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer: Scale out the query by using PARTITION BY.

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. You must perform an assessment of databases to determine whether data will move without compatibility issues. You need to perform the assessment. Which tool should you use?

Correct Answer: SQL Vulnerability Assessment (VA)

You have an Azure SQL server named Server1 that hosts two development databases named DB1 and DB2. You have an administrative workstation that has an IP address of 192.168.8.8. The development team at your company has an IP addresses in the range of 192.168.8.1 to 192.168.8.5. You need to set up firewall rules to meet the following requirements: ✑ Allows connection from your workstation to both databases. ✑ The development team must be able connect to DB1 but must be prevented from connecting to DB2. ✑ Web services running in Azure must be able to connect to DB1 but must be prevented from connecting to DB2. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Create a firewall rule on DB1 that has a start and end IP address of 192.168.8.8.

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Implementing an Azure Data Solution

Implement Azure data solutions with cloud data services.

4.8★★★★★(173 ratings)

19,663 studentsIntermediate

Gain practical knowledge for building and managing Azure data environments. The exam covers storage, processing, integration, and security tasks needed for modern data solutions. This certification is valuable for data engineers who need real-world cloud data skills. It supports dependable, scalable, and secure analytics foundations in Azure.

What you'll learn

Build Azure data pipelines- Manage storage solutions- Process cloud data- Apply data security- Support analytics workloads

DP-200

Lectures2

Quizzes0

Duration30 week

Students19,663

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!