DP-203 Exam Question 116

The following code segment is used to create an Azure Databricks cluster.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

DP-203 Exam Question 117

You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool.
You need to design queries to maximize the benefits of partition elimination.
What should you include in the Transact-SQL queries?
  • DP-203 Exam Question 118

    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.
  • DP-203 Exam Question 119

    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?
  • DP-203 Exam Question 120

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