A company uses Azure SQL Database and requires that all connections use encrypted connections. The company also wants to ensure that data is encrypted at rest. What should you configure?

Use a VPN gateway to connect to the database and enable Always Encrypted for all columns.

Set the 'Force encryption' option in the connection string and enable Transparent Data Encryption (TDE) on the database.

Enable TLS 1.2 on the client and rely on the default encryption at rest provided by Azure SQL Database.

Set the 'Encrypt' option in the connection string and enable Azure Storage Service Encryption on the storage account.

In Azure Data Lake Storage Gen2, what do POSIX-like ACLs control?

Network access to the storage account

Access to specific files and directories for users and groups

You are loading a DataFrame in Azure Databricks that contains sensitive columns. What is the recommended practice to protect this data during processing?

Use a secret scope to store credentials and avoid hardcoding them

Encrypt the DataFrame in memory

Use a shared access signature in the code

Disable logging for the notebook

Microsoft Certified:Azure Data Engineer Associate

Domain 3Objective 1

Implement Data Security DP-203 Practice Questions (Page 2)

Part of the Secure, monitor, and optimize data storage and data processing domain, which accounts for 30–35% of the DP-203 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 37 practice questions to prepare you well beyond it. (estimate)

37questions here

8free pages

13concepts

30–35%of the exam

Questions 6–10

6application · medium
A company uses Azure SQL Database and requires that all connections use encrypted connections. The company also wants to ensure that data is encrypted at rest. What should you configure?
Select an answer first
7foundation · easy
Which type of token is used to authenticate to the Azure Databricks REST API?
Select an answer first
8foundation · easy
In Azure Data Lake Storage Gen2, what do POSIX-like ACLs control?
Select an answer first
9foundation · easy
Which protocol is commonly used to encrypt data in transit between a client application and Azure SQL Database?
Select an answer first
10foundation · easy
You are loading a DataFrame in Azure Databricks that contains sensitive columns. What is the recommended practice to protect this data during processing?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-203

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-203” is a trademark of its owner, used for identification only.

Implement Data Security DP-203 Practice Questions (Page 2)

Questions 6–10

A company uses Azure SQL Database and requires that all connections use encrypted connections. The company also wants to ensure that data is encrypted at rest. What should you configure?

Which type of token is used to authenticate to the Azure Databricks REST API?

In Azure Data Lake Storage Gen2, what do POSIX-like ACLs control?

Which protocol is commonly used to encrypt data in transit between a client application and Azure SQL Database?

You are loading a DataFrame in Azure Databricks that contains sensitive columns. What is the recommended practice to protect this data during processing?

Keep studying — Secure, monitor, and optimize data storage and data processing