Exam (elaborations)
Snowflake SnowPro Core Practice Exam 1 ; Questions with Complete Solutions(A+)
- Course
- Institution
Snowflake SnowPro Core Practice Exam 1 ; Questions with Complete Solutions(A+)
[Show more]
Content preview
Snowflake SnowPro Core Practice Exam 1 ; Questionswith Complete Solutions(A+)
Which of the following APIs are NOT Snowpipe REST APIs? Correct Ans-insertHistoryScan
and loadFiles - check documentation for further explanation
How can a Snowflake user configure a virtual warehouse to support over 100 users if their
company has Enterprise Edition? Correct Ans-Use a multi-cluster warehouse - a solution
for simultaneous querying
What does a Query Profile provide in Snowflake? Correct Ans-A graphical representation
of the main components of the processing plan for a query
When a Pipe is recreated using the CREATE OR REPLACE PIPE command: Correct Ans-The
Pipe load history is reset to empty
Refresh is a parameter for ALTER PIPE
Which columns are available in the output of a Snowflake directory table? Correct Ans-
RELATIVE_PATH and LAST_MODIFIED
, Snowflake SnowPro Core Practice Exam 1 ; Questions
with Complete Solutions(A+)
Also includes SIZE, MD5, ETag, and FILE_URL
Which Snowflake edition allows only one day of Time Travel? Correct Ans-Standard
Enterprise can do 90 (1 by default)
Business Critical can also do 90 (1 by default)
A medium(M) warehouse has auto-suspend configured after 15 minutes. You have noticed
that all of the queries that run on this warehouse finish within a minute. What will you do to
optimize compute costs? Correct Ans-Reduce the auto-suspend time to 1 minute
This will make it automatically go to sleep after 60 seconds of inactivity, significantly reducing
credit consumption
Which statement describes how Snowflake supports reader accounts? Correct Ans-The
SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been
created for an account.
, Snowflake SnowPro Core Practice Exam 1 ; Questions
with Complete Solutions(A+)
Lists all the managed accounts for your account currently used by data providers to create
reader accounts for their consumers
What property from the Resource Monitors lets you specify whether you want to control the
credit usage of your entire account or a specific set of warehouses? Correct Ans-Monitor
level
It's a dropdown or property that can be either entire account or entire warehouse level
A company's security audit requires generating a report listing all Snowflake logins within the
last 90 days.
Which of the following statements will return the required information? Correct Ans-
SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;
, Snowflake SnowPro Core Practice Exam 1 ; Questions
with Complete Solutions(A+)
One might use login_history_by_user function but this function only return activity for the
last 7 days
Which of the following sizes is not a Warehouse Size? Correct Ans-XXS
It doubles every time it goes up a size
Size - and Credit per hour
XS - 1
S -2
M-4
L-8
XL - 16
2XL - 32
3XL - 64
4XL - 128
5XL - 256
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 $14.99. 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