Microsoft DP-203 Exam Dumps

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?

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?

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?

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?

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?

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?

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?

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

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?

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?

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

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?

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?

You use Azure Data Lake Storage Gen2.You need to ensure that workloads can use filter predicates and column projections to filterdata at the time the data is read from disk.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

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?

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?

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?

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?

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?

You need to design an Azure Synapse Analytics dedicated SQL pool that meets thefollowing requirements:Can return an employee record from a given point in time.Maintains the latest employee information.Minimizes query complexity.How should you model the employee data?

You are monitoring an Azure Stream Analytics job.The Backlogged Input Events count has been 20 for the last hour.You need to reduce the Backlogged Input Events count.What should you do?

You are designing a dimension table for a data warehouse. The table will track the value ofthe dimension attributes over time and preserve the history of the data by adding new rowsas the data changes.Which type of slowly changing dimension (SCD) should use?

You have an Azure Data Factory that contains 10 pipelines.You need to label each pipeline with its main purpose of either ingest, transform, or load.The labels must be available for grouping and filtering when using the monitoringexperience in Data Factory.What should you add to each pipeline?

You are monitoring an Azure Stream Analytics job by using metrics in Azure.You discover that during the last 12 hours, the average watermark delay is consistentlygreater than the configured late arrival tolerance.What is a possible cause of this behavior?

You have an Azure Synapse Analytics dedicated SQL pool.You need to ensure that data in the pool is encrypted at rest. The solution must NOTrequire modifying applications that query the data.What should you do?