SnowPro Certification Final Test Exam
t/f: Snowpipe must have a COPY statement in the pipe definition - ✔
✔ true
What does the copy statement in a pipe definition identify - ✔ ✔
stage and a target table
What are the different mechanisms for detecting staged files using
Snowpipe - ✔ ✔ automating snowpipe using cloud messaging,
calling Snowpipe rest endpoints
Cross-cloud support for automated Snowpipe using cloud messaging is
only available to accounts hosted on
a. AWS
b. Azure
c. GCP - ✔ ✔ a. aws
When calling Snowpipe rest endpoints, your client application calls a
public REST endpoint with... - ✔ ✔ the name of a pipe object and a
list of new data filenames
Authenticating for a bulk data load relies on - ✔ ✔ security options
supported by the client application for authenticating and initiating a
user session
Authenticating when calling rest endpoints with snowpipe requres - ✔
✔ key pair authentication with JSON Web Token
, The load history for Snowpipe is stored in the metadata for how many
days? - ✔ ✔ 64 days
Where is the load history for Snowpipe stored? - ✔ ✔ In the
metadata of the pipe
The load history for a bulk data load is stored in the
_________________ for ____ days - ✔ ✔ metadata of the target
table, 64 days
Load history for Snowpipe must be requested via a ______________,
_____________, or _____________________________ - ✔ ✔ rest
endpoint, sql table function, account_usage view
t/f: snowflake recommends using either bulk data loading or Snowpipe
but not both - ✔ ✔ true
t/f: Bulk data loads are always performed in multiple transactions - ✔
✔ False (Loads are always performed in a single transaction)
t/f: Snowpipe loads are combined or split into a single or multiple
transactions based on the number and size of rows in each data file - ✔
✔ true
Snowpipe is billed according to.... - ✔ ✔ compute resources used in
the Snowpipe WH while loading the files
Bulk data loading compute costs are billed for.. - ✔ ✔ amount of
time wh is active
For the most efficient and cost-effective load experience with
Snowpipe, Snowflake recommends staging files once per ___________
- ✔ ✔ minute
t/f: Snowpipe must have a COPY statement in the pipe definition - ✔
✔ true
What does the copy statement in a pipe definition identify - ✔ ✔
stage and a target table
What are the different mechanisms for detecting staged files using
Snowpipe - ✔ ✔ automating snowpipe using cloud messaging,
calling Snowpipe rest endpoints
Cross-cloud support for automated Snowpipe using cloud messaging is
only available to accounts hosted on
a. AWS
b. Azure
c. GCP - ✔ ✔ a. aws
When calling Snowpipe rest endpoints, your client application calls a
public REST endpoint with... - ✔ ✔ the name of a pipe object and a
list of new data filenames
Authenticating for a bulk data load relies on - ✔ ✔ security options
supported by the client application for authenticating and initiating a
user session
Authenticating when calling rest endpoints with snowpipe requres - ✔
✔ key pair authentication with JSON Web Token
, The load history for Snowpipe is stored in the metadata for how many
days? - ✔ ✔ 64 days
Where is the load history for Snowpipe stored? - ✔ ✔ In the
metadata of the pipe
The load history for a bulk data load is stored in the
_________________ for ____ days - ✔ ✔ metadata of the target
table, 64 days
Load history for Snowpipe must be requested via a ______________,
_____________, or _____________________________ - ✔ ✔ rest
endpoint, sql table function, account_usage view
t/f: snowflake recommends using either bulk data loading or Snowpipe
but not both - ✔ ✔ true
t/f: Bulk data loads are always performed in multiple transactions - ✔
✔ False (Loads are always performed in a single transaction)
t/f: Snowpipe loads are combined or split into a single or multiple
transactions based on the number and size of rows in each data file - ✔
✔ true
Snowpipe is billed according to.... - ✔ ✔ compute resources used in
the Snowpipe WH while loading the files
Bulk data loading compute costs are billed for.. - ✔ ✔ amount of
time wh is active
For the most efficient and cost-effective load experience with
Snowpipe, Snowflake recommends staging files once per ___________
- ✔ ✔ minute
