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]
Seller
Follow
LeCrae
Reviews received
Content preview
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
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now