DP-420 Questions and Answers

You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

You have a container m an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents.

Each document contains the address of each family. Members of the same family share the same partition key named family Id

You need to update the address for each member of the same family that share the same address. The solution must meet the following requirements:

• Be atomic consistent isolated, and durable (ACID).

• Provide the lowest latency.

What should you do?

You provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second {RU/s) to 20,000.

For how many RU/s will you be charged when the actual RU/s usage is zero?

You configure multi-region writes for account1.

You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements.

What should you do?

You have an Azure subscription.

You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to ten books. Typical and frequent queries of the data will include:

• All books written by an individual author

• The synopsis of individual books

You need to recommend a data model for DB1. The solution must meet the following requirements:

• Support transactional updates of the author and book data.

• Minimize read operation costs.

What should you recommend?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.

Backups for account1 have the following configurations:

• Interval: 2 hours

• Retention period: 4 days

You need to estimate the charges associated with the retention of the backups. How many copies of the backups will incur additional charges?

You have an Azure Synapse Analytics workspace named workspace1 that contains a server less SQL pool.

You have an Azure Table Storage account that stores operational data.

You need to replace the Table storage account with Azure Cosmos DB for NoSQL The solution must meet the following requirements:

• Support Queries from the server less SQL pool.

• Only pay for analytical compute when running queries.

• Ensure that analytical processes do

NOTE: affect operational processes.

Which three 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.

You have an on-premises computer named Computer1 that runs Windows 11.

On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to the API for NoSQL clients hosted by the emulator. What should you use?

You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.

You discover that every query consumes request units (RUs) instead of using the cache.

You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.

You verify that the dedicated gateway cluster is provisioned and used in the connection string.

You need to ensure that App1 uses the Azure Cosmos DB integrated cache.

What should you configure?

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 sett 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 a container named conlainer1 in an Azure Cosmos DB for NoSQL account.

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure function to copy data to another Azure Cosmos DB for NoSQL container.

Does this meet the goal?

You plan to create a container named Container1 in an Azure Cosmos DB for NoSQL account Container! will store items that contain user sign-in session data from multiple organizations. Each user is assigned to a single organization.

Contained will include the following properties:

• Userld

• Sessionld

• SessionStart

• Organizationld

The following are common queries served by Container1.

SELECT SessionID,SessionStart,UserID FROM c WHERE Organizationld = 6 AND Userld = 50143

SELECT SessionID,SessionStart,UserID FROM c WHERE Organizationld - 6

You need to recommend a partitioning scheme for Container! that meets the following requirements:

You need to recommend a partitioning scheme for Container! that meets the following requirements:

• Maximizes performance

• Minimizes the cost of read queries

• Minimizes the possibility of reaching the partition size limits

Which type of partition key and which partition key properties should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a container m an Azure Cosmos DB for NoSQL account.

Data update volumes are unpredictable.

You need to process the change teed of the container by using a web app that has multiple instances. The change feed will be processed by using the change feed processor from the Azure Cosmos DB SDK. The multiple instances must share the workload.

Which three actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have an Apache Spark pool in Azure Synapse Analytics that runs the following Python code in a notebook.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL container. The container contains items that have the following properties.

You need to protect the data stored in the container by using Always Encrypted. For each property, you must use the strongest type of encryption and ensure that queries execute properly.

What is the strongest type of encryption that you can apply to each property? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are developing a web app named App1 that will store customer-generated content in an Azure Cosmos DB for NoSQL database named DB1.

You configure an Azure Al Search indexer to automatically ingest documents from DB1 into an Azure Al Search index.

App1 uses REST APIs to provide advanced search and retrieval capabilities for the documents.

You need to identify which types of queries you can use in Azure Al Search to retrieve text data. The solution must minimize development effort

Which two query types can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure Data Factory pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.

Does this meet the goal?

You have an Azure Cosmos DB for NoSQL account that hosts a container named Container1.

You implement a change feed processor.

You discover that the processor is processing changes more slowly than the changes occur in Container1.

You need to resolve the issue.

What should you use?

You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stores IoT data. The database contains two containers named readings and devices.

Documents in readings have the following structure.

id

deviceid

timestamp

ownerid

measures (array)

- type

- value

- metricid

Documents in devices have the following structure.

id

deviceid

owner

- ownerid

- emailaddress

- name

brand

model

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.

You configure account1 to use a dedicated gateway and integrated cache.

You need to ensure that App1 can use the integrated cache.

Which two actions should you perform for APP1? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.

The most executed query will return data for a matrix that aggregates the monthly sales ot each business category. The matrix will use customer business categories as columns and months as rows.

You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run th e query.

Which property should you use for the partition key?

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.

You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.

You discover that function1 runs, but not on every upsert.

You need to ensure that function1 processes each upsert within one second of the upsert.

Which property should you change in the Function.json file of function1?

You have an Azure Cosmos DB for NoSQL account named account1.

In account 1, you plan to create a container named container1 that will contain data continuously collected from sell-driving cars. The items in container! will be accessed mostly by using queries that target data collected from a specific car during a given day. Each car is identifiable by using a property named Vehicle-Identification-Number.

You need to identify a partition strategy for container1. The strategy must meet the following requirements:

• Maximize read and write performance.

• Minimize the costs of data reads and writes.

What should you identify?

You have an Azure Cosmos DB container named container1.

You need to insert an item into contained. The solution must ensure that the item is deleted automatically after two hours.

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

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB container named container! that has a provisioned throughput and two physical partitions. You monitor the following metrics for container1

• Normalized RU consumption

• The percentage of requests that have an HTTP status code of 429

You need to confirm that container1 is configured to maximize resource utilization.

What are the optimal values for each metric? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level.

App1 queries an Azure Cosmos DB for NoSQL account named account!

You need to identify which consistency level to assign to App1 to meet the following requirements:

• Maximize the throughput of the queries generated by App1 without increasing the number of request units currently used by the queries.

• Provide the highest consistency guarantees.

Which consistency level should you identify?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You run the following query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.

The following is a sample of the data.

You need to select a partition key that meets the following requirements for writes:

Minimizes the partition skew

Avoids capacity limits

Avoids hot partitions

What should you do?

You have an Azure Cosmos DB for NoSQL database that hosts the containers shown in the following table.

You need to ensure that when a product name changes in the Products container, the product name changes in all orders that have NOT been shipped.

What should you implement?

You have an Azure Cosmos DB database that contains a container named container 1. The container1 container is configured with a maximum of 20,000 RU/s and currently contains 240 GB of data.

You need to estimate the costs of container1 based on the current usage.

How many RU/s will be charged?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. You plan to configure the Apache Kafka service as a data source for account1. What should you use to store the Kafka configuration?

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 a container named container! in an Azure Cosmos DB for NoSQL account.

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure function that uses the Azure Cosmos 08 for NoSQL change feed as a trigger and an Azure event hub as the output.

Does this meet the goal?

You have an app named App1 that uses an Azure Cosmos DB for NoSQL database.

App1 uses the spatial columns shown in the following table.

You need to design an indexing strategy for App1.

Which columns can be indexed by using spatial indexes?

You are building an application that will store data in an Azure Cosmos DB for NoSQL account. The account uses the session default consistency level. The account is used by five other applications. The account has a single read-write region and 10 additional read regions.

Approximately 20 percent of the items stored in the account are updated hourly.

Several users will access the new application from multiple devices.

You need to ensure that the users see the same item values consistently when they browse from the different devices. The solution must not affect the other applications.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.