Udemy Snowpro Core Certification - Practice Questions Test 2 Questions and Answers 100% Accurate
10 keer bekeken 0 keer verkocht
Vak
Udemy Snowpro Core Certification
Instelling
Udemy Snowpro Core Certification
Udemy Snowpro Core Certification - Practice Questions Test 2 Questions and Answers 100% AccurateUdemy Snowpro Core Certification - Practice Questions Test 2 Questions and Answers 100% AccurateUdemy Snowpro Core Certification - Practice Questions Test 2 Questions and Answers 100% Accurate
What are ...
what are some general indicators that a clustering
Geschreven voor
Udemy Snowpro Core Certification
Udemy Snowpro Core Certification
Verkoper
Volgen
NursingTutor1
Ontvangen beoordelingen
Voorbeeld van de inhoud
Udemy Snowpro Core Certification -
Practice Questions Test 2 Questions and
Answers 100% Accurate
What are some general indicators that a clustering key is required on a table? - ANSWER - -
The query performance has slowed down over time
- The size of the table is multi-terabytes
- Large clustering depth
True or False: Resource monitors can manage a single virtual warehouse, a collection of virtual
warehouses, or the entire Snowflake account. - ANSWER - True
True or False: Snowflake stores all data at rest unencrypted unless configured by the customer.
- ANSWER - False
Which of the following requirements can be fulfilled by only a secure UDF? - ANSWER - - There
is a requirement to protect data by limiting a subset of rows from the result set
- There is a requirement to protect data by limiting some table columns from the result set
Which of the following statements is true regarding the USERADMIN role? - ANSWER - - Can
create new roles
- Can create new users
The privileges provided by the SYSADMIN & SECURITYADMIN role are automatically
contained in the ACCOUNTADMIN role since the ACCOUNTADMIN role sits at the top of the
role hierarchy. - ANSWER - True
What is the minimum Snowflake edition that supports Database replication between Snowflake
accounts (within an organization)? - ANSWER - Standard
Automatic Clustering Service is responsible for what activity in Snowflake? - ANSWER -
Redistributing data in micro-partitions according to the clustering key
, Which of the following statements are true regarding External Tables? - ANSWER - - Views can
be created on top of an external table
- An external table allows querying of data in cloud storage with requiring it to be loaded into
Snowflake first
True or False: The data is physically copied into new micro-partitions during a clone operation. -
ANSWER - False
- Zero copy cloning does not actually physically copy the data
Which of the following is a web-based interface to Snowflake? - ANSWER - Snowsight
Which of the following statements are true regarding Snowpark? - ANSWER - - When using
Snowpark, Snowflake operation are performed lazily
- Function defined in Snowparkk can be pushed down to the server (Snowflake) for execution
To create an external table, what minimum Snowflake edition is required? - ANSWER -
Standard
For data loading and transformation, the approach recommended by Snowflake is? - ANSWER -
ELT
An external table can only be created using an external stage. - ANSWER - True
Which of the following Scaling Policies prioritizes performance over cost? - ANSWER - Standard
As an administrator, you are required to find and list all tables with a size greater than 1 TB. You
must also include tables created and deleted in the last month. Which one of the following
options should you use? - ANSWER - Query the views in the ACCOUNT_USAGE schema
Which of the following actions can be performed by a Snowflake user? - ANSWER - Use SQL to
retrieve data in Time Travel
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, creditcard of Stuvia-tegoed 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,78. Je zit daarna nergens aan vast.
