COF-C02 practice questions 581–590

1. Question 581 · 1323 in bank

   True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Explanation

   True. Query IDs in Snowflake are unique across all Snowflake deployments. Each query executed in Snowflake is assigned a unique Query ID, which can be used to track and reference that specific query. Query IDs are system-generated and can be found in various monitoring and logging tools provided by Snowflake. In case of any issues or troubleshooting needs, providing the Query ID to Snowflake Support can be helpful. Snowflake Support can use the Query ID to investigate the details and history of the specific query, assisting in troubleshooting and resolving any issues related to that query. Therefore, the statement is true. Query IDs are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

   Source: Adapted from community discussion — shubtred

   Next question

2. Question 582 · 1323 in bank

   A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called MKTG_WH. Which of the following statements will accommodate this request?

   • AALLOW RESIZE ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
   • BGRANT MODIFY ON WAREHOUSE MKTG_WH TO ROLE MARKETING;
   • CGRANT MODIFY ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
   • DGRANT OPERATE ON WAREHOUSE MKTG_WH TO ROLE MARKET;

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 583 · 1323 in bank

   Which of the following commands cannot be used within a reader account?

   • ACREATE SHARE
   • BALTER WAREHOUSE
   • CDROP ROLE
   • DSHOW SCHEMAS
   • EDESCRIBE TABLE

   Show answer

   Answer: A

   Explanation

   A. CREATE SHARE In Snowflake, a reader account is a special type of user account that has read-only access to data in Snowflake. This means that reader accounts can only perform actions that are related to querying data, such as running SELECT statements and viewing metadata. As a result, reader accounts cannot perform actions that modify the data or metadata stored in Snowflake, such as creating new objects, modifying existing objects, or dropping objects. This includes the CREATE SHARE command, which is used to create a new share and make it available to other users. The other commands listed (ALTER WAREHOUSE, DROP ROLE, SHOW SCHEMAS, and DESCRIBE TABLE) are all allowed within reader accounts and can be used to query metadata and data stored in Snowflake.

   Source: Adapted from community discussion — markpumc

   References

   • Snowflake documentation

   Next question

4. Question 584 · 1323 in bank

   Which TABLE function helps to convert semi-structured data to a relational representation?

   • ACHECK_JSON
   • BTO_JSON
   • CFLATTEN
   • DPARSE_JSON

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 585 · 1323 in bank

   Select 2

   Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

   • ABytes sent over network
   • BPercentage scanned from cache
   • CPartitions total
   • DBytes spilled to local storage
   • EPartitions scanned

   Show answer

   Answer: CE

   Explanation

   C and E are correct, Because, that higher the ratio of existing partitions is to the scanned, that better (more efficient)=

   Source: Adapted from community discussion — NikoHacker1995

   References

   • Snowflake documentation

   Next question

6. Question 586 · 1323 in bank

   What are the default Time Travel and Fail-safe retention periods for transient tables?

   • ATime Travel - 1 day, Fail-safe - 1 day
   • BTime Travel - 0 days, Fail-safe - 1 day
   • CTime Travel - 1 day, Failsafe - 0 days
   • DTransient tables are retained in neither Fail-safe nor Time Travel.

   Show answer

   Answer: C

   Explanation

   Transient tables can have a Time Travel retention period of either 0 or 1 day. Temporary tables can also have a Time Travel retention period of 0 or 1 day; however, this retention period ends as soon as the table is dropped or the session in which the table was created ends. Transient and temporary tables have no Fail-safe period.

   Source: Adapted from community discussion — halol

   References

   • Snowflake documentation

   Next question

7. Question 587 · 1323 in bank

   Which command is used to unload data from a Snowflake table into a file in a stage?

   • ACOPY INTO
   • BGET
   • CWRITE
   • DEXTRACT INTO

   Show answer

   Answer: A

   Explanation

   As illustrated in the diagram below, unloading data to a local file system is performed in two, separate steps: Step 1 Use the COPY INTO command to copy the data from the Snowflake database table into one or more files in a Snowflake stage. In the SQL statement, you specify the stage (named stage or table/user stage) where the files are written. Regardless of the stage you use, this step requires a running, current virtual warehouse for the session if you execute the command manually or within a script. The warehouse provides the compute resources to write rows from the table. Step 2 Use the GET command to download the data files to your local file system. https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

8. Question 588 · 1323 in bank

   Select 2

   What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

   • AThe clone always stays in sync with the original table.
   • BThe clone has better query performance.
   • CThe clone is created almost instantly.
   • DThe clone will have time travel history from the original table.
   • EThe clone saves space by not duplicating storage.

   Show answer

   Answer: CE

   Next question

9. Question 589 · 1323 in bank

   How often are the Account and Table master keys automatically rotated by Snowflake?

   • A30 Days
   • B60 Days
   • C90 Days
   • D365 Days.

   Show answer

   Answer: A

   Explanation

   https://docs.snowflake.com/en/user-guide/security-encryption-manage Encryption Key Rotation All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed. When active, a key is used to encrypt data and is available for usage by the customer. When retired, the key is used solely to decrypt data and is only available for accessing the data.

   Source: Adapted from community discussion — singhks

   References

   • Snowflake documentation

   Next question

10. Question 590 · 1323 in bank

    Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

    • AUSAGE
    • BOPERATE
    • CMONITOR
    • DMODIFY

    Show answer

    Answer: B

    References

    • Snowflake documentation
    • Snowflake documentation

    Next question

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

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