Udemy Snowpro Core Certification - Practice Questions Test 2 Questions and Answers 100% Accurate
9 vistas 0 veces vendidas
Grado
Udemy Snowpro Core Certification
Institución
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
Escuela, estudio y materia
Udemy Snowpro Core Certification
Udemy Snowpro Core Certification
Vendedor
Seguir
NursingTutor1
Comentarios recibidos
Vista previa del contenido
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
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary 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 this summary for 11,69 €. You're not tied to anything after your purchase.
