Question 831 · 1323 in bank
Select 2What are the key characteristics of ACСOUNT_USAGE views? (Choose two.)
Show answer
Answer: BE
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 are the key characteristics of ACСOUNT_USAGE views? (Choose two.)
Answer: BE
How does a scoped URL expire?
Answer: B
https://docs.snowflake.com/en/user-guide/unstructured-intro Types of URLs Available to Access Files¶ The following types of URLs are available to access files in cloud storage: Scoped URL Encoded URL that permits temporary access to a staged file without granting privileges to the stage. The URL expires when the persisted query result period ends (i.e. the results cache expires), which is currently 24 hours. File URL URL that identifies the database, schema, stage, and file path to a set of files. A role that has sufficient privileges on the stage can access the files. Pre-signed URL Simple HTTPS URL used to access a file via a web browser. A file is temporarily accessible to users via this URL using a pre-signed access token. The expiration time for the access token is configurable.
Source: Adapted from community discussion — chuks_charley
What are the available Snowflake scaling modes for configuring multi-cluster virtual warehouses? (Choose two.)
Answer: AC
Which of the following terms best describes Snowflake's database architecture?
Answer: C
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require. https://www.snowflake.com/product/architecture/
Source: Adapted from community discussion — BigDataBB
Which loop type iterates until a condition is true?
Answer: C
A REPEAT loop iterates until a condition is true. In a REPEAT loop, the condition is tested immediately after executing the body of the loop. As a result, the body of the loop always executes at least once. A WHILE loop iterates while a condition is true. In a WHILE loop, the condition is tested immediately before executing the body of the loop. If the condition is false before the first iteration, then the body of the loop does not execute even once.
Source: Adapted from community discussion — KnightVictor
Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?
Answer: D
What are the native data types that Snowflake provides to store semi-structured data? (Choose two.)
Answer: AE
How long is the Fail-safe period for recovering historical data from permanent tables?
Answer: C
What does the average_overlaps in the output of SYSTEM$CLUSTERING_INFORMATION refer to?
Answer: C
If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 831. 1323 questions available.
Version 1.0.0. How we source questions