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 is generally the FASTEST way to bulk load data files from a stage?
Answer: A
Of the three options for identifying/specifying data files to load from a stage, providing a discrete list of files is generally the fastest; however, the FILES parameter supports a maximum of 1,000 files, meaning a COPY command executed with the FILES parameter can only load up to 1,000 files.
Source: Adapted from community discussion — romega2
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
Answer: B
Answer is B Viewing Query Results A user cannot view the result set from a query that another user executed. This behavior is intentional. For security reasons, only the user who executed a query can access the query results.
Source: Adapted from community discussion — rsmurugan
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Answer: D
The GET_STAGE_LOCATION function returns the location of a stage, including the URL of the directory table. The syntax for the GET_STAGE_LOCATION function. SELECT GET_STAGE_LOCATION('my_stage')
Source: Adapted from community discussion — JG1984
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?
Answer: C
https://docs.snowflake.com/en/user-guide/unstructured-intro Search in page for Types of URLs Available to Access Files Pre-signed URL Used to download or access files without authenticating into Snowflake or passing an authorization token. Pre-signed URLs are open; any user or application can directly access or download the files. Ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.
Source: Adapted from community discussion — ukpino
The use of which Snowflake table type will reduce costs when working with ETL workflows?
Answer: C
C since temporary tables are only available for the duration of a session, and they are not stored in Snowflake's permanent storage. This means that they do not incur any storage costs.
Source: Adapted from community discussion — blitzzzz
What is one of the characteristics of data shares?
Answer: C
A view can only be shared if it is created as a secure view or marked secure using the ALTER VIEW view_name SET_SECURE statement.
Source: Adapted from community discussion — JG1984
What is the MINIMUM configurable idle timeout value for a session policy in Snowflake?
Answer: B
The timeout period begins upon a successful authentication to Snowflake. If a session policy is not set, Snowflake uses a default value of 240 minutes (i.e. 4 hours). The minimum configurable idle timeout value for a session policy is 5 minutes. When the session expires, the user must authenticate to Snowflake again.
Source: Adapted from community discussion — niho1993
Which command is used to unload data from a Snowflake table to an external stage?
Answer: A
B is correct Bulk unloading process The process for unloading data into files is the same as the loading process, except in reverse: Step 1 Use the COPY INTO command to copy the data from the Snowflake database table into one or more files in a Snowflake or external stage. Step 2 Download the file from the stage: From a Snowflake stage, use the GET command to download the data file(s). From S3, use the interfaces/tools provided by Amazon S3 to get the data file(s). From Azure, use the interfaces/tools provided by Microsoft Azure to get the data file(s).
Source: Adapted from community discussion — ede3703
What is a characteristic of materialized views in Snowflake?
Answer: A
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 941. 1323 questions available.
Version 1.0.0. How we source questions