
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate working on a project to implement a data de-aggregation process, you are tasked with evaluating the potential impacts of this approach. Considering the need for detailed insights for advanced analytics, while also being mindful of storage costs and data integrity, which of the following best describes the benefits and drawbacks of de-aggregation? Choose the single best option.
A
Benefits: Enables more detailed insights and advanced analytics by increasing data granularity. Drawbacks: Leads to higher storage costs and may introduce data redundancy and inconsistencies.
B
Benefits: Reduces storage costs and ensures data consistency by minimizing data granularity. Drawbacks: Limits the depth of insights and analytics capabilities due to reduced data detail.
C
Benefits: Enhances data security and speeds up data access times. Drawbacks: Complicates data update processes and risks data duplication.
D
Benefits: Streamlines the data model and simplifies data updates. Drawbacks: Increases storage needs and may degrade query performance.