ExamGecko
Login
Home / Microsoft / DP-420 / List of questions
Ask Question

Microsoft DP-420 Practice Test - Questions Answers, Page 15

Add to Whishlist

List of questions

Question 141

Report Export Collapse

You have an on-premises computer named Computer1 that runs Windows 11.

On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to the API for NoSQL clients hosted by the emulator. What should you use?

Become a Premium Member for full access
  Unlock Premium Member

Question 142

Report Export Collapse

HOTSPOT

You have an Azure Cosmos DB for NoSQL account that contains a container named Container1.

You add a composite index to the default indexing policy of Container1. The index has the following definition.

FirstName ASC, age ASC

You plan to execute the following query against Container1.

Microsoft DP-420 image Question 3 63883207280770537139687

You need to optimize the performance of the query by adding an additional index.

How should you complete the additional index? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 143

Report Export Collapse

HOTSPOT

You have an Azure subscription that contains the resources shown in the following table.

Microsoft DP-420 image Question 4 6388320728078616173807

You need to query Container1 from the serverless SQL pool of workspace1.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member
Total 143 questions
Go to page: of 15
Open VPLUS File
Convert VPLUS to PDF

Related questions

HOTSPOT You have an Azure subscription. You need to deploy the following resources to an Azure Cosmos DB for NoSQL account: * A container * A user-defined function (UDF) The solution must minimize the possibility of the deployment failing. How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel. What should you include?
DRAG DROP You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB database that hosts a container named container1. You need to ensure that the items stored in contained will NOT expire unless their TTL value is set explicitly. What should you do?
HOTSPOT You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You create a container and assign the following indexing policy. You run the queries shown in the following table. For each of the following statements, select yes if the statement is true. Otherwise, select No NOTE: Each correct selection is worth one point.
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key named type. You are evaluating the resource utilization of the query. How will the query be executed?
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account! that hosts a container named Container 1. Container! has a provisioned throughput of 100 request units per second (RU/s) and uses a single physical partition. Vou are evaluating the available throughput for Container1. What is the maximum burst capacity that Container1 can accumulate?
You have an Azure Cosmos DB for NoSQL account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level. You configure account1 to use a dedicated gateway and integrated cache. You need to ensure that App1 can use the integrated cache. Which two actions should you perform for APP1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
HOTSPOT You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements. Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You define and implement an encryption policy by using the following C# code. For each of the following statements, select Yes if the statement is true, otherwise select No. NOTE: Each correct selection is worth one point.