What effect do row access policies have on the creation of dashboards concerning user data visibility?

• A.Row access policies offer unrestricted data visibility.
• B.Row access policies don't influence data visibility in dashboards.
• C.They limit data visibility based on user privileges.
• D.Row access policies impact dashboard creation negatively.

Comment: *

Name: *

Email: *

Verification: *

A telecommunications company wants to segment its customers based on their usage patterns for targeted marketing campaigns. You have access to a table named 'CUSTOMER USAGE with the following columns: 'CUSTOMER ONT), 'DATA USAGE GB' (FLOAT), 'VOICE CALL MINUTES (INT), and (INT). Which of the following Snowflake features or techniques would be MOST appropriate for performing customer segmentation and determining distinct customer clusters?

• A.Using the 'APPROX COUNT DISTINCT function to estimate the number of distinct usage patterns without performing actual clustering.
• B.Implementing a K-Means clustering algorithm using Snowflake's Python User-Defined Functions (UDFs) and storing the cluster assignments in a new column within the 'CUSTOMER USAGE table.
• C.Creating a series of complex SQL queries with multiple 'CASE statements to manually define customer segments based on predefined thresholds for data usage, voice calls, and SMS count.
• D.Using Snowflake's built-in 'QUALIFY' clause combined with window functions to rank customers based on individual usage metrics and categorize them based on rank percentiles.
• E.Utilizing Snowflake's external functions to call a machine learning model hosted on a platform like AWS SageMaker or Azure Machine Learning to perform the clustering and return the segment assignments.

Comment: *

Name: *

Email: *

Verification: *

You are tasked with loading multiple CSV files from an external stage into a Snowflake table. The files have the following naming convention: HHMlSS.csv' (e.g., 'data_20240101 120000.csv'). You need to load all the files that were created on or after '2024-01-01' into the 'target_table'. Which of the following approaches can be used to load those data?

• A.Using a loop with dynamic SQL to construct COPY INTO statements for each matching file based on the date substring.
• B.Using a single COPY INTO statement with a wildcard pattern in the file path and filtering in a subsequent INSERT INTO statement using a WHERE clause on the filename derived from METADATA$FILENAME.
• C.Using a Snowflake task that runs daily, retrieves all the file names from the stage, filters the file names based on created date and loops through each filtered file name to load them
• D.Using a Snowpipe with a file notification integration, configuring the notification to trigger only for files created on or after '2024-01-01'.
• E.Using a single COPY INTO statement with a pattern match against METADATA$FILENAM The matching logic is done inline with the COPY INTO statement using regex.

Comment: *

Name: *

Email: *

Verification: *

While loading data into Snowflake using named file formats, a file format defined in which location has precedence?

• A.The stage definition
• B.The table definition
• C.The schema definition
• D.The COPY INTO statement

Comment: *

Name: *

Email: *

Verification: *

You are analyzing sales data for a retail company. The 'sales' table contains columns 'product id' (INT), 'sale date' (DATE), and 'sale_amount' (NUMBER). You need to calculate the percentage contribution of each product's sales to the total sales on each day. You want the result to include 'sale date', 'product_id', 'sale_amount', 'daily total' , and 'percentage_contribution'. Which of the following Snowflake queries achieves this correctly?

• A.Option A
• B.Option B
• C.Option C
• D.Option D
• E.Option E

Comment: *

Name: *

Email: *

Verification: *