snowflake snowpro core practice exam 1 questions a
snowflake snowpro core practice exam 1 answers
which of the following apis are not snowpipe rest
how can a snowflake user configure a virtual ware
Geschreven voor
Snowflake SnowPro
Snowflake SnowPro
Verkoper
Volgen
NursingTutor1
Ontvangen beoordelingen
Voorbeeld van de inhoud
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
Which item in the Data Warehouse migration process does not apply in Snowflake? - ANSWER - Migrate
Indexes.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper NursingTutor1. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €11,69. Je zit daarna nergens aan vast.
