Microsoft Exam DP-203 Topic 3 Question 43 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 43
Topic #: 3

You are designing database for an Azure Synapse Analytics dedicated SQL pool to support workloads for detecting ecommerce transaction fraud.

Data will be combined from multiple ecommerce sites and can include sensitive financial information such as credit card numbers.

You need to recommend a solution that meets the following requirements:

Users must be able to identify potentially fraudulent transactions.

Users must be able to use credit cards as a potential feature in models.

Users must NOT be able to access the actual credit card numbers.

What should you include in the recommendation?

ATransparent Data Encryption (TDE)

Brow-level security (RLS)

Ccolumn-level encryption

DAzure Active Directory (Azure AD) pass-through authentication

Show Suggested Answer

Suggested Answer: C

Use Always Encrypted to secure the required columns. You can configure Always Encrypted for individual database columns containing your sensitive data. Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national identification numbers (for example, U.S. social security numbers), stored in Azure SQL Database or SQL Server databases.

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine

by Skye at May 08, 2022, 01:21 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!