Question 1171 · 1323 in bank
What type of account can be used to share data with a consumer who does not have a Snowflake account?
Show answer
Answer: A
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
What type of account can be used to share data with a consumer who does not have a Snowflake account?
Answer: A
Which parameters can be used together to ensure that a virtual warehouse never has a backlog of queued SQL statements? (Choose two.)
Answer: AD
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
Answer: D
The function enables replication and failover features for a specified account in an organization. Once an organization administrator (a user with the ORGADMIN role) has called this function, the following features are enabled for the account: Replication Client Redirect
Source: Adapted from community discussion — nexerSnow
If a virtual warehouse is suspended, what happens to the warehouse cache?
Answer: A
https://docs.snowflake.com/en/user-guide/warehouses-considerations This cache is dropped when the warehouse is suspended, which may result in slower initial performance for some queries after the warehouse is resumed. https://docs.snowflake.com/en/user-guide/performance-query-warehouse-cache The auto-suspension setting of the warehouse can have a direct impact on query performance because the cache is dropped when the warehouse is suspended.
Source: Adapted from community discussion — 6c79d6f
What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)
Answer: AE
"Snowflake supports basic authentication (i.e. username and password) in the API request header as specified in RFC 7617, where the authentication credentials are encoded using Base64. Similarly, Snowflake supports OAuth 2.0 as specified in RFC 6749."
Source: Adapted from community discussion — rsofia
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 24-hour mark?
Answer: C
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare Note Loading very large files (e.g. 100 GB or larger) is not recommended. If you must load a large file, carefully consider the ON_ERROR copy option value. Aborting or skipping a file due to a small number of errors could result in delays and wasted credits. In addition, if a data loading operation continues beyond the maximum allowed duration of 24 hours, it could be aborted without any portion of the file being committed. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
Source: Adapted from community discussion — 0e504b5
What information does the Query Profile provide?
Answer: B
Which data sharing mechanism can be used to share data privately or publicly within the Snowflake Marketplace?
Answer: A
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
Answer: C
An external stage, my_stage contains many directories, including one, app_files that contains CSV files. How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1171. 1323 questions available.
Version 1.0.0. How we source questions