Snowflake SnowPro Advanced: Data Analyst Certification Sample Questions:

1. Consider the following chart.

What can be said about the correlation for sales over time between the two categories?

A) There is a negative correlation.
B) There is no correlation. (Selected)
C) There is a non-linear correlation.
D) There is a positive correlation.

2. A Data Analyst creates a dashboard showing the total credit consumption for each virtual warehouse as follows:

Why is the query failing?

A) The current database context must be changed to SNOWFLAKE.
B) INFORMATION_SCHEMA should be used instead of ACCOUNT_USAGE.
C) DB1 must be authorized to have SELECT access to ACCOUNT_USAGE.
D) The query must be executed by a user with the ACCOUNTADMIN role.

3. A Data Analyst has a Parquet file stored in an Amazon S3 staging area. Which query will copy the data from the staged Parquet file into separate columns in the target table?

A) Option C
B) Option B
C) Option A
D) Option D

4. A Data Analyst created a model called modelX using SNOWFLAKE.ML.FORECAST. The Analyst needs to predict the next few values and save the result directly into tableX. What step does the Analyst need to take after calling the modelX!FORECAST function?

A) Create the table by querying the RESULT_SCAN.
B) Load the function call results directly INTO tableX.
C) Pass the new table as a function argument.
D) List the cache content, then use the data saved in the RESULT_SCAN for tableX.

5. There are two similarly-structured and sized tables, Table_a and Table_b, in a schema with data populated in both tables. A Data Analyst is running queries as part of a preliminary analysis of the data to check the MAX value of a numeric column named num which is present in both the tables:
* Query 1: SELECT MAX(num) FROM Table_a;
* Query 2: SELECT MAX(num) FROM Table_b;
After running the queries, the Analyst observed that Query 2 ran significantly slower than Query 1. Why is this occurring?

A) The USE_CACHED_RESULT was set to FALSE before running Query 2.
B) Table_b has a row-access policy defined.
C) Table_b has more rows than Table_a.
D) A multi-cluster warehouse was used to run Query 1.

Solutions: