COF-C02 practice questions 21–30

1. Question 21 · 1323 in bank

   A user creates a stage using the following command: CREATE STAGE mystage - DIRECTORY = (ENABLE = TRUE) FILE_FORMAT = myformat; What will be the outcome?

   • AA stage with a directory table set to automatically refresh will be created.
   • BA stage with a directory table that has metadata that must be manually refreshed will be created.
   • CAn error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
   • DThe command will fail to run because the name of the directory table is not specified.

   Show answer

   Answer: B

   Explanation

   Answer is B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-refreshes Directory tables on internal stages require manual metadata refreshes. This command creates an internal Snowflake stage since it doesn't specify an external cloud storage location. I ran this command in Snowflake and it was valid and using SHOW STAGES; I validated that it was an internal stage, so the answer is B

   Source: Adapted from community discussion — ahadh7621

   References

   • Snowflake documentation

   Next question

2. Question 22 · 1323 in bank

   Select 2

   Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)

   • APartitions scanned
   • BPartitions total
   • CBytes scanned
   • DBytes spilled
   • EBytes written

   Show answer

   Answer: AB

   Explanation

   Statistics A major source of information provided in the detail pane is the various statistics, grouped in the following sections: Pruning — information on the effects of table pruning: Partitions scanned — number of partitions scanned so far. Partitions total — total number of partitions in a given table. https://docs.snowflake.com/en/user-guide/ui-query-profile

   Source: Adapted from community discussion — converteo_certif

   References

   • Snowflake documentation

   Next question

3. Question 23 · 1323 in bank

   Which operation can be performed on Snowflake external tables?

   • AINSERT
   • BJOIN
   • CRENAME
   • DALTER

   Show answer

   Answer: D

   Explanation

   Correct, so DML operations cannot be performed (INSERT, UPDATE, DELETE). ALTER is DDL. If you read the link you pasted carefully, you will find ALTER EXTERNAL TABLE statement. Answer is D

   Source: Adapted from community discussion — yaho5

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 24 · 1323 in bank

   A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

   • AFile URL
   • BStaged URL
   • CScoped URL
   • DPre-signed URL

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

5. Question 25 · 1323 in bank

   True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   Because Snowflake utilizes per-second billing (with a 60-second minimum each time the warehouse starts), warehouses are billed only for the credits they actually consume when they are actively working.

   Source: Adapted from community discussion — AlexbDku

   Next question

6. Question 26 · 1323 in bank

   Which table function is used to view all errors encountered during a previous data load?

   • AVALIDATE
   • BINFER_SCHEMA
   • CGENERATOR
   • DQUERY_HISTORY

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

7. Question 27 · 1323 in bank

   What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

   • AX-Small
   • BSmall
   • CMedium
   • DLarge

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

8. Question 28 · 1323 in bank

   Which role has the ability to create and manage users and roles?

   • AORGADMIN
   • BUSERADMIN
   • CSYSADMIN
   • DSECURITYADMIN

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 29 · 1323 in bank

   Select 2

   What issues can be identified and troubleshooted using the Query Profile? (Choose two.)

   • AFull index scans
   • BCartesian products
   • CInsufficient privileges
   • DQueries too large to fit in memory
   • EVirtual warehouse credit consumption

   Show answer

   Answer: BD

   Explanation

   Correct Answers: B. Cartesian products and E. Virtual warehouse credit consumption Cartesian products: The Query Profile can help identify inefficient joins or joins without proper join conditions that result in Cartesian products (i.e., when each row from one table is joined with all rows of another table). This can significantly impact query performance. Virtual warehouse credit consumption: The Query Profile provides insights into the resources used by a query, including the credits consumed by the virtual warehouse executing the query. This helps in analyzing and optimizing resource usage.

   Source: Adapted from community discussion — cybe001

   References

   • Snowflake documentation

   Next question

10. Question 30 · 1323 in bank

    What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

    • AThe objects are dropped.
    • BThe objects enter the Fail-safe period.
    • CThe objects enter the Time Travel period.
    • DThe objects are immediately moved to the provider account.

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 21. 1323 questions available.