DP-600 · Question #206
DP-600 Question #206: Real Exam Question with Answer & Explanation
The correct answer is A: Data Warehouse. Option A is the correct choice as a Data Warehouse can accommodate an unlimited amount of structured data, organizing it by databases, schemas, and tables. It supports SQL for data transformation and provides comprehensive security measures, including object-level (e.g., tables,
Question
n a financial services context, a client manages approximately 8 TB of structured data, encompassing multiple schemas such as 'Customer', 'Transactions', and 'Accounts', which are organized into tables. They utilize SQL scripts for data transformation and implement object and column-level security measures to protect sensitive information. Which data store within Microsoft Fabric would be the most appropriate for this use case?
Options
- AData Warehouse
- BLakehouse
- CPower BI Datamart
- DKQL Database (Eventhouse)
Explanation
Option A is the correct choice as a Data Warehouse can accommodate an unlimited amount of structured data, organizing it by databases, schemas, and tables. It supports SQL for data transformation and provides comprehensive security measures, including object-level (e.g., tables, views, functions, stored procedures) and column-level security, row-level security, and dynamic data masking techniques.
Topics
Community Discussion
No community discussion yet for this question.