You're tasked with building a data model in Snowflake for a retail company. The company has data on products ('PRODUCTS), sales transactions ('SALES), and customer demographics ('CUSTOMERS). You need to design a star schema to support efficient analysis of sales performance by product category and customer segment. Which of the following statements accurately describes the recommended table design and relationships within the star schema for this scenario?

• A.Create a single, denormalized table containing all product, sales, and customer information to maximize query performance.
• B.Design a fact table CSALES_FACT) with foreign keys to dimension tables for 'PRODUCTS', 'CUSTOMERS, and a DATE' dimension. The 'SALES_FACT table should contain measures such as 'SALES AMOUNT and 'QUANTITY SOLD.
• C.create separate fact tables for each product category (e.g., and link them to the 'CUSTOMERS' dimension table.
• D.Use a snowflake schema design, where the dimension tables (e.g., 'PRODUCTS', 'CUSTOMERS) are further normalized into related tables to reduce data redundancy.
• E.Maintain the original normalized tables ('PRODUCTS', 'SALES', 'CUSTOMERS') and create views that join these tables as needed for reporting purposes.

Comment: *

Name: *

Email: *

Verification: *

How do materialized views differ from secure views in data analysis?

• A.Secure views provide precomputed snapshots, unlike materialized views.
• B.Materialized views offer enhanced data security while allowing selective data access.
• C.Secure views precompute data, unlike materialized views.
• D.Materialized views restrict data access for improved security.

Comment: *

Name: *

Email: *

Verification: *

A Snowflake table 'USER ACTIVITY' contains a column 'ACTIVITY TIMESTAMP' of type VARCHAR, which stores timestamps in different formats, including ISO 8601 (e.g., '2023-10-27 Unix epoch seconds (e.g., '1698400800'), and milliseconds (e.g., '1698400800000'). You need to convert all these timestamps into a consistent TIMESTAMP NTZ data type in Snowflake. Which approach offers the most efficient and accurate solution for converting these diverse timestamp formats into a unified TIMESTAMP NTZ?

• A.Use a series of 'CASE' statements with ' TO_TIMESTAMP' and multiple format strings to parse each format individually.
• B.Create separate temporary tables for each timestamp format using 'TO_TIMESTAMP' , then UNION ALL them together.
• C.Use a UDF (User-Defined Function) that intelligently detects the timestamp format and applies the appropriate conversion function CTO TIMESTAMP , etc.).
• D.First convert epoch milliseconds to epoch seconds by dividing by 1000. Then use a single 'TO TIMESTAMP' function assuming default ISO 8601 format.
• E.Utilize Snowflake's automatic type conversion capabilities by simply changing the column's data type to TIMESTAMP_NTZ using ALTER TABL

Comment: *

Name: *

Email: *

Verification: *

You are responsible for maintaining a dashboard displaying real-time website traffic data'. The data is ingested into a Snowflake table named 'WEB EVENTS using Snowpipe from cloud storage. The 'WEB EVENTS' table includes 'EVENT TIMESTAMP' , 'PAGE URL' , and 'USER ID columns. The dashboard requires near real-time updates, but you are noticing significant latency. Which of the following actions, performed in isolation, is LEAST likely to improve the dashboard update frequency?

• A.Optimize the Snowpipe configuration by adjusting the 'COPY INTO' statement to use file format options appropriate for the source data (e.g., compression, field delimiters).
• B.Create a materialized view that pre-aggregates the data needed for the dashboard and configure it for automatic refresh.
• C.Increase the size of the Snowflake virtual warehouse used for Snowpipe data loading.
• D.Refactor dashboard queries to directly query the 'WEB EVENTS' table without any aggregations or transformations.
• E.Reduce the frequency of micro-batch data loading by increasing the Snowpipe 'AUTO_INGEST schedule to reduce the number of pipe executions per minute.

Comment: *

Name: *

Email: *

Verification: *

You are tasked with creating a data access strategy for a marketing analytics team. They need access to customer purchase data, but only aggregated by region and product category. They should not be able to see individual customer details due to PII compliance. You decide to use a Secure View. Which of the following are the MOST appropriate steps to ensure data security and minimize performance impact?

• A.Create a regular view that aggregates the data and grant SELECT privilege on the view to the marketing analytics role.
• B.Create a Secure View that aggregates the data and grant SELECT privilege on the view to the marketing analytics role.
• C.Create a Materialized View that aggregates the data. Create a Secure View on top of the Materialized View and grant SELECT privilege on the secure view to the marketing analytics role.
• D.Create a Secure View directly on the base tables with the aggregation logic. Grant SELECT privilege on the view to the marketing analytics role.
• E.Create a Materialized View directly on the base tables with the aggregation logic. Grant SELECT privilege on the Materialized View to the marketing analytics role.

Comment: *

Name: *

Email: *

Verification: *