100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Snowflake SnowPro Core Practice Exam 1 Questions and Answers 100% Correct $11.99   Add to cart

Exam (elaborations)

Snowflake SnowPro Core Practice Exam 1 Questions and Answers 100% Correct

 15 views  0 purchase
  • Course
  • Snowflake SnowPro
  • Institution
  • Snowflake SnowPro

Snowflake SnowPro Core Practice Exam 1 Questions and Answers 100% CorrectSnowflake SnowPro Core Practice Exam 1 Questions and Answers 100% CorrectSnowflake SnowPro Core Practice Exam 1 Questions and Answers 100% CorrectSnowflake SnowPro Core Practice Exam 1 Questions and Answers 100% CorrectWhich o...

[Show more]

Preview 3 out of 19  pages

  • August 22, 2024
  • 19
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Snowflake SnowPro
  • Snowflake SnowPro
avatar-seller
NursingTutor1
Snowflake SnowPro Core Practice Exam 1
Questions and Answers 100% Correct

Which of the following APIs are NOT Snowpipe REST APIs? - ANSWER - 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? - ANSWER - Use a multi-cluster warehouse - a solution for simultaneous querying



What does a Query Profile provide in Snowflake? - ANSWER - 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: - ANSWER - 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? - ANSWER - RELATIVE_PATH
and LAST_MODIFIED




Also includes SIZE, MD5, ETag, and FILE_URL



Which Snowflake edition allows only one day of Time Travel? - ANSWER - Standard



Enterprise can do 90 (1 by default)

Business Critical can also do 90 (1 by default)



Which of the following roles are NOT System-Defined Roles in Snowflake? - ANSWER - VIEWER and
STORAGEADMIN

,ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, USERADMIN, PUBLIC are all System-Defined roles



When should you consider disabling auto-suspend for a Virtual Warehouse? - ANSWER - When managing
a steady workload and when the compute must be available with no delay or lag time



Which functions return the name of the warehouse of the current session? - ANSWER -
CURRENT_WAREHOUSE()



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? -
ANSWER - 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? - ANSWER - The SHOW MANAGED
ACCOUNTS command will view all the reader accounts that have been created for an account.



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? - ANSWER - 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? - ANSWER - SELECT
EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;



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? - ANSWER - 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

6XL - 512



What is the MOST performant file format for loading data in Snowflake? - ANSWER - CSV (Gzipped)



Gzipped CSV is several times fast than loading from ORC and Parquet at 15TB/hr



SELECT CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA();



Which item in the Data Warehouse migration process does not apply in Snowflake? - ANSWER - Migrate
Indexes.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

62890 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.99
  • (0)
  Add to cart