Microsoft DP-203 Exam Dumps

Data Engineering on Microsoft Azure

Microsoft DP-203 Sample Questions

Question # 1

You have an Azure Databricks resource.You need to log actions that relate to changes in compute for the Databricks resource.Which Databricks services should you log?

A. clusters 
B. workspace 
C. DBFS 
D. SSH 
E lobs 

Answer: B

Show Answer

Question # 2

You have an Azure Data lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone,transform the data by executing an R script, and then insert the transformed data into adata warehouse in Azure Synapse Analytics.Solution You use an Azure Data Factory schedule trigger to execute a pipeline thatexecutes an Azure Databricks notebook, and then inserts the data into the data warehouseDow this meet the goal?

A. Yes 
B. No 

Answer: A

Show Answer

Question # 3

You plan to build a structured streaming solution in Azure Databricks. The solution willcount new events in five-minute intervals and report only events that arrive during theinterval. The output will be sent to a Delta Lake table.Which output mode should you use?

A. complete 
B. update 
C. append 

Answer: C

Show Answer

Question # 4

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

A. Microsoft.Sql 
B. Microsoft-Automation 
C. Microsoft.EventGrid 
D. Microsoft.EventHub 

Answer: C

Show Answer

Question # 5

You are designing an Azure Databricks interactive cluster. The cluster will be usedinfrequently and will be configured for auto-termination.You need to ensure that the cluster configuration is retained indefinitely after the cluster isterminated. The solution must minimize costsWhat should you do?

A. Clone the cluster after it is terminated. 
B. Terminate the cluster manually when processing completes. 
C. Create an Azure runbook that starts the cluster every 90 days. 
D. Pin the cluster. 

Answer: D

Show Answer

Question # 6

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on aserver named Server1.You need to verify whether the size of the transaction log file for each distribution of DW1 issmaller than 160 GB.What should you do?

A. On the master database, execute a query against thesys.dm_pdw_nodes_os_performance_counters dynamic management view. 
B. From Azure Monitor in the Azure portal, execute a query against the logs of DW1. 
C. On DW1, execute a query against the sys.database_files dynamic management view. 
D. Execute a query against the logs of DW1 by using the Get-AzOperationalInsightSearchResult PowerShell cmdlet. 

Answer: A

Show Answer

Question # 7

You are designing a financial transactions table in an Azure Synapse Analytics dedicatedSQL pool. The table will have a clustered columnstore index and will include the followingcolumns:TransactionType: 40 million rows per transaction typeCustomerSegment: 4 million per customer segmentTransactionMonth: 65 million rows per monthAccountType: 500 million per account typeYou have the following query requirements:Analysts will most commonly analyze transactions for a given month.Transactions analysis will typically summarize transactions by transaction type,customer segment, and/or account typeYou need to recommend a partition strategy for the table to minimize query times.On which column should you recommend partitioning the table?

A. CustomerSegment 
B. AccountType 
C. TransactionType 
D. TransactionMonth 

Answer: D

Show Answer

Question # 8

You plan to ingest streaming social media data by using Azure Stream Analytics. The datawill be stored in files in Azure Data Lake Storage, and then consumed by using AzureDatiabricks and PolyBase in Azure Synapse Analytics.You need to recommend a Stream Analytics data output format to ensure that the queriesfrom Databricks and PolyBase against the files encounter the fewest possible errors. Thesolution must ensure that the tiles can be queried quickly and that the data type informationis retained.What should you recommend?

A. Parquet 
B. Avro 
C. CSV 
D. JSON 

Answer: A

Show Answer

Question # 9

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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You plan to create an Azure Databricks workspace that has a tiered structure. Theworkspace will contain the following three workloads:A workload for data engineers who will use Python and SQL.A workload for jobs that will run notebooks that use Python, Scala, and SOL.A workload that data scientists will use to perform ad hoc analysis in Scala and R.The enterprise architecture team at your company identifies the following standards forDatabricks environments: The data engineers must share a cluster.The job cluster will be managed by using a request process whereby datascientists and data engineers provide packaged notebooks for deployment to thecluster.All the data scientists must be assigned their own cluster that terminatesautomatically after 120 minutes of inactivity. Currently, there are three datascientists.You need to create the Databricks clusters for the workloads.Solution: You create a Standard cluster for each data scientist, a High Concurrency clusterfor the data engineers, and a Standard cluster for the jobs.Does this meet the goal?

A. Yes 
B. No 

Answer: B

Show Answer

Question # 10

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

A. Out of order Events 
B. Late Input Events 
C. Baddogged Input Events 
D. Function Events 

Answer: C

Show Answer

Question # 11

You are creating an Azure Data Factory data flow that will ingest data from a CSV file, castcolumns to specified types of data, and insert the data into a table in an Azure SynapseAnalytic dedicated SQL pool. The CSV file contains three columns named username,comment, and date.The data flow already contains the following:A source transformation.A Derived Column transformation to set the appropriate types of data.A sink transformation to land the data in the pool.You need to ensure that the data flow meets the following requirements:All valid rows must be written to the destination table.Truncation errors in the comment column must be avoided proactively.Any rows containing comment values that will cause truncation errors upon insertmust be written to a file in blob storage.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. To the data flow, add a sink transformation to write the rows to a file in blob storage. 
B. To the data flow, add a Conditional Split transformation to separate the rows that will cause truncation errors. 
C. To the data flow, add a filter transformation to filter out rows that will cause truncation errors
D. Add a select transformation to select only the rows that will cause truncation errors. 

Answer: A,B

Show Answer

Question # 12

You are developing a solution that will stream to Azure Stream Analytics. The solution willhave both streaming data and reference data.Which input type should you use for the reference data?

A. Azure Cosmos DB 
B. Azure Blob storage 
C. Azure IoT Hub 
D. Azure Event Hubs 

Answer: B

Show Answer

Question # 13

You have an Azure Synapse Analytics dedicated SQL pool that contains a table namedTable1.You have files that are ingested and loaded into an Azure Data Lake Storage Gen2container named container1.You plan to insert data from the files into Table1 and azure Data Lake Storage Gen2container named container1.You plan to insert data from the files into Table1 and transform the data. Each row of datain the files will produce one row in the serving layer of Table1.You need to ensure that when the source data files are loaded to container1, the DateTimeis stored as an additional column in Table1.Solution: You use a dedicated SQL pool to create an external table that has a additionalDateTime column.Does this meet the goal?

A. Yes 
B. No 

Answer: A

Show Answer

Question # 14

You plan to perform batch processing in Azure Databricks once daily.Which type of Databricks cluster should you use?

A. High Concurrency 
B. automated 
C. interactive 

Answer: B

Show Answer

Question # 15

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a databasenamed DB1. DB1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

A. Connect to the built-in pool and query sysdm_pdw_sys_info. 
B. Connect to Pool1 and run DBCC CHECKALLOC. 
C. Connect to the built-in pool and run DBCC CHECKALLOC. 
D. Connect to Pool! and query sys.dm_pdw_nodes_db_partition_stats. 

Answer: D

Show Answer

Question # 16

You are creating a new notebook in Azure Databricks that will support R as the primarylanguage but will also support Scale and SOL Which switch should you use to switchbetween languages?

A. @<Language> 
B. %<Language> 
C. \\(<Language>) 
D. \\(<Language>) 

Answer: B

Show Answer

Question # 17

Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this scenario, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You have an Azure Storage account that contains 100 GB of files. The files contain textand numerical values. 75% of the rows contain description data that has an average lengthof 1.1 MB.You plan to copy the data from the storage account to an enterprise data warehouse inAzure Synapse Analytics.You need to prepare the files to ensure that the data copies quickly.Solution: You convert the files to compressed delimited text files.Does this meet the goal?

A. Yes 
B. No 

Answer: A

Show Answer

Question # 18

You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not reportperformance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performanceissues.Which metric should you monitor?

A. Data IO percentage 
B. Local tempdb percentage 
C. Cache used percentage 
D. DWU percentage 

Answer: C

Show Answer

Question # 19

You are designing an Azure Databricks cluster that runs user-defined local processes. Youneed to recommend a cluster configuration that meets the following requirements:• Minimize query latency.• Maximize the number of users that can run queues on the cluster at the same time «Reduce overall costs without compromising other requirementsWhich cluster type should you recommend?

A. Standard with Auto termination 
B. Standard with Autoscaling 
C. High Concurrency with Autoscaling 
D. High Concurrency with Auto Termination 

Answer: C

Show Answer

Question # 20

You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table.The table contains 50 columns and 5 billion rows and is a heap.Most queries against the table aggregate values from approximately 100 million rows andreturn only two columns.You discover that the queries against the fact table are very slow.Which type of index should you add to provide the fastest query times?

A. nonclustered columnstore 
B. clustered columnstore 
C. nonclustered 
D. clustered 

Answer: B

Show Answer

Question # 21

You have an Azure Synapse Analystics dedicated SQL pool that contains a table namedContacts. Contacts contains a column named Phone.You need to ensure that users in a specific role only see the last four digits of a phonenumber when querying the Phone column.What should you include in the solution?

A. a default value 
B. dynamic data masking 
C. row-level security (RLS) 
D. column encryption 
E. table partitions 

Answer: B

Show Answer