SnowPro-Core Exam Questions

The number of queries that a Virtual Warehouse can concurrently process is determined
by:
Choose 2 answers

A.

The complexity of each query

B.

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

C.

The size of the data required for each query

D.

The tool that s executing the query

A.

The complexity of each query

C.

The size of the data required for each query

Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user

A.

True

B.

False

D.

Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in
lieu of using an
existing database or a platform, like Hadoop, as a base.

A.

True

B.

False

B.

False

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

A.

True

B.

False

B.

False

Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

E.

1 year

C.

14 days

Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of
the following statements are true?
Choose 2 answers

A.

The exact query win ALWAYS return me precomputed result set for the
RESULT_CACHE_ACTIVE = time period

B.

The same exact query will return the precomputed results if the underlying data hasn't
changed and the results were last accessed within the previous 24 hour period

C.

The same exact query will return the precomputed results even if the underlying data
has changed as long as the results were last accessed within the previous

D.

The ''24 hour'' on the percomputed results gets renewed every time the exact query is
executed

A.

The exact query win ALWAYS return me precomputed result set for the
RESULT_CACHE_ACTIVE = time period

C.

The same exact query will return the precomputed results even if the underlying data
has changed as long as the results were last accessed within the previous

Data storage for individual tables can be monitored using which commands and/or
object(s)?
Choose 2 answers

A.

SHOW TABLES;

B.

SHOW STORAGE BY TABLE;

C.

Information Schema -> TABLE_STORAGE_METRICS

D.

Information Schema -> TASLE_HISTORY

A.

SHOW TABLES;

D.

Information Schema -> TASLE_HISTORY

True or False: A single database can exist in more than one Snowflake account.

A.

True

B.

False

B.

False

Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

True or False: You can resize a Virtual Warehouse while queries are running.

A.

True

B.

False

A.

True

Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

True or False: The COPY command must specify a File Format in order to execute.

A.

True

B.

False

A.

True

Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-intosnowflake/

SnowPro-Core Exam Questions

Last Updated Exam : 30-Dec-2024