← Back to exam page

DP-203 – Data Engineering on Microsoft Azure

Loading demo links...

Showing 7–9 of 20 questions

Question 7 (New Update)

You plan to create an Azure Synapse Analytics dedicated SQL pool.

You need to minimize the time it takes to identify queries that return confidential information as defined by the company's data privacy regulations and the users who executed the queues.

Which two components should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    sensitivity-classification labels applied to columns that contain confidential information
  • ○

    resource tags for databases that contain confidential information
  • ○

    audit logs sent to a Log Analytics workspace
  • ○

    dynamic data masking for columns that contain confidential information
Question 8 (Mixed Questions)

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.

Select all that apply, then click Submit answer.

  • ○

    Create a date dimension table that has a DateTime key.
  • ○

    Use built-in SQL functions to extract date attributes.
  • ○

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

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

    Use DateTime columns for the date fields.
Question 9 (New Update)

You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies. You need to ensure that users from each company can view only the data of their respective company. Which two objects should you include in the solution? Each correct answer presents part of the solution

NOTE: Each correct selection it worth one point.

Select all that apply, then click Submit answer.

  • ○

    a custom role-based access control (RBAC) role.
  • ○

    asymmetric keys
  • ○

    a predicate function
  • ○

    a column encryption key

  • ○

    a security policy