Microsoft DP-420 Exam Questions Instant Access

Question 1

You have a database named db1in an Azure Cosmos DB for NoSQL account named account 1.

You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs.

Which should you do before you can use db1 as an output of Stream Analytics?

Ain account, add a private endpoint.

BIn db1, create containers that have a custom indexing policy and analytical store disabled.

CIn account, enable a dedicated gateway.

DIn db1, create containers that have an automatic indexing policy and analytical store enabled.

Answer : A

Question 2

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 role-based access control (RBAC). The solution must use the principle of least privilege.

Which roles should you assign to User1?

ACosmosDB Operator only

BDocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

CDocumentDB Account Contributor only

DCosmos DB Built-in Data Contributor only

Answer : A

Cosmos DB Operator: Can provision Azure Cosmos accounts, databases, and containers. Cannot access any data or use Data Explorer.

Incorrect Answers:

B: DocumentDB Account Contributor can manage Azure Cosmos DB accounts. Azure Cosmos DB is formerly known as DocumentDB.

C: DocumentDB Account Contributor: Can manage Azure Cosmos DB accounts.

Question 3

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?

ADecrease the offerThroughput value for the container.

BIncrease the offerThroughput value for the container.

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

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

Answer : C

The partition key is what will determine how data is routed in the various partitions by Cosmos DB and needs to make sense in the context of your specific scenario. The IoT Device ID is generally the 'natural' partition key for IoT applications.

Question 4

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1 and a container named Container1. You need to manage the account by using the Azure Cosmos DB SDK. What should you do?

AList the physical partitions of Container1.

BRead a stored procedure in Container1.

CCreate a user defined function (UDF) in Container1.

DCreate a container in DB1.

Answer : C

Question 5

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?

Acmd = 'SELECT * FROM Persons p
WHERE p.accountnumber = 'accountnumber''

Bcmd = 'SELECT * FROM Persons p
WHERE p.accountnumber = LIKE @accountnumber'

Ccmd = 'SELECT * FROM Persons p
WHERE p.accountnumber = @accountnumber'

Dcmd = 'SELECT * FROM Persons p
WHERE p.accountnumber = '' + accountnumber + '''

Answer : C

Azure Cosmos DB supports queries with parameters expressed by the familiar @ notation. Parameterized SQL provides robust handling and escaping of user input, and prevents accidental exposure of data through SQL injection.

For example, you can write a query that takes lastName and address.state as parameters, and execute it for various values of lastName and address.state based on user input.

SELECT *

FROM Families f

WHERE f.lastName = @lastName AND f.address.state = @addressState

Question 6

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?

ACol1 only

BCol1 and Col2 only

CCol1, Col2, and Col3 only

DCol1, Col2, and CoI4 only

Answer : D

Question 7

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 function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.

Does this meet the goal?

AYes

BNo

Answer : A

The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.

The following diagram represents the data flow and components involved in the solution:

Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB DP-420 Exam Questions