SnowPro Core Exam Practice Questions Part 4 –
Questions And Answers
Which loading method will use virtual warehouse resources? ✔️Ans -
COPY command - Snowpipe is billed separately and doesn't use virtual
warehouse resources
On the WebUI, which button on the top bar should you select to create new
compute clusters? ✔️Ans - Virtual Warehouses
You want to load a specific list of files from an S3 stage. What is the correct
syntax? ✔️Ans - COPY INTO my_table FROM @my_stage
files=('delta.csv','delta2.csv')
SF allows two different styles for loading data: ✔️Ans - Continuous Data
Loading (performed through Snowpipe), Bulk Data Loading (performed
through COPY command)
In a multi cluster virtual warehouse, if you set the same value for minimum
cluster count and the maximum cluster count: ✔️Ans - SF starts all
clusters in the multi cluster virtual warehouse; the mode is called Maximized
T/F - An ACCOUNTADMIN or SECURITYADMIN can disable the MFA for a user
and can allow the user to re-enroll MFA ✔️Ans - True
T/F - If a virtual warehouse is suspended it is likely that the results stored in
its cache will be cleared ✔️Ans - True
You are aiming to load a complete JSON file into SF. You have already created
a table with the following structure.
CREATE TABLE my_json_table (
json_data VARIANT
); What is the command? ✔️Ans - COPY INTO my_json_table FROM
@json_stage file_format=(type=json);
You added an additional cluster to a multi cluster virtual warehouse. What is
this an example of? ✔️Ans - Scale out - allows more users and more
queries to execute
, Is it possible to share data with a SF customer whose SF instance exists in a
different Cloud than the provider? ✔️Ans - Yes, but to enable data sharing
to a different cloud you must enable replication (of existing database) first
You have an S3 bucket called snowpro_bucket which has a subfolder called
customer_data. New customer data will land in this folder. You want to create
SF Stage on top of this data so that you can use it in your COPY command.
What are the two options to create this Snowflake stage? ✔️Ans - 1.
CREATE STAGE first_stage url='s3://snowpro_bucket';
2. CREATE STAGE first_stage url='s3://snowpro_bucket/customer_data';
T/F - You are required to install a SF database engine on a server before you
can start using it ✔️Ans - False - SF is a software as a service offering
T/F - If the cloned object is a database or a schema, the child tables and views
in the database or schema will inherit all the original privileges ✔️Ans -
True
T/F - A reader account can consume data from sources other than those from
the producer that created the reader account ✔️Ans - False - a reader
account can only consume data from the producer account that created it
You are a data engineer with a telecom company who use SF as a data
warehouse. The company requires all network signaling data to be loaded into
a table in a near real-time manner.
The network signaling data is already landing into an S3 bucket every 1
minute. What is the course of action that you should take? ✔️Ans - Create
a stage on top of the S3 bucket where the real-time data is landing; configure
notification events on the S3 bucket which trigger the Snowpipe; Create a
Snowpipe that loads data from a defined stage - Snowpipe cannot be run
through a command, it must be triggered by a rest API or through cloud
storage notifications and a Snowpipe itself cannot watch for new files to arrive
Compared to a single cluster virtual warehouse, a multi-cluster virtual
warehouse supports: ✔️Ans - Auto Resume, Resize, Auto Suspend, Stop -
all the same
Questions And Answers
Which loading method will use virtual warehouse resources? ✔️Ans -
COPY command - Snowpipe is billed separately and doesn't use virtual
warehouse resources
On the WebUI, which button on the top bar should you select to create new
compute clusters? ✔️Ans - Virtual Warehouses
You want to load a specific list of files from an S3 stage. What is the correct
syntax? ✔️Ans - COPY INTO my_table FROM @my_stage
files=('delta.csv','delta2.csv')
SF allows two different styles for loading data: ✔️Ans - Continuous Data
Loading (performed through Snowpipe), Bulk Data Loading (performed
through COPY command)
In a multi cluster virtual warehouse, if you set the same value for minimum
cluster count and the maximum cluster count: ✔️Ans - SF starts all
clusters in the multi cluster virtual warehouse; the mode is called Maximized
T/F - An ACCOUNTADMIN or SECURITYADMIN can disable the MFA for a user
and can allow the user to re-enroll MFA ✔️Ans - True
T/F - If a virtual warehouse is suspended it is likely that the results stored in
its cache will be cleared ✔️Ans - True
You are aiming to load a complete JSON file into SF. You have already created
a table with the following structure.
CREATE TABLE my_json_table (
json_data VARIANT
); What is the command? ✔️Ans - COPY INTO my_json_table FROM
@json_stage file_format=(type=json);
You added an additional cluster to a multi cluster virtual warehouse. What is
this an example of? ✔️Ans - Scale out - allows more users and more
queries to execute
, Is it possible to share data with a SF customer whose SF instance exists in a
different Cloud than the provider? ✔️Ans - Yes, but to enable data sharing
to a different cloud you must enable replication (of existing database) first
You have an S3 bucket called snowpro_bucket which has a subfolder called
customer_data. New customer data will land in this folder. You want to create
SF Stage on top of this data so that you can use it in your COPY command.
What are the two options to create this Snowflake stage? ✔️Ans - 1.
CREATE STAGE first_stage url='s3://snowpro_bucket';
2. CREATE STAGE first_stage url='s3://snowpro_bucket/customer_data';
T/F - You are required to install a SF database engine on a server before you
can start using it ✔️Ans - False - SF is a software as a service offering
T/F - If the cloned object is a database or a schema, the child tables and views
in the database or schema will inherit all the original privileges ✔️Ans -
True
T/F - A reader account can consume data from sources other than those from
the producer that created the reader account ✔️Ans - False - a reader
account can only consume data from the producer account that created it
You are a data engineer with a telecom company who use SF as a data
warehouse. The company requires all network signaling data to be loaded into
a table in a near real-time manner.
The network signaling data is already landing into an S3 bucket every 1
minute. What is the course of action that you should take? ✔️Ans - Create
a stage on top of the S3 bucket where the real-time data is landing; configure
notification events on the S3 bucket which trigger the Snowpipe; Create a
Snowpipe that loads data from a defined stage - Snowpipe cannot be run
through a command, it must be triggered by a rest API or through cloud
storage notifications and a Snowpipe itself cannot watch for new files to arrive
Compared to a single cluster virtual warehouse, a multi-cluster virtual
warehouse supports: ✔️Ans - Auto Resume, Resize, Auto Suspend, Stop -
all the same
