Microsoft Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 Questions & Answers

• Question 51:

  You have a database named db1 in an Azure Cosmos DB Core (SQL) API account.

  You have a third-party application that is exposed through a REST API.

  You need to migrate data from the application to a container in db1 on a weekly basis.

  What should you use?

  A. Database Migration Assistant

  B. Azure Data Factory

  C. Azure Migrate

  Correct Answer: B

  You can use Copy Activity in Azure Data Factory to copy data from and to Azure Cosmos DB (SQL API).

  The Azure Cosmos DB (SQL API) connector is supported for the following activities:

  Copy activity with supported source/sink matrix

  Mapping data flow

  Lookup activity

  Incorrect:

  Not A: Azure Migrate provides a centralized hub to assess and migrate on-premises servers, infrastructure, applications, and data to Azure. It assesses on- premises databases and migrate them to Azure SQL Database or to SQL Managed

  Instance.

  Not C: Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability

  improvements for your target environment.

  Reference:

  https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db

• Question 52:

  You have an application that queries an Azure Cosmos 06 for NoSQL account.

  You discover that the following two queries run frequently,

  

  You need to minimize the request units (RUs) consumed by reads and writes. What should you create?

  A. a composite index for (name DESC, time stamp ASC)

  B. a composite index for (name ASC, time stamp DESC)

  C. a composite index for (name ASC time stamp ASC) and a composite index for (name, time stamp disc)

  D. a composite index for (name ASC, time stamp ASC)

  Correct Answer: D

• Question 53:

  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.

  A. Use implicit session management when performing read requests.

  B. Provide a stored session token when performing read requests.

  C. Associate a session token to the user account.

  D. Set the default consistency level to eventual.

  E. Associate a session token to the device.

  Correct Answer: BC

• Question 54:

  You have a global ecommerce application that stores data in an Azure Cosmos OB for NoSQL account. The account is contoured for multi-region writes.

  You need to create a stored procedure for a custom conflict resolution policy for a new container.

  In the event of a conflict caused by a deletion the deletion must always take priority.

  Which parameter should you check m the stored procedure function?

  A. conf1ictingItems

  B. is Tombstone

  C. existingitem

  D. incoming1tem

  Correct Answer: B

• Question 55:

  You plan to create an operational system that will store data in an Azure Cosmos OB 'or NoSQL account. You need to configure the account to meet the following requirements:

  1.

  Support Spar* queries.

  2.

  Support the analysis of data from the last six months.

  3.

  Only pay for analytical compute when running queries.

  Which three actions should you perform?

  Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

  A. Create an Azure Synapse linked service.

  B. Create a container and set the time to live to six months.

  C. Create a container and set the analytical property to six months.

  D. Create an Azure Synapse pipeline.

  E. Create an Azure Databanks notebook.

  F. Enable Azure Synapse Link for the account

  Correct Answer: CEF

• Question 56:

  You have a database named db1 in an Azure Cosmos DB for NoSQL

  You are designing an application that will use dbl.

  In db1, you are creating a new container named coll1 that will store in coll1.

  The following is a sample of a document that will be stored in coll1.

  

  The application will have the following characteristics:

  1.

  New orders will be created frequently by different customers.

  2.

  Customers will often view their past order history.

  You need to select the partition key value for coll1 to support the application. The solution must minimize costs. To what should you set the partition key?

  A. id

  B. customerId

  C. orderDate

  D. orderId

  Correct Answer: B

  Based on the characteristics of the application and the provided document structure, the most suitable partition key value for coll1 in the given scenario would be the customerId, Option B. The application frequently creates new orders by different customers and customers often view their past order history. Using customerId as the partition key would ensure that all orders associated with a particular customer are stored in the same partition. This enables efficient querying of past order history for a specific customer and reduces cross-partition queries, resulting in lower costs and improved performance. a partition key is a JSON property (or path) within your documents that is used by Azure Cosmos DB to distribute data among multiple partitions3. A partition key should have a high cardinality, which means it should have many distinct values, such as hundreds or thousands1. A partition key should also align with the most common query patterns of your application, so that you can efficiently retrieve data by using the partition key value1. Based on these criteria, one possible partition key that you could use for coll1 is B:customerId.

  This partition key has the following advantages: It has a high cardinality, as each customer will have a unique ID3. It aligns with the query patterns of the application, as customers will often view their past order history3. It minimizes costs, as it reduces the number of cross-partition queries and optimizes the storage and throughput utilization1. This partition key also has some limitations, such as: It may not be optimal for scenarios where orders need to be queried independently from customers or aggregated by date or other criteria3. It may result in hot partitions or throttling if some customers create orders more frequently than others or have more data than others1. It may not support transactions across multiple customers, as transactions are scoped to a single logical partition2. Depending on your specific use case and requirements, you may need to adjust this partition key or choose a different one. For example, you could use a synthetic partition key that concatenates multiple properties of an item2, or you could use a partition key with a random or pre-calculated suffix to distribute the workload more evenly2.

• Question 57:

  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.

  A. Configure the same processor name for all the instances.

  B. Configure a different processor name for each instance.

  C. Configure a different lease container configuration for each instance.

  D. Configure the same instance name for all the instances. 13

  E. Configure a different instance name for each instance.

  F. Configure the same lease container configuration for all the instances.

  Correct Answer: AEF

• Question 58:

  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?

  A. Yes

  B. No

  Correct Answer: B

• Question 59:

  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:

  1.

  Be atomic consistent isolated, and durable (ACID).

  2.

  Provide the lowest latency. What should you do?

  A. Update the document of each family member by using a transactional batch operation.

  B. Update the document of each family member separately by using a patch operation.

  C. Update the document of each family member separately and set the consistency level to strong.

  Correct Answer: A

• Question 60:

  You have a database in an Azure Cosmos DB for NoSQL account.

  The database contains a container named container1. The indexing mode container1 is set to none.

  You configure Azure Cognitive Search to extract data from container1 and make the data searchable.

  You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.

  What should you do to resolve the issue?

  A. Modify The index attributes in Cognitive Search to searchable.

  B. Modify the index attributes in Cognitive Search to Retrievable.

  C. Change the indexing mode of container 1 to consistent-

  D. Modify the indexing policy of container 1 to exclude the / * path

  Correct Answer: C