SnowPro Core Exam Practice Questions Part 4 Questions and Answers (Graded A)
9 views 0 purchase
Course
SnowPro Core
Institution
SnowPro Core
SnowPro Core Exam Practice Questions Part 4 Questions and Answers (Graded A)SnowPro Core Exam Practice Questions Part 4 Questions and Answers (Graded A)SnowPro Core Exam Practice Questions Part 4 Questions and Answers (Graded A)SnowPro Core Exam Practice Questions Part 4 Questions and Answers (Grad...
SnowPro Core Exam Practice Questions
Part 4 Questions and Answers (Graded
A)
Which loading method will use virtual warehouse resources? - ANSWER - 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? -
ANSWER - Virtual Warehouses
You want to load a specific list of files from an S3 stage. What is the correct syntax? - ANSWER
- COPY INTO my_table FROM @my_stage files=('delta.csv','delta2.csv')
SF allows two different styles for loading data: - ANSWER - 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: - ANSWER - 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 - ANSWER - True
T/F - If a virtual warehouse is suspended it is likely that the results stored in its cache will be
cleared - ANSWER - 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? - ANSWER - 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?
- ANSWER - Scale out - allows more users and more queries to execute
Which mechanism allows a SF customer to query data without loading it first? (Virtual table,
external table, Snowpipe, COPY) - ANSWER - External table
T/F - A cloned database doesn't inherit the source permissions, but schemas, tables & views
contained inside the cloned database will inherit the source permissions - ANSWER - True
Any SF account regardless of the edition can produce and consume shared data - ANSWER -
True, except for VPS (virtual private SF)
Is it possible to share data with a SF customer whose SF instance exists in a different Cloud
than the provider? - ANSWER - 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? - ANSWER - 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 -
ANSWER - 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 - ANSWER - True
T/F - A reader account can consume data from sources other than those from the producer that
created the reader account - ANSWER - 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 NursingTutor1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
