Exam (elaborations)
SnowPro Core Exam Practice Questions Part 4; Questions and Answers
- Course
- Institution
SnowPro Core Exam Practice Questions Part 4; Questions and Answers
[Show more]
Content preview
SnowPro Core Exam Practice Questions Part 4;Questions and Answers
Which loading method will use virtual warehouse resources? Correct 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? Correct Ans-Virtual Warehouses
You want to load a specific list of files from an S3 stage. What is the correct syntax? Correct
Ans-COPY INTO my_table FROM @my_stage files=('delta.csv','delta2.csv')
SF allows two different styles for loading data: Correct 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: Correct 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 Correct Ans-True
, SnowPro Core Exam Practice Questions Part 4;
Questions and Answers
T/F - If a virtual warehouse is suspended it is likely that the results stored in its cache will be
cleared Correct 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? Correct 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? Correct 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? Correct Ans-Yes, but to enable data sharing to a different cloud you
must enable replication (of existing database) first
, SnowPro Core Exam Practice Questions Part 4;
Questions and Answers
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? Correct 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
Correct 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 Correct Ans-True
T/F - A reader account can consume data from sources other than those from the producer
that created the reader account Correct Ans-False - a reader account can only consume
data from the producer account that created it
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TheeGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now