DP-203 Synapse Practice Questions

You are designing a data mart for the human resources (MR) department at your company. The data mart will contain information and employee transactions. From a source system you have a flat extract that has the following fields: • EmployeeID • FirstName • LastName • Recipient • GrossArnount • TransactionID • GovernmentID • NetAmountPaid • TransactionDate You need to design a start schema data model in an Azure Synapse analytics dedicated SQL pool for the data mart. Which two tables should you create? Each Correct answer present part of the solution.

Select 2 answers.

• AA. a dimension table for employee
• BB. a fabric for Employee
• CC. a dimension table far EmployeeTransaction
• DD. a dimension table for Transaction
• EE. a fact table for Transaction

You have an Azure Synapse Analytics dedicated SQL pool mat contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use?

• AA. row-level security
• BB. column-level security
• CC. Dynamic data masking
• DD. Transparent Data Encryption (TDD

You are designing a folder structure for the files m an Azure Data Lake Storage Gen2 account. The account has one container that contains three years of data. You need to recommend a folder structure that meets the following requirements: • Supports partition elimination for queries by Azure Synapse Analytics serverless SQL pooh • Supports fast data retrieval for data from the current month • Simplifies data security management by department Which folder structure should you recommend?

• AA. \YYY\MM\DD\Department\DataSource\DataFile_YYYMMMDD.parquet
• BB. \Depdftment\DataSource\YYY\MM\DataFile_YYYYMMDD.parquet
• CC. \DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet
• DD. \DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet