DP-203 practice questions 341–350

1. Question 341 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named User1. You need to ensure that User1 can review the Azure Synapse Analytics database templates from the gallery. The solution must follow the principle of least privilege. Which role should you assign to User1?

   • AStorage Blob Data Contributor.
   • BSynapse Administrator
   • CSynapse Contributor
   • DSynapse User

   Show answer

   Answer: D

   Explanation

   At least Synapse User role permissions are required for exploring a lake database template from Gallery. Synapse Administrator, or Synapse Contributor permissions are required on the Synapse workspace for creating a lake database. Storage Blob Data Contributor permissions are required on data lake when using the create table From data lake option. https://learn.microsoft.com/en-us/azure/synapse-analytics/database-designer/create-lake-database-from-lake-database-templates

   Source: Adapted from community discussion — RK710

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 342 · 370 in bank

   Select 2

   You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1. You need to identify whether a recently executed query on Pool1 used the result set cache. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AReview the sys.dm_pdw_sql_requests dynamic management view in Pool1.
   • BReview the sys.dm_pdw_exec_requests dynamic management view in Pool1.
   • CUse the Monitor hub in Synapse Studio.
   • DReview the AzureDiagnostics table in la1.
   • EReview the sys.dm_pdw_request_steps dynamic management view in Pool1.

   Show answer

   Answer: BC

   Explanation

   The sys.dm_pdw_exec_requests dynamic management view provides details about currently or recently executed requests, and the Monitor hub in Synapse Studio can offer insights into the query execution and caching.

   Source: Adapted from community discussion — Happynewyear1001

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 343 · 370 in bank

   HOTSPOT - You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.Orders. Sales.Orders contains a column named SalesRep. You plan to implement row-level security (RLS) for Sales.Orders. You need to create the security policy that will be used to implement RLS. The solution must ensure that sales representatives only see rows for which the value of the SalesRep column matches their username. How should you complete the code? To answer, select the appropriate options in the answer area.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   -- Create schema CREATE SCHEMA Security; GO -- Create function CREATE FUNCTION Security.tv_securitypredicate (@SalesRep AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS tv_securitypredicate_result WHERE @SalesRep = USER_NAME(); GO -- Create security policy CREATE SECURITY POLICY SalesFilter ADD FILTER PREDICATE Security.tv_securitypredicate(SalesRep) ON Sales.Orders WITH (STATE = ON);

   Source: Adapted from community discussion — Happynewyear1001

   

   Next question

4. Question 344 · 370 in bank

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

   • APin the cluster.
   • BCreate an Azure runbook that starts the cluster every 90 days.
   • CTerminate the cluster manually when processing completes.
   • DClone the cluster after it is terminated.

   Show answer

   Answer: A

   Explanation

   To ensure that the cluster configuration is retained indefinitely after the cluster is terminated while minimizing costs, you should pin the cluster. Pinning a cluster in Azure Databricks prevents it from being terminated by the auto-termination feature. This means that the cluster configuration and installed libraries will be retained even if the cluster is not being used. This is the most efficient and cost-effective way to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. Creating an Azure runbook to start the cluster every 90 days would require additional resources and would not be a cost-effective solution. Terminating the cluster manually when processing completes would not retain the cluster configuration. Cloning the cluster after it is terminated would create a new cluster with the same configuration, but this would also result in additional costs. Should be A

   Source: Adapted from community discussion — markpumc

   References

   • Databricks documentation
   • Microsoft Learn

   Next question

5. Question 345 · 370 in bank

   You have an Azure data factory named DF1. DF1 contains a single pipeline that is executed by using a schedule trigger. From Diagnostics settings, you configure pipeline runs to be sent to a resource-specific destination table in a Log Analytics workspace. You need to run KQL queries against the table. Which table should you query?

   • AADFPipelineRun
   • BADFTriggerRun
   • CADFActivityRun
   • DAzureDiagnostics

   Show answer

   Answer: A

   Explanation

   Remember that you are setting "pipeline runs" logs from diagnostics settings to be sent to a Log Analytics workspace, not the "trigger runs" or "activity runs" logs. Azure Diagnostics stores resource logs for Azure services that use Azure Diagnostics mode. Resource logs describe the internal operation of Azure resources. Azure services that use resource-specific mode store data in a table specific to that service and do not use the AzureDiagnostics table https://learn.microsoft.com/en-us/azure/azure-monitor/reference/tables/azurediagnostics

   Source: Adapted from community discussion — Mausar

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 346 · 370 in bank

   HOTSPOT - You have an Azure Synapse Analytics dedicated SQL pool named sqlpool1 that contains a table named Sales1. Each row in the Sales table contains regional sales data and a field that lists the username of a sales analyst. You need to configure row-level security (RLS) to ensure that the analysts can view only the rows containing their respective data. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   References

   • Microsoft Learn

   

   Next question

7. Question 347 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse workspace named WS1 and an Azure Monitor action group named Group1. WS1 has a dedicated SQL pool. You plan to archive monitoring data for integration activity runs. You need to ensure that you can configure custom alerts based on the archived data that will execute Group1. The solution must minimize administrative effort. Which diagnostic setting should you select?

   • ASend to Log Analytics workspace
   • BArchive to a storage account
   • CStream to an event hub
   • DSend to a partner solution

   Show answer

   Answer: A

   References

   • Microsoft Learn

   Next question

8. Question 348 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You have the queries shown in the following table.

   

   You are evaluating whether to enable result set caching for Pool1. Which query results will be cached if result set caching is enabled?

   • AQuery1 only
   • BQuery2 only
   • CQuery1 and Query2 only
   • DQuery1 and Query3 only
   • EQuery1, Query2, and Query3 only

   Show answer

   Answer: C

   Explanation

   correct What's not cached Once result set caching is turned ON for a database, results are cached for all queries until the cache is full, except for these queries: Queries with built-in functions or runtime expressions that are non-deterministic even when there’s no change in base tables’ data or query. For example, DateTime.Now(), GetDate(). Queries using user defined functions Queries using tables with row level security Queries returning data with row size larger than 64KB Queries returning large data in size (>10GB)

   Source: Adapted from community discussion — Tapaskaro

   References

   • Microsoft Learn

   Next question

9. Question 349 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse Analytics workspace name workspace1, workspace1 contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You create a mapping data flow in an Azure Synapse pipeline that writes data to Pool1. You execute the data flow and capture the execution information. You need to identify how long it takes to write the data to Pool1. Which metric should you use?

   • Athe rows written
   • Bthe sink processing time
   • Cthe transformation processing time
   • Dthe post processing time

   Show answer

   Answer: B

   Explanation

   Correct: Each transformation stage includes a total time for that stage to complete with each partition execution time totaled together. When you select the Sink, you see "Sink Processing Time". This time includes the total of the transformation time plus the I/O time it took to write your data to your destination store. The difference between the Sink Processing Time and the total of the transformation is the I/O time to write the data. https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-monitoring#total-sink-processing-time-vs-transformation-processing-time

   Source: Adapted from community discussion — jongert

   References

   • Microsoft Learn

   Next question

10. Question 350 · 370 in bank

    You have an Azure data factory named DF1. DF1 contains a pipeline that has five activities. You need to monitor queue times across the activities by using Log Analytics. What should you do in DF1?

    • AConnect DF1 to a Microsoft Purview account.
    • BAdd a diagnostic setting that sends activity runs to a Log Analytics workspace.
    • CEnable auto refresh for the Activity Logs Insights workbook.
    • DAdd a diagnostic setting that sends pipeline runs to a Log Analytics workspace.

    Show answer

    Answer: B

    Explanation

    B is correct: the table ADFActivityRun serves the same purpose. All information about each activity can be found in this table.

    Source: Adapted from community discussion — Sr18

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-203 practice, question 341. 370 questions available.