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?

Increase the number of request units per second (RU/s) allocated to the con-product and conproductVendor containers.

Set the default consistency level of accountl to bounded staleness.

Create a private endpoint connection.

Modify the connection policy of App1.

Increase the number of request units per second (RU/s) allocated to the con-product and conproductVendor containers.

You need to provide a solution for the Azure Functions notifications following updates to conproduct.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.

Configure the trigger for each function to use a different leaseCollectionPrefix

Configure the trigger for each function to use a different leaseCollectionName

Configure the trigger for each function to use a different leaseCollectionPrefix

Configure the trigger for each function to use the same leaseCollectionNair.e

Configure the trigger for each function to use a different leaseCollectionName

Configure the trigger for each function to use the same leaseCollectionPrefix

You need to implement a solution to meet the product catalog requirements.What should you do to implement the conflict resolution policy.

Create a new container and migrate the product catalog data to the new container.

Remove frequently changed field from the index policy of the con-product container.

Disable indexing on all fields in the index policy of the con-product container.

Set the default consistency level for account1 to eventual.

Create a new container and migrate the product catalog data to the new container.

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?

the connectivity mode of the App1 CosmosClient

the indexing policy of the Azure Cosmos DB container

the consistency level of the requests from App1

the connectivity mode of the App1 CosmosClient

the default consistency level of the Azure Cosmos DB account

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 skewAvoids capacity limitsAvoids hot partitionsWhat should you do?

Create a new synthetic key that contains deviceId and a random number.

Use timestamp as the partition key.

Create a new synthetic key that contains deviceId and sensor1Value.

Create a new synthetic key that contains deviceId and deviceManufacturer.

Create a new synthetic key that contains deviceId and a random number.

You maintain a relational database for a book publisher. The database contains the following tables. The most common query lists the books for a given authorId.You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.What should you include in the solution?

Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.

Create Author, Book, and Bookauthorlnk documents in the same container.

Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.

Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

You have an Azure Cosmos DB Core (SQL) API account.You run the following query against a container in the account.SELECTIS_NUMBER("1234") AS A,IS_NUMBER(1234) AS B,IS_NUMBER({prop: 1234}) AS CWhat is the output of the query?

[{"A": false, "B": true, "C": false}]

[{"A": true, "B": false, "C": true}]

[{"A": true, "B": true, "C": false}]

[{"A": true, "B": true, "C": true}]

You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Register the trigger as a pre-trigger.

For each create request, set the trigger name in RequestOptions.

Append pre to the name of the JavaScript function trigger.

For each create request, set the access condition in RequestOptions.

Register the trigger as a pre-trigger.

For each create request, set the consistency level to session in RequestOptions.

For each create request, set the trigger name in RequestOptions.

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/ s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value.You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis.The following is a sample of a document in the container. You need to reduce the amount of request units (RUs) consumed by the analytics application.What should you do?

Move the data to a new container that has a partition key of deviceId.

Decrease the offerThroughput value for the container.

Increase the offerThroughput value for the container.

Move the data to a new container that has a partition key of deviceId.

Move the data to a new container that uses a partition key of date.

The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit. Which statement describes the configuration of the container?

Items stored in the collection will expire only if the item has a time to live value.

All items will be deleted after one year.

Items stored in the collection will be retained always, regardless of the items time to live value.

Items stored in the collection will expire only if the item has a time to live value.

All items will be deleted after one hour.

You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy.The account has a registered merge procedure that throws a runtime exception.The runtime exception prevents conflicts from being resolved.You need to use an Azure function to resolve the conflicts.What should you use?

a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger

a function that pulls items from the conflicts feed and is triggered by a timer trigger

a function that receives items pushed from the change feed and is triggered by an Azure Cosmos DB trigger

a function that pulls items from the change feed and is triggered by a timer trigger

a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger

The following is a sample of a document in orders. The orders container uses customerId as the partition key.You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:Ensure that the report can run as quickly as possible.Minimize the consumption of request units (RUs).What should you do?

Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.

Configure the report to query orders by using a SQL query.

Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.

Configure the report to query orders by using a SQL query through a dedicated gateway.

Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily.

You have the following query.SELECT * FROM ?WHERE c.sensor = "TEMP1"AND c.value < 22AND c.timestamp >= 1619146031231You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.What should you recommend?

a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)

a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)

a composite index for (sensor ASC, value ASC, timestamp ASC)

You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot.The solution must store the data in a compact binary format.Which three configuration items should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

"key.converter": "io.confluent.connect.avro.AvroConverter"

"connect.cosmos.containers.topicmap": "iot#telemetry"

"connector.class": "com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector"

"connector.class": "com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector"

"key.converter": "org.apache.kafka.connect.json.JsonConverter"

"key.converter": "io.confluent.connect.avro.AvroConverter"

"connect.cosmos.containers.topicmap": "iot#telemetry"

"connect.cosmos.containers.topicmap": "iot"

"connector.class": "com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector"

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.You need to provide a user named User1 with the ability to insert items into container1 by using rolebased access control (RBAC). The solution must use the principle of least privilege.Which roles should you assign to User1?

DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

DocumentDB Account Contributor only

Cosmos DB Built-in Data Contributor only

You have an Azure Cosmos DB Core (SQL) API account.You configure the diagnostic settings to send all log information to a Log Analytics workspace.You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified.You write the following query.AzureDiagnostics| where Category == "ControlPlaneRequests"What should you include in the query?

| where OperationName startswith "AccountUpdateStart"

| where OperationName startswith "SqlContainersDelete"

| where OperationName startswith "MongoCollectionsThroughputUpdate"

| where OperationName startswith "SqlContainersThroughputUpdate"

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours.You need to implement a solution that supports point-in-time restore.What should you do first?

Enable Continuous Backup for the account.

Configure the Backup & Restore settings for the account.

Create a new account that has a periodic backup policy.

Configure the Point In Time Restore settings for the account.

You have a database in an Azure Cosmos DB Core (SQL) API account.You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks.How should you define the command statement in the function?

cmd = "SELECT * FROM Persons pWHERE p.accountnumber = @accountnumber"

cmd = "SELECT * FROM Persons pWHERE p.accountnumber = 'accountnumber'"

cmd = "SELECT * FROM Persons pWHERE p.accountnumber = LIKE @accountnumber"

cmd = "SELECT * FROM Persons pWHERE p.accountnumber = @accountnumber"

cmd = "SELECT * FROM Persons pWHERE p.accountnumber = '" + accountnumber + "'"

You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.

Enable Azure Synapse Link for the account and Analytical store on the container.

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.

Create a private endpoint connection to the account.

In an Azure Synapse Analytics serverless SQL pool, create a view that uses OPENROWSET and the CosmosDB provider.

Enable Azure Synapse Link for the account and Analytical store on the container.

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.

You have an Azure Cosmos DB for NoSQL account.The change feed is enabled on a container named invoice.You create an Azure function that has a trigger on the change feed.What is received by the Azure function?

all the properties of the updated items

only the partition key and the changed properties of the updated items

all the properties of the original items and the updated items

only the changed properties and the system-defined properties of the updated items

You have an Azure Cosmos DB account named account1.You have several apps that connect to account1 by using the account's secondary key.You then configure the apps to authenticate by using service principals.You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.Which account property should you modify?

disableKeyBasedMetadataWriteAccess ,

You have a container named container! in an Azure Cosmos DB for NoSQL account.You need to provide a user named User1 with the ability to insert items into container1 by using rolebased access The solution must use the principle of least privilege.Which roles should you assign to User1?

Cosmos DB Built-in Data Contributor only

DocumentDB Account Contribute only

DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US.You run the following PowerShell command. What is the effect of running the command?

The account will be unavailable to writes during the change.

The provisioned throughput for account1 will increase.

The account will be configured for multi-region writes.

Microsoft DP-420 Practice Test 1 - Free Online Exam Prep & Questions

Question 1 / 40

You are troubleshooting the current issues caused by the application updates.

Which action can address the application updates issue without affecting the functionality of the application?

Enable time to live for the con-product container.

Set the default consistency level of account1 to strong.

Set the default consistency level of account1 to bounded staleness.

Add a custom indexing policy to the con-product container.

Show Case Study

Comment (0)

Microsoft DP-420 Practice Test 1

Question

Microsoft DP-420 Practice Tests

Practice Tests