Practice Free DP-420 Exam Online Questions

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.

Reveal Solution Hide Solution

HOTSPOT

You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stores IoT dat a. 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Yes

Need to join readings and devices.

Box 2: No

Only readings is required. All required fields are in readings.

Box 3: No

Only devices is required. All required fields are in devices.

You have operational data in an Azure Cosmos OB for NoSQL database.

Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.

You need 10 reduce the impact that running the Spark-based queries has on the database users.

What should you implement?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

You have an Azure Cosmos DB for NoSQL account.

You need to create an Azure Monitor query that lists recent modifications to the regional failover policy.

Which Azure Monitor table should you query?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

What HTTP status code does Litware frequently encounter that indicates excessive Request Unit (RU) consumption?

Reveal Solution Hide Solution

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

You need to create an alert based on a custom Log Analytics query.

Which signal type should you use?

Reveal Solution Hide Solution