DP-200 Exam Question 201

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22).
You need to implement masking for the Customer_ID field to meet the following requirements:
* The first two prefix characters must be exposed.
* The last four suffix characters must be exposed.
* All other characters must be masked.
Solution: You implement data masking and use a credit card function mask.
Does this meet the goal?
  • DP-200 Exam Question 202

    A company is planning to use Microsoft Azure Cosmos DB as the data store for an application. You have the following Azure CLI command:
    az cosmosdb create --name "cosmosdbdev1" --resource-group "rgdev"
    You need to minimize latency and expose the SQL API. How should you complete the command? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-200 Exam Question 203

    You have an Azure Databricks resource.
    You need to log actions that relate to compute changes triggered by the Databricks resources.
    Which Databricks services should you log?
  • DP-200 Exam Question 204

    You are building the data store solution for Mechanical Workflow.
    How should you configure Table1? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-200 Exam Question 205

    A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database.
    You must perform an assessment of databases to determine whether data will move without compatibility issues.
    You need to perform the assessment.
    Which tool should you use?