SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Which statements reflect valid commands when using secondary roles? (Choose two.)
Answer: CE
I think it should be C and E. "USE SECONDARY ROLES { ALL | NONE }" Reference from => https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
Source: Adapted from community discussion — George_Zhu
How long is a query visible in the Query History page in the Snowflake Web Interface (UI)?
Answer: C
Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data. How does Snowflake recommend resolving this issue?
Answer: C
When you notice that a query is running slowly, check whether an overloaded warehouse is causing the query to compete for resources or get queued: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward. https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
Source: Adapted from community discussion — BigDataBB
Which view will return users who have queried a table?
Answer: B
Why do Snowflake’s virtual warehouses have scaling policies?
Answer: C
To help control the credits consumed by a multi-cluster warehouse running in Auto-scale mode, Snowflake provides scaling policies, which are used to determine when to start or shut down a cluster. https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#label-mcw-scaling-policies
Source: Adapted from community discussion — BigDataBB
Where can a Snowflake user find the query history in Snowsight?
Answer: B
What is SnowSQL?
Answer: C
SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables. SnowSQL (snowsql executable) can be run as an interactive shell or in batch mode through stdin or using the -f option. SnowSQL is an example of an application developed using the Snowflake Connector for Python; however, the connector is not a prerequisite for installing SnowSQL. All required software for installing SnowSQL is bundled in the installers.
Source: Adapted from community discussion — bibisa
The following SQL statements have been executed:
What will the output be of the last select statement?
Answer: C
Which statement is true of zero-copy cloning?
Answer: D
- Snowflake’s zero-copy cloning feature provides a convenient way to quickly take a “snapshot” of any table, schema, or database and create a derived copy of that object which initially shares the underlying storage. This can be extremely useful for creating instant backups that do not incur any additional costs (until changes are made to the cloned object). - owever, cloning makes calculating total storage usage more complex because each clone has its own separate life-cycle. This means that changes can be made to the original object or the clone independently of each other and these changes are protected through CDP. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html#cloning-tables-schemas-and-databases
Source: Adapted from community discussion — BigDataBB
Which of the following statements are true of Snowflake releases: (Choose two.)
Answer: AC
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 671. 1323 questions available.
Version 1.0.0. How we source questions