DP-203 · Question #399
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…
The correct answer is C. 3. With a full fidelity schema, the analytical store will track both the data and their types accurately. This means different types for the same field will be stored in separate columns. Specifically: There will be one column for customerID as an integer. There will be another…
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?
Options
- A1
- B2
- C3
- D4
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- C75% (21)
- D11% (3)
Explanation
With a full fidelity schema, the analytical store will track both the data and their types accurately. This means different types for the same field will be stored in separate columns. Specifically: There will be one column for customerID as an integer. There will be another column for customerID as a string. There will be one column for customer as a string.
Topics
Community Discussion
No community discussion yet for this question.