DP-203 · Question #399
DP-203 Question #399: Real Exam Question with Answer & Explanation
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 colu
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
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.
Community Discussion
No community discussion yet for this question.