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 are true of micro-partitions? (Choose two.)
Answer: AC
- micro-partitions are small in size (50 to 500 MB, before compression) - 16 MB must comes from old version/question - COMPRESSION = NONE is the right
Source: Adapted from community discussion — EmiB
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Answer: CD
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Answer: DE
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control
Source: Adapted from community discussion — Kate0204
What features does Snowflake Time Travel enable?
Answer: B
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks: Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted. Duplicating and backing up data from key points in the past. Analyzing data usage/manipulation over specified periods of time.
Source: Adapted from community discussion — Kate0204
Which of the following statements describes a schema in Snowflake?
Answer: A
What is the recommended compressed file size range for continuous data loads using Snowpipe?
Answer: D
Snowpipe is typically used to load data that is arriving continuously. File sizing plays an important role in Snowpipe's performance. The recommended file size for data loading is 100-250MB compressed, however, if data is arriving continuously, then try to stage the data within one-minute intervals.
Source: Adapted from community discussion — Kate0204
How long is Snowpipe data load history retained?
Answer: D
Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view.
Source: Adapted from community discussion — NikoHacker1995
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?
Answer: B
B. Duo Mobile Snowflake integrates with the Duo Mobile app to provide multi-factor authentication (MFA) for users connecting to Snowflake. This means that in order to use MFA, Snowflake users need to have the Duo Mobile app installed on their devices and enroll in Snowflake's MFA service. Okta Verify, Microsoft Authenticator, and Google Authenticator are alternative MFA apps, but they are not directly integrated with Snowflake and may not be supported for use with Snowflake's MFA service.
Source: Adapted from community discussion — markpumc
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Answer: A
Pre-signed URLs are used to download or access files, via a web browser for example, without authenticating into Snowflake or passing an authorization token. These URLs are ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.
Source: Adapted from community discussion — Kate0204
Where would a Snowflake user find information about query activity from 90 days ago?
Answer: A
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 571. 1323 questions available.
Version 1.0.0. How we source questions