DP-200 Exam Question 146

You have an Azure SQL database that contains a table named Customer. Customer contains the columns shown in the following table.

You apply a masking rule as shown in the following table.

Which users can view the email addresses of the customers?
  • DP-200 Exam Question 147

    A company has a SaaS solutions that will uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization Customer organizations have peak usage at different periods during the year.
    Which two factors affect your costs when sizing the Azure SQL Database elastic pools? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point.
  • DP-200 Exam Question 148

    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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a container named Sales in an Azure Cosmos DB database. Sales has 120 GB of data. Each entry in Sales has the following structure.

    The partition key is set to the OrderId attribute.
    Users report that when they perform queries that retrieve data by ProductName, the queries take longer than expected to complete.
    You need to reduce the amount of time it takes to execute the problematic queries.
    Solution: You create a lookup collection that uses ProductName as a partition key and OrderId as a value.
    Does this meet the goal?
  • DP-200 Exam Question 149

    You are the data engineer tor your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type.
    Developers need to access data in the database using an API.
    You need to determine which API to use for the database model and type.
    Which two APIs should you use? Each correct answer presents a complete solution.
    NOTE: Each correct selection s worth one point.
  • DP-200 Exam Question 150

    Your company uses Azure SQL Database and Azure Blob storage.
    All data at rest must be encrypted by using the company's own key. The solution must minimize administrative effort and the impact to applications which use the database.
    You need to configure security.
    What should you implement? To answer, select the appropriate option in the answer area.
    NOTE: Each correct selection is worth one point.