You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name
`account1` -FailoverPolicy @(`East US`, `West US`)
What is the effect of running the command?

• A. The account will be unavailable to writes during the change
• B. The account will be configured for multi-region writes
• C. A manual failover will occur
• D. The provisioned throughput for account1 will increase

Hotspot Question
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores order details, including the following properties:
- OrderNumber (a number)
- OrderDate (a date)
You need to write a query that returns the following for each order:
- OrderNumber
- PeriodDate (as the first day of the calendar year based on orderDate) How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point

Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You have an Azure Cosmos DB for NoSQL database. The database hosts a container named families that stores data in the following format.

You need to return the following data:
- The ID of the family
- The family names of the children
- The name of any pets if the pet is a cat
Solution: You run the following query.

Does this meet the goal?

• A. Yes
• B. No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.
Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.
Does this meet the goal?

• A. Yes
• B. No