Free Microsoft DP-420 Übungsprüfungen - Seite 5 von 6

Question #41

You have an Azure Cosmos DB for NoSQL account that has multiple write regions.

You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).

Which Azure Monitor signal should you use?

A . Region Removed
B . Provisioned Throughput
C . Metadata Requests
D . Data Usage

Lösung einblenden Lösung ausblenden

Question #42

HOTSPOT

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.

Lösung einblenden Lösung ausblenden

Question #43

HOTSPOT

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.

Lösung einblenden Lösung ausblenden

Question #44

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?

A . disableKeyBasedMetadataWriteAccess ,
B . disableLocalAuth
C . userAssignedldentatxe
D . allowedOrxgins

Lösung einblenden Lösung ausblenden

Question #45

You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains information about orders and their associated items.

You need to develop a model that supports order read operations. The solution must minimize the number or requests.

A . Create a single database that contains one container. Store orders and order items in separate documents in the container.
B . Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents.
C . Create a database for orders and a database for order items.
D . Create a single database that contains a container for order and a container for order items.

Lösung einblenden Lösung ausblenden

Richtige Antwort: B
B

Explanation:

Azure Cosmos DB is a multi-model database that supports various data models, such as documents, key-value, graph, and column-family3. The core content-model of Cosmos DB’s database engine is based on atom-record-sequence (ARS), which allows it to store and query different types of data in a flexible and efficient way3.

To develop a model that supports order read operations and minimizes the number of requests, you should consider the following factors:

✑ The size and shape of your data

✑ The frequency and complexity of your queries

✑ The latency and throughput requirements of your application

✑ The trade-offs between storage efficiency and query performance

Based on these factors, one possible model that you could implement is

B. Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents.

This model has the following advantages:

✑ It stores orders and order items as self-contained documents that can be easily retrieved by order ID1.

✑ It avoids storing redundant data or creating additional containers for order items1.

✑ It allows you to view the order history of a customer with simple queries1.

✑ It leverages the benefits of embedding data, such as reducing the number of requests, improving query performance, and simplifying data consistency2.

This model also has some limitations, such as:

✑ It may not be suitable for some order items that have data that is greater than 2 KB, as it could exceed the maximum document size limit of 2 MB2.

✑ It may not be optimal for scenarios where order items need to be queried independently from orders or aggregated by other criteria2.

✑ It may not support transactions across multiple orders or customers, as transactions are scoped to a single logical partition2.

Depending on your specific use case and requirements, you may need to adjust this model or choose a different one. For example, you could use a hybrid data model that combines embedding and referencing data2, or you could use a graph data model that expresses entities and relationships as vertices and edges.

Question #46

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

Lösung einblenden Lösung ausblenden

Question #47

HOTSPOT

You configure a backup for an Azure Cosmos DB for NoSQL account as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Lösung einblenden Lösung ausblenden

Richtige Antwort:

Explanation:

Box 1 = The current backup policy provides protection for: 2 Hours

Azure Cosmos DB automatically takes backups of your data at regular intervals. The backup interval and the retention period can be configured from the Azure portal. You can also choose between two backup modes: periodic backup mode and continuous backup mode. Periodic backup mode is the default mode for all existing accounts and it takes a full backup of your database every 4 hours by default. Continuous backup mode is a new mode that allows you to restore to any point of time within either 7 or 30 days1.

For your scenario, based on the exhibit, you have configured a backup for an Azure Cosmos DB for NoSQL account using the periodic backup mode with a backup interval of 1 hour and a retention period of 2 hours. This means that Azure Cosmos DB will take a full backup of your database every hour and keep only the latest two backups. Therefore, the current backup policy provides protection

for 2 hours.

Box 2: In case of emergency, you must (answer choice) to restore the backup = create a support ticket Azure Cosmos DB automatically takes backups of your data at regular intervals. You can configure the backup interval and the retention period from the Azure portal. You can also choose between two backup modes: periodic backup mode and continuous backup mode. Periodic backup mode is the default mode for all existing accounts and it takes a full backup of your database every 4 hours by default. Continuous backup mode is a new mode that allows you to restore to any point of time within either 7 or 30 days1.

For your scenario, based on the exhibit, you have configured a backup for an Azure Cosmos DB for NoSQL account using the periodic backup mode with a backup interval of 1 hour and a retention period of 2 hours. This means that Azure Cosmos DB will take a full backup of your database every hour and keep only the latest two backups. In case of emergency, you must create a support ticket to restore the backup. This is the answer to your question.

To restore data from a periodic backup, you need to create a support request with Azure Cosmos DB

team and provide the following information:

The name of your Azure Cosmos DB account

The name of the database or container that you want to restore

The date and time (in UTC) that you want to restore from

The name of the target Azure Cosmos DB account where you want to restore the data The name of the target resource group where you want to restore the data

The Azure Cosmos DB team will then initiate the restore process and notify you when it is completed2.

Question #48

HOTSPOT

You have an Azure Cosmos DB for NoSQL account.

You plan 10 create a container named container1. The container1 container will store items that include two properties named nm and age

The most commonly executed queries will query container1 for a specific name.

The following is a sample of the query.

You need to define an opt-in Indexing policy for container1.

The solution must meet the following requirements:

• Minimize the number of request units consumed by the queries.

• Ensure that the _etag property is excluded from indexing.

How should you define the indexing poky? To answer, select the appropriate options in the answer area. NOTE: Each correct selection Is worth one point.

Lösung einblenden Lösung ausblenden

Question #49

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container.

The solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom and you use the default settings for the policy.

Does this meet the goal?

A . Yes
B . No

Lösung einblenden Lösung ausblenden

Question #50

Litware plans to make multi-region writes to Cosmos DB.

Which of the following should be configured to maximize App1’s query performance after enabling multi-region writes?

A . Increase RU/s allocation for all containers
B . Create additional read regions
C . Increase the number of Azure Functions
D . Set the default consistency level to bounded staleness

Lösung einblenden Lösung ausblenden