Microsoft Microsoft Certifications DP-203 Questions & Answers

• Question 271:

  You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container. Which resource provider should you enable?

  A. Microsoft.Sql

  B. Microsoft.Automation

  C. Microsoft.EventGrid

  D. Microsoft.EventHub

  Correct Answer: C

  Event-driven architecture (EDA) is a common data integration pattern that involves production, detection, consumption, and reaction to events. Data integration scenarios often require Data Factory customers to trigger pipelines based on events happening in storage account, such as the arrival or deletion of a file in Azure Blob Storage account. Data Factory natively integrates with Azure Event Grid, which lets you trigger pipelines on such events.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers

• Question 272:

  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.

  A. Implement event ordering.

  B. Implement Azure Stream Analytics user-defined functions (UDF).

  C. Implement query parallelization by partitioning the data output.

  D. Scale the SU count for the job up.

  E. Scale the SU count for the job down.

  F. Implement query parallelization by partitioning the data input.

  Correct Answer: DF

  D: Scale out the query by allowing the system to process each input partition separately.

  F: A Stream Analytics job definition includes inputs, a query, and output. Inputs are where the job reads the data stream from.

  Reference: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

• Question 273:

  You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation.

  Which service should you use to ingest the data?

  A. Azure Event Hubs Dedicated

  B. Azure Stream Analytics

  C. Azure Data Factory

  D. Azure Synapse Analytics

  Correct Answer: A

  You can't change the partition count for an event hub after its creation except for the event hub in a dedicated cluster.

  Reference: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features

• Question 274:

  You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables. Which distribution type should you recommend to minimize data movement?

  A. HASH

  B. REPLICATE

  C. ROUND_ROBIN

  Correct Answer: B

  A replicated table has a full copy of the table available on every Compute node. Queries run fast on replicated tables since joins on replicated tables don't require data movement. Replication requires extra storage, though, and isn't practical for large tables.

  Incorrect Answers:

  A: A hash distributed table is designed to achieve high performance for queries on large tables.

  C: A round-robin table distributes table rows evenly across all distributions. The rows are distributed randomly. Loading data into a round-robin table is fast. Keep in mind that queries can require more data movement than the other distribution methods.

  Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview

• Question 275:

  You have an Azure Data Factory version 2 (V2) resource named Df1. Df1 contains a linked service.

  You have an Azure Key vault named vault1 that contains an encryption key named key1.

  You need to encrypt Df1 by using key1.

  What should you do first?

  A. Add a private endpoint connection to vaul1.

  B. Enable Azure role-based access control on vault1.

  C. Remove the linked service from Df1.

  D. Create a self-hosted integration runtime.

  Correct Answer: C

  Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources. Incorrect Answers:

  D: A self-hosted integration runtime copies data between an on-premises store and cloud storage.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/enable-customer-managed-key https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime

• Question 276:

  You are designing an Azure Synapse Analytics dedicated SQL pool.

  You need to ensure that you can audit access to Personally Identifiable Information (PII).

  What should you include in the solution?

  A. column-level security

  B. dynamic data masking

  C. row-level security (RLS)

  D. sensitivity classifications

  Correct Answer: D

  Data Discovery and Classification is built into Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It provides basic capabilities for discovering, classifying, labeling, and reporting the sensitive data in your databases.

  Your most sensitive data might include business, financial, healthcare, or personal information. Discovering and classifying this data can play a pivotal role in your organization's information-protection approach. It can serve as infrastructure for:

  1.

  Helping to meet standards for data privacy and requirements for regulatory compliance.

  2.

  Various security scenarios, such as monitoring (auditing) access to sensitive data.

  3.

  Controlling access to and hardening the security of databases that contain highly sensitive data.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview

• Question 277:

  You have a data warehouse in Azure Synapse Analytics.

  You need to ensure that the data in the data warehouse is encrypted at rest.

  What should you enable?

  A. Advanced Data Security for this database

  B. Transparent Data Encryption (TDE)

  C. Secure transfer required

  D. Dynamic Data Masking

  Correct Answer: B

  Azure SQL Database currently supports encryption at rest for Microsoft-managed service side and client-side encryption scenarios.

  1.

  Support for server encryption is currently provided through the SQL feature called Transparent Data Encryption.

  2.

  Client-side encryption of Azure SQL Database data is supported through the Always Encrypted feature.

  Reference: https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest

• Question 278:

  You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:

  

  You identify the following usage patterns:

  1.

  Analysts will most commonly analyze transactions for a warehouse.

  2.

  Queries will summarize by product category type, date, and/or inventory event type.

  You need to recommend a partition strategy for the table to minimize query times.

  On which column should you partition the table?

  A. EventTypeID

  B. ProductCategoryTypeID

  C. EventDate

  D. WarehouseID

  Correct Answer: D

  The number of records for each warehouse is big enough for a good partitioning.

  Note: Table partitions enable you to divide your data into smaller groups of data. In most cases, table partitions are created on a date column.

  When creating partitions on clustered columnstore tables, it is important to consider how many rows belong to each partition. For optimal compression and performance of clustered columnstore tables, a minimum of 1 million rows per

  distribution and partition is needed. Before partitions are created, dedicated SQL pool already divides each table into 60 distributed databases.

• Question 279:

  You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date. You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  A. Create a date dimension table that has a DateTime key.

  B. Use built-in SQL functions to extract date attributes.

  C. Create a date dimension table that has an integer key in the format of YYYYMMDD.

  D. In the fact table, use integer columns for the date fields.

  E. Use DateTime columns for the date fields.

  Correct Answer: BD

• Question 280:

  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?

  A. Change the compatibility level of the Stream Analytics job.

  B. Increase the number of streaming units (SUs).

  C. Remove any named consumer groups from the connection and use $default.

  D. Create an additional output stream for the existing input stream.

  Correct Answer: B

  Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job. You should increase the Streaming Units.

  Note: Streaming Units (SUs) represents the computing resources that are allocated to execute a Stream Analytics job. The higher the number of SUs, the more CPU and memory resources are allocated for your job.

  Reference: https://docs.microsoft.com/bs-cyrl-ba/azure/stream-analytics/stream-analytics-monitoring