DRAG DROP (Drag and Drop is not supported)You are developing a .NET application that uses Azure Cosmos DB for NoSQL to store application data.The application uses the Azure Cosmos DB for NoSQL SDK to interact with the database account.The application must perform the following tasks:-Initialize the connection by using the account endpoint and key.-Define shared throughput.-Perform create, read, update, and delete (CRUD) operations on items stored in a container.You need to implement the SDK components required for the application to access and manage data in Azure Cosmos DB for NoSQL.Which SDK components should you use? To answer, move the appropriate components to the correct requirements. You may use each component once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.Note: Each correct selection is worth one point.Select and Place:
Answer(s): A
Box 1: CosmosClient To initialize the connection to an Azure Cosmos DB for NoSQL account using the account endpoint and key,you must use the CosmosClient class.Box 2: Database The database SDK component should be used to define shared throughput.In Azure Cosmos DB, shared throughput (provisioned Request Units per second or RU/s) is configured at the database level. When throughput is provisioned on a database, that capacity is shared among all the containers created within that specific database.Box 3: Container To perform item create, read, update, and delete (CRUD) operations, you should use the Container SDK componentIn the Azure Cosmos DB for NoSQL SDK for .NET, individual JSON documents (items) live inside a container. The Container class exposes the specific methods required to execute CRUD operations on these items.
https://learn.microsoft.com/en-us/azure/cosmos-db/how-to-dotnet-get-started
DRAG DROP (Drag and Drop is not supported)You are developing a new page for a website that uses Azure Cosmos DB for data storage. The feature uses documents that have the following format:You must display data for the new page in a specific order. You create the following query for the page:You need to configure an Azure Cosmos DB policy to support the query.How should you configure the policy? To answer, drag the appropriate JSON segments to the correct locations. Each JSON segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Note: Each correct selection is worth one point.Select and Place:
Box 1: compositeIndexes Azure Cosmos DB requires a defined composite index for any query utilizing an ORDER BY clause with multiple properties.Box 2: descendingIn an ORDER BY clause, properties without an explicit direction default to ascending order. Your query ORDER BY p.name, p.city DESC translates to an ascending sort on /name and a descending sort on /city.
https://docs.azure.cn/en-us/cosmos-db/index-policy
You are designing an Azure Database for PostgreSQL table for semantic search. Queries frequently filter on the created_at column.The schema must support vector similarity search and reliable date filtering.You need to ensure that the table meets the requirements.Which two actions should you perform? Each correct answer presents part of the solution.Note: Each correct selection is worth one point.
Answer(s): B,D
To meet the requirements, store embeddings in a pgvector column and use a typed timestamp column for created_at. These two steps enable high-dimensional vector similarity operations and allow efficient, reliable date-based filtering.Store embeddings in a pgvector column: Enables the database to store and query high-dimensional vector embeddings using native similarity operators.Use a typed timestamp column for created_at: Ensures accurate date-and-time comparisons, indexing, and dependable performance when filtering queries by creation date.
https://learn.microsoft.com/en-us/training/modules/implement-vector-search-azure-database-postgresql/
HOTSPOT (Drag and Drop is not supported)You have a web service that is used to pay for food deliveries. The web service uses Azure Cosmos DB as the data store.You plan to add a new feature that allows users to set a tip amount. The new feature requires that a property named tip on the document in Azure Cosmos DB must be present and contain a numeric value.There are many existing websites and mobile apps that use the web service that will not be updated to set the tip property for some time.How should you complete the trigger?Note: Each correct selection is worth one point.Hot Area:
Box 1: getContext().getRequest(); Y: if (!i["tip"]) { (or alternatively: depending on your specific exam question version)Z:Box 2: if (isNaN(i["tip"]) || i["tip"] === null) {Box 3: r.setBody(i);
DRAG DROP (Drag and Drop is not supported)You are developing a Python application that reads data from Azure Cosmos DB for NoSQL by using the azure-cosmos SDK.You need to connect to an existing account and run a SQL query against an existing container.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
In the azure-cosmos Python SDK, you do not use an explicit "InitializeDatabaseProxy" method. Instead, you use the client to get a database reference, and then use that database reference to get a container reference.Step 1: Initialize CosmosClient You must first establish the root connection using the client object with your account endpoint and credentials.Step 2: Specify the database name From the client, you call client.get_database_client(database_name) to target your specific database resource.Step 3: Obtain the container reference From the database proxy object, you call database.get_container_client(container_name) to reference the specific data container.Step 4: Run the Query Finally, you execute the SQL operation directly on that container using container.query_items().
https://learn.microsoft.com/en-us/azure/cosmos-db/quickstart-python
Post your Comments and Discuss Microsoft AI-200 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AI-200 content, but please register or login to continue.