HOTSPOT
You configure Azure Cognitive Search to index a container in an Azure Cosmos DB Core (SQL) API account as shown in the following exhibit.
[sampleXML/xmlfile-76_1.jpg]
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.
Hot Area:
[sampleXML/xmlfile-77_1.png]
Show Answer
Correct Answer: Country
Name
Explanation: Country is filterable, so it supports exact-match filters. Name is not retrievable, so it cannot be returned in search results.
Question 82
HOTSPOT
You are developing an application that will connect to an Azure Cosmos DB Core (SQL) API account. The account has a single read-write region and one
additional read region. The regions are configured for automatic failover.
The account has the following connection strings. (Line numbers are included for reference only.)
[sampleXML/xmlfile-67_1.png]
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
[sampleXML/xmlfile-68_1.png]
Show Answer
Correct Answer: No
No
Yes
Explanation: The connection strings’ keys determine access permissions; they do not select a specific region. With automatic failover, the client can use the newly designated write region.
Question 83
You have an Azure Cosmos DB database named database1 that contains a container named container1. The container1 container stores product data and has the following indexing policy.
Which path will be indexed?
A. /product/category
B. /product/brand/tailspin
C. /product/brand
D. /product/[]/category
Show Answer
Correct Answer: B
Explanation: The included wildcard covers the nested path `/product/brand/tailspin`. The exclusion targets the `brand` scalar path, not all descendants beneath it, so `tailspin` remains indexed.
Question 84
HOTSPOT
You have the indexing policy shown in the following exhibit.
[sampleXML/xmlfile-98_1.jpg]
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:
[sampleXML/xmlfile-99_1.png]
Show Answer
Correct Answer: ORDER BY c.name DESC, c.age DESC
At the same time as item creation
Explanation: The composite index lists name before age. It supports an ORDER BY in that order with both directions reversed. With consistent indexing, the index is updated when the item is created.
Question 85
You have an Azure Cosmos DB account named account1.
You need to access account1 from an on-premises environment by using a Site-to-Site VPN.
What should you use?
A. a private endpoint
B. a dedicated gateway
C. Azure Synapse Link
Show Answer
Correct Answer: A
Explanation: Use a private endpoint to give Azure Cosmos DB a private IP address in an Azure virtual network. The on-premises environment can reach it through the Site-to-Site VPN.
Question 86
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.
Explanation: Filtered properties need deterministic encryption so queries can match their values. Because healthStatus is not filtered, it can use the stronger randomized encryption.
Question 87
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. userAssignedIdentities
D. allowedOrigins
Show Answer
Correct Answer: B
Explanation: Set `disableLocalAuth` to `true` to disable key-based (local) authentication for the Cosmos DB account, so apps must authenticate using Microsoft Entra ID. `userAssignedIdentities` assigns identities to the account; it does not disable key authentication.
Question 88
You plan to create an operational system that will store data in an Azure Cosmos DB Core (SQL) API account.
You need to configure the account to meet the following requirements:
• Support Spark queries.
• Support the analysis of data from the last six months.
• Only pay for analytical compute when running queries.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Enable Azure Synapse Link for the account.
B. Create a container and set the analyticalTTL property to six months.
C. Create an Azure Databricks notebook.
D. Create an Azure Synapse linked service.
E. Create a container and set the time to live to six months.
F. Create an Azure Synapse pipeline.
Show Answer
Correct Answer: A, B, D
Explanation: Enable Azure Synapse Link to make the Cosmos DB analytical store available. Set the container’s analyticalTTL to six months so analytical data is retained for that period without changing transactional-data retention. Create an Azure Synapse linked service to connect Synapse—where Spark queries can run—to the Cosmos DB account. Synapse Link separates analytical storage from transactional workloads, so analytical compute is consumed when queries run.
Question 89
You develop an application that uses Azure Cosmos DB Core (SQL) API.
You create an Azure pipeline to build and deploy the application.
You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline.
What should you add to the pipeline?
A. a deployment group named Cosmos DB testing
B. an Azure Cosmos DB Emulator task
C. a NuGet service connection that uses an Azure Cosmos DB API key
D. a secret variable that has a connection string to an Azure Cosmos DB database
Show Answer
Correct Answer: B
Explanation: The Azure Cosmos DB Emulator task starts a database emulator within the pipeline so the integration tests can run there without depending on an external Cosmos DB instance. A secret connection string alone would not provide a database in the pipeline.
Sources:
https://learn.microsoft.com/en-us/azure/cosmos-db/tutorial-setup-ci-cd
Question 90
HOTSPOT
You have a multi-region Azure Cosmos DB account named account1 that has a default consistency level of strong.
You have an app named App1 that is configured to request a consistency level of session.
How will the read and write operations of App1 be handled? To answer, select the appropriate options in the answer area.
Show Answer
Correct Answer: Write operations: Write and replicate data to every region synchronously.
Read operations: Performed by the replica to which App1 is connected.
Explanation: The account’s strong consistency setting still governs writes. App1’s session-consistency request allows reads from its connected replica.
$19
Get all 177 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
