DP-420 practice questions 101–106

1. Question 101 · 106 in bank

   You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You need to write a SQL query that will return multiple items. The solution must meet the following requirements: • For each item returned, include the current Coordinated Universal Time (UTC) date and time, formatted as an ISO 8601 string. • Minimize development effort. What should you use?

   • Aa user-defined function
   • BGetCurrentTimestamp()
   • CGetCurrentDateTime()
   • DDateTimePart()

   Show answer

   Answer: C

   Next question

2. Question 102 · 106 in bank

   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 Col4 only

   Show answer

   Answer: D

   Next question

3. Question 103 · 106 in bank

   You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. 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 skew • Avoids capacity limits • Avoids hot partitions What should you do?

   • AUse deviceId as the partition key.
   • BCreate a new Synthetic key that contains deviceId and deviceManufacturer.
   • CUse deviceManufacturer as the partition key.
   • DCreate a new synthetic key that contains deviceId and a random number.

   Show answer

   Answer: D

   Next question

4. Question 104 · 106 in bank

   You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. 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 skew • Avoids capacity limits • Avoids hot partitions What should you do?

   • AUse deviceId as the partition key.
   • BCreate a new synthetic key that contains deviceId and timestamp.
   • CUse sensor1value as the partition key.
   • DCreate a new synthetic key that contains deviceId and sensor1Value.

   Show answer

   Answer: B

   Next question

5. Question 105 · 106 in bank

   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?

   • AComputer1 and the credentials used when installing the emulator
   • Blocalhost:443 and the built-in Administrator user account credentials
   • CComputer1 and a randomly-generated key
   • Dlocalhost:8081 and a well-known key

   Show answer

   Answer: D

   Next question

6. Question 106 · 106 in bank

   You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1. You develop a software as a service (SaaS) app named App1 that uses DB1. App1 will be used by multiple vendors to manage their customers. You need to create a container in DB1 that will store customer and order details for each vendor. The solution must meet the following requirements: • Each vendor must have a unique tenant ID. • The performance of the container must be optimized for reads. • Customer IDs can be duplicated across the container but must be unique for each vendor. • The container must be optimized for concurrent queries from multiple customers. Each query will return data for a single vendor. How should you configure the container?

   • AAdd a partition key to the tenant ID and a unique key policy to the customer ID.
   • BAdd hierarchical partition key on (tenant identifier, customer identifier).
   • CAdd a partition key to the customer ID and a unique key policy to the tenant ID.
   • DAdd hierarchical partition key on (customer identifier, tenant identifier).

   Show answer

   Answer: B

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-420 practice, question 101. 106 questions available.