Free Access Snowflake.DAA-C01.v2025-12-20.q172 Practice Test (Page 25)

Question 116

You are designing a dimensional model for a subscription-based service. You have a 'FACT SUBSCRIPTIONS' table with columns like 'subscription_id', 'customer id', 'start date', 'end date', and 'subscription_amount'. The business wants to analyze monthly recurring revenue (MRR) and churn rate. You need to model the temporal aspect of subscriptions to accurately calculate these metrics. Select the TWO best approaches to model the time dimension to facilitate these calculations:

A.Create a 'DIM_DATE table and link 'FACT_SUBSCRIPTIONS' to it using 'start_date' and 'end_date' columns.

B.Create a snapshot fact table FACT SUBSCRIPTION SNAPSHOTS that captures the state of each subscription at the end of each month. This table would include 'subscription_id' , 'customer_id', 'snapshot_date', 'is_active' , and 'subscription_amount' .

C.Store 'start_date' and 'end_date' as VARCHAR columns in the 'FACT SUBSCRIPTIONS table to avoid data type conversions.

D.Create a 'DIM_SUBSCRIPTIOW table with 'subscription_id' as the primary key and store all subscription details there, avoiding the need for a fact table.

E.Create a 'DIM MONTH' table with columns like 'month id', 'month start date', and 'month end date' and link the 'FACT SUBSCRIPTIONS table to it based on the 'start_date' falling within the month.

Question 117

How does performing data discovery through querying tables in Snowflake aid in data preparation?

A.It limits data selection options.

B.Data discovery enhances data transformation understanding.

C.It simplifies data transformation tasks.

D.Querying tables doesn't impact data preparation.

Question 118

A logistics company needs to determine which warehouses are within a 50km radius of a new distribution center. The warehouse locations are stored in a table 'WAREHOUSES' with columns 'WAREHOUSE ID' ONT), (GEOGRAPHY) and the distribution center's location is stored in a variable of type GEOGRAPHY. Which query will efficiently identify all warehouses within the specified radius, returning the 'WAREHOUSE ID and distance in kilometers?

A.Option A

B.Option B

C.Option C

D.Option D

E.Option E

Question 119

Which of the following statements regarding Secure Views and Materialized Views in Snowflake are CORRECT? (Choose two)

A.Secure Views obfuscate the underlying query logic from users, while Materialized Views store pre-computed data for faster query performance.

B.Materialized Views can only be created on tables, not on other views or functions.

C.Secure Views incur a performance overhead compared to standard views, while Materialized Views generally improve query performance for suitable workloads.

D.Both Secure Views and Materialized Views can be automatically refreshed based on data changes in the underlying tables.

E.Secure Views can be used in conjunction with Row Access Policies to control data visibility at a granular level. Materialized views cannot be used in conjunction with row access policies.

Question 120

When enriching data with Snowflake Marketplace, what role do data shares play in joining external data with existing datasets?

A.Data shares only work with Snowflake-provided datasets.

B.Data shares facilitate secure data exchange between parties.

C.They restrict access to external data.

D.They limit the types of data that can be joined.

Latest Upload: 448PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 584Nokia.4A0-113.v2026-05-01.q69; 613EC-COUNCIL.312-49v11.v2026-04-30.q214; 595Microsoft.MB-820.v2026-04-30.q101; 439Salesforce.MC-202.v2026-04-30.q57; 480BICSI.INSTC_V8.v2026-04-29.q53; 581NMLS.MLO.v2026-04-28.q82; 404NCARB.Project-Management.v2026-04-28.q27; 759EMC.D-AV-DY-23.v2026-04-27.q184; 1987ServiceNow.CSA.v2026-04-27.q483

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File