COF-C02 practice questions 601–610

1. Question 601 · 1323 in bank

   During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?

   • ASTATEMENT_TIMEOUT_IN_SECONDS
   • BSTATEMENT_QUEUED_TIMEOUT_IN_SECONDS
   • CMAX_CONCURRENCY_LEVEL
   • DQUERY_TIMEOUT_IN_SECONDS

   Show answer

   Answer: B

   Explanation

   Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAX_CONCURRENCY_LEVEL parameter to ensure a warehouse is never backlogged https://docs.snowflake.com/en/sql-reference/parameters.html#statement-queued-timeout-in-seconds

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 602 · 1323 in bank

   Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

   • APURGE
   • BMODIFY
   • CREMOVE
   • DDELETE

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

3. Question 603 · 1323 in bank

   In a Snowflake role hierarchy, what is the top-level role?

   • ASYSADMIN
   • BORGADMIN
   • CACCOUNTADMIN
   • DSECURITYADMIN

   Show answer

   Answer: C

   Explanation

   https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#label-role-hierarchy-and-privilege-inheritance "ORGADMIN is a separate system role that manages operations at the organization level. This role is not included in the hierarchy of system roles."

   Source: Adapted from community discussion — hmrizak

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 604 · 1323 in bank

   Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

   • AScaling rhythmically
   • BScaling max
   • CScaling out
   • DScaling up

   Show answer

   Answer: C

   Explanation

   Scale up by resizing a warehouse. Scale out by adding clusters to a multi-cluster warehouse (requires Snowflake Enterprise Edition or higher).

   Source: Adapted from community discussion — rakshithaK

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 605 · 1323 in bank

   By default, which Snowflake role is required to create a share?

   • AORGADMIN
   • BSECURITYADMIN
   • CSHAREADMIN
   • DACCOUNTADMIN

   Show answer

   Answer: D

   Explanation

   CREATE SHARE: Account :Only the ACCOUNTADMIN role has this privilege by default. The privilege can be granted to additional roles as needed. https://docs.snowflake.com/en/sql-reference/sql/create-share.html#access-control-requirements

   Source: Adapted from community discussion — miadiesel

   References

   • Snowflake documentation

   Next question

6. Question 606 · 1323 in bank

   What happens to historical data when the retention period for an object ends?

   • AThe data is cloned into a historical object.
   • BThe data moves to Fail-safe
   • CTime Travel on the historical data is dropped.
   • DThe object containing the historical data is dropped.

   Show answer

   Answer: B

   Explanation

   When the retention period ends for an object, the historical data is moved into Snowflake Fail-safe: Historical data is no longer available for querying.

   Source: Adapted from community discussion — halol

   References

   • Snowflake documentation

   Next question

7. Question 607 · 1323 in bank

   A company’s security audit requires generating a report listing all Snowflake logins (e.g., date and user) within the last 90 days. Which of the following statements will return the required information?

   • ASELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
   • BSELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())
   • CSELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
   • DSELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

   Show answer

   Answer: D

   Explanation

   D - Correct https://docs.snowflake.com/en/sql-reference/account-usage/login_history B - Incorrect as login_history_by_user function returns login activity within the last 7 days only. https://docs.snowflake.com/en/sql-reference/functions/login_history

   Source: Adapted from community discussion — OTE

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 608 · 1323 in bank

   Select 2

   What are common issues found by using the Query Profile? (Choose two.)

   • AIdentifying queries that will likely run very slowly before executing them
   • BLocating queries that consume a high amount of credits
   • CIdentifying logical issues with the queries
   • DIdentifying inefficient micro-partition pruning
   • EData spilling to a local or remote disk

   Show answer

   Answer: DE

   References

   • Snowflake documentation

   Next question

9. Question 609 · 1323 in bank

   The Snowflake Search Optimization Services supports improved performance of which kind of query?

   • AQueries against large tables where frequent DML occurs
   • BQueries against tables larger than 1 TB
   • CSelective point lookup queries
   • DQueries against a subset of columns in a table

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

10. Question 610 · 1323 in bank

    Select 2

    Which file formats are supported for unloading data from Snowflake? (Choose two.)

    • AAvro
    • BJSON
    • CORC
    • DXML
    • EDelimited (CSV, TSV, etc.)

    Show answer

    Answer: BE

    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 601. 1323 questions available.