Udemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% Correct
13 vistas 0 veces vendidas
Grado
Udemy Snowpro Core Certification
Institución
Udemy Snowpro Core Certification
Udemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% CorrectUdemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% CorrectUdemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% Correct
When definin...
Udemy Snowpro Core Certification -
Practice Questions Test 1 Questions and
Answers 100% Correct
When defining a clustering key for a large table, consider using columns frequently used in
WHERE clauses. - ANSWER - True
Which query profile results indicate that a large table may not be well clustered? - ANSWER - -
The value in the 'Partitions Total' qual 'Partitions Scanned'
- A significant value for 'Partitions Scanned'
Snowflake can eliminate unneeded partitions while executing a query. What is the name given
to this optimization technique?
Retrieve needed data only (RNDO)
Predicate optimization
WHERE clause optimization
Partition pruning
(Correct) - ANSWER - Partition Pruning
A stored procedure can return which type of results? - ANSWER - - Single Value
- Tabular Data
What type of virtual warehouse automatically lets you add or remove additional clusters as
concurrency and demand change? - ANSWER - Multi-cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned table. - ANSWER
- True
Which of the following operations can be performed on a cloned table? - ANSWER - DROP,
SELECT, DELETE, CLONE
A cloned table is just like any other table
, Which of the following is an appropriate scenario for creating a Stored Procedure? - ANSWER -
Execute one or more SQL statements that are assembled dynamically
True or False: An ACCOUNTADMIN can see the results of any query executed by any user in a
Snowflake system. - ANSWER - False
Dynamic Data Masking provides what sort of security in Snowflake? - ANSWER - Column-level
security
Which one of the following is supported by Snowflake for the purpose of auto-provisioning users
and group membership? - ANSWER - SCIM
- SCIM is an open standard that provides automatic user provisioning and role synchronization
based on identity provider information
Which of the following could be used as a remote service for an external function? - ANSWER -
- AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
True or False. To create Snowflake instances in different regions, you must maintain a separate
Snowflake account for each region. - ANSWER - True
True or False: When unloading data, each exported file is 16MB, and this configuration cannot
be changed. - ANSWER - False
- Default size of each output file is 16 MB but can be changed using the MAX_FILE_SIZE
parameter
Which of the following correctly describes the query profile shown?
QUERY RESULT REUSE[0] 1005 - ANSWER - - The query profile indicates that results
produced by a previous query were reused
- The query profile indicates that an active virtual warehouse was NOT required for this query
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.
