SnowPro Core Exam Practice Questions Part 3| 68Questions and Answers 100% Correct
7 views 0 purchase
Course
SnowPro Core
Institution
SnowPro Core
SnowPro Core Exam Practice Questions Part 3| 68Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 3| 68Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 3| 68Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 3| 68Questions...
SnowPro Core Exam Practice Questions
Part 3| 68Questions and Answers 100%
Correct
What is a SF virtual warehouse? - ANSWER - Virtual warehouse is the name given to the
compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? - ANSWER - Load semi
structured data into a VARIANT column; Transform the data while using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will consume the same
number of credits as a Medium virtual warehouse (4 servers) executing for 1 hour - ANSWER -
True - with a larger size the credit consumption is more
In the SF staged release process for new releases, which account types are applied updates
ahead of everyone else? - ANSWER - Designated accounts opting for early access
The reader account belongs to: - ANSWER - The producer - created by, owned by, uses the
compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string "null" - ANSWER -
True
Under the Download section in Snowflake Web UI, what are the connectors & programs that
can be downloaded? - ANSWER - Spark Connector, Python Components, Node.js driver; not
Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format - ANSWER - Yes
On the WebUI, which button on the top bar should you select to run queries? - ANSWER -
Worksheets
, T/F - A virtual warehouse starts consuming credits once all the servers in the virtual warehouse
are provisioned - ANSWER - True - the credit consumption starts only once all the servers are
provisioned. In rare cases if one or more servers fail to provision, credits are only charged for
the servers which were successfully provisioned.
Which is true about Snowpipe and the COPY command? - ANSWER - The charges for data
loaded through Snowpipe is based on the actual workload while the charges for data loaded
through COPY command is based on how long the virtual warehouse is in an active state -
Snowpipe uses a serverless compute due to which billing is based on actual data processed
Which function is used to find the query id of the second query executed in the current session?
- ANSWER - SELECT last_query_id(2)
T/F - When a virtual warehouse is resized, all queries that are in queue will use the resized
instance - ANSWER - True
To see existing virtual warehouses, what is the correct command? - ANSWER - SHOW
WAREHOUSES;
You are creating a new virtual warehouse that you want to auto suspend if no query has been
run in last 10 minutes. What is the correct syntax for creating such a virtual warehouse? -
ANSWER - CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
A share has been granted to a consumer. If a new object is added to the share it will: -
ANSWER - Become accessible to the consumer immediately
T/F - SF maintains the partitions using the order of the data in which it is inserted - ANSWER -
True - and this may require reclustering of very large tables in which data has been inserted
over time
T/F - By 'warehouse size' SF means the number of servers in each cluster - ANSWER - True
T/F - Micro partitioning can be disabled for tables if needed - ANSWER - False - it's
automatically managed by SF; you can only control the clustering key which changes the micro
partitioning approach but does not disable 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.
