DP-203 Certification Practice Question #88

Question

You have an Azure subscription that contains an Azure Cosmos DB database. Azure Synapse Link is implemented on the database.

You configure a full fidelity schema for the analytical store.

You perform the following actions:

•	Insert {"customerID": 12, "customer": “Tailspin Toys"} as the first document in the container.
•	Insert {"customerID": "14", "customer": "Contoso"} as the second document in the container.

How many columns will the analytical store contain?

Accepted Answer

In full fidelity schema mode, Azure Cosmos DB analytical store preserves mixed-type properties instead of collapsing them into a single column. Here, `customerID` appears once as an integer and once as a string, so those are stored separately, while `customer` remains a single string column. That yields a total of three columns.

More DP-203 practice questions