DP-420 Practice Questions

You have a Retrieval-Augmented Generation (RAG) application that uses an Azure Cosmos DB for NoSQL container.

The container stores product items that have a property named description for searchable text and a property named descriptionVector for embeddings. The container has a full-text index on /description and a DiskANN vector index on /descriptionVector.

You need to return the 10 items that rank the highest based on both semantic similarity and full-text relevance.

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

NOTE: Each correct selection is worth one point.

You have an agent that uses Azure Cosmos DB for NoSQL to store agent memory. The agent has the following Python code.

provider = CosmosMemoryContextProvider(...)
agent = Agent(context_providers=[provider])

async with provider:
    session1 = agent.create_session()
    session1.state.setdefault(provider.source_id, {})["user_id"] = "user-101"

    await agent.run("I avoid sesame.", session=session1)
    await provider.flush()

    session2 = agent.create_session()
    session2.state.setdefault(provider.source_id, {})["user_id"] = "user-101"

    await agent.run(
        "Which seed should recipes exclude for me?",
        session=session2
    )

    session3 = agent.create_session()
    session3.state.setdefault(provider.source_id, {})["user_id"] = "user-202"

    await agent.run(
        "Which seed should recipes exclude for me?",
        session=session3
    )

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 the following T-SQL query that runs against Azure Cosmos DB data mirrored to Microsoft Fabric.

SELECT
    s.id AS shipmentId,
    p.storageTemperature,
    i.itemId,
    x.weight
FROM dbo.ShipmentEvents AS s
CROSS APPLY OPENJSON(s.packages)
WITH (
    storageTemperature int '$.storageTemperature',
    items nvarchar(max) '$.items' AS JSON
) AS p
OUTER APPLY OPENJSON(p.items)
WITH (
    itemId varchar(40) '$.id',
    properties nvarchar(max) '$.properties' AS JSON
) AS i
OUTER APPLY OPENJSON(i.properties)
WITH (
    weight int '$.weight'
) AS x
WHERE p.storageTemperature >= 5;

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 Cosmos DB for NoSQL account named Account1 that has public network access disabled and uses a private endpoint. Account1 contains the data shown in the following table.

You plan to implement a Microsoft Fabric workspace in the same Azure region as Account1. The workspace will contain mirrored databases from the account. You will use the SQL analytics endpoint to calculate daily net transaction amounts by product category and transaction type.

You need to configure Fabric mirroring. The solution must mirror only the containers required for the analysis.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

• Ensure that User1 can manage db1.
• Prevent User1 from accessing connection strings.
• Prevent User1 from accessing the data stored in db1.