DP-600 · Question #206
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…
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…
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)
How the community answered
(21 responses)- A76% (16)
- B14% (3)
- C5% (1)
- D5% (1)
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.