FEFreeExamDumps.in

DP-203 Practice Questions — Page 22

Question 211

Open question ↗

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?

  • A.column-level security
  • B.dynamic data masking
  • C.row-level security (RLS)
  • D.sensitivity classifications

Question 212

Open question ↗

You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server named Server1.

You need to implement Transparent Data Encryption (TDE) on Pool1 by using a custom key named key1.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Select and Place:

Question 212

Question 213

Open question ↗

You have a data warehouse in Azure Synapse Analytics.

You need to ensure that the data in the data warehouse is encrypted at rest.

What should you enable?

  • A.Advanced Data Security for this database
  • B.Transparent Data Encryption (TDE)
  • C.Secure transfer required
  • D.Dynamic Data Masking

Question 214

Open question ↗

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables.

Which distribution type should you recommend to minimize data movement during queries?

  • A.HASH
  • B.REPLICATE
  • C.ROUND_ROBIN

Question 215

Open question ↗

You develop a dataset named DBTBL1 by using Azure Databricks.

DBTBL1 contains the following columns:

✑ SensorTypeID

✑ GeographyRegionID

✑ Year

✑ Month

✑ Day

✑ Hour

✑ Minute

✑ Temperature

✑ WindSpeed

✑ Other

You need to store the data to support daily incremental load pipelines that vary for each GeographyRegionID. The solution must minimize storage costs.

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Question 215

Question 216

Open question ↗

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 is worth one point.

  • A.a security policy
  • B.a custom role-based access control (RBAC) role
  • C.a predicate function
  • D.a column encryption key
  • E.asymmetric keys

Question 217

Open question ↗

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.

What should you do?

  • A.From Microsoft SQL Server Management Studio, set an email mask on the Email column.
  • B.From the Azure portal, set a mask on the Email column.
  • C.From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
  • D.From the Azure portal, set a sensitivity classification of Confidential for the Email column.

Question 218

Open question ↗

You have an Azure Data Lake Storage Gen2 account named adls2 that is protected by a virtual network.

You are designing a SQL pool in Azure Synapse that will use adls2 as a source.

What should you use to authenticate to adls2?

  • A.an Azure Active Directory (Azure AD) user
  • B.a shared key
  • C.a shared access signature (SAS)
  • D.a managed identity

Question 219

Open question ↗

You have an Azure Synapse Analytics SQL pool named Pool1. In Azure Active Directory (Azure AD), you have a security group named Group1.

You need to control the access of Group1 to specific columns and rows in a table in Pool1.

Which Transact-SQL commands should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Question 219

Question 220

Open question ↗

You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration.

How should you configure the new cluster? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Question 220