DAA-C01 Exam Dumps | A retail company has data about their products, sales, and inventory. They need a dashboard to visualize

<< Prev Question Next Question >>

Question 106/151

A retail company has data about their products, sales, and inventory. They need a dashboard to visualize key metrics, including total sales, average order value, inventory levels, and product performance across different regions. The data is stored in the following tables: 'PRODUCTS (PRODUCT ID, PRODUCT NAME, CATEGORY, PRICE) 'SALES' (SALE_ID, PRODUCT_ID, SALE_DATE, QUANTITY, REGION) 'INVENTORY (PRODUCT ID, REGION, QUANTITY ON_HAND) Which of the following strategies will result in an efficient dashboard that allows users to quickly filter and drill down into the data by region, product category, and time period while minimizing query execution time? (Select all that apply.)

A. Create a single, wide denormalized table containing all the necessary data from the 'PRODUCTS, 'SALES, and 'INVENTORY tables using JOINs. Build the dashboard directly on this table.

B. Create separate views for sales, inventory, and product information, then use the dashboard tool to join these views and perform aggregations.

C. Utilize Snowflake's search optimization service on relevant columns (e.g., PRODUCT ID, REGION) in the base tables and use standard JOINs and aggregations within views used by the dashboard.

D. Create materialized views that pre-aggregate sales data by region, product category, and time period (e.g., daily, weekly, monthly). Join these materialized views with product and inventory data in the dashboard queries.

E. Implement dynamic data masking policies to filter out sensitive data from the base tables, ensuring data governance.

Question 106/151

LEAVE A REPLY

Download PDF File