Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 61:

  What is the default File Format used in the COPY command if one is not specified?

  A. CSV
  B. JSON
  C. Parquet
  D. XML
  A. CSV

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

• Question 62:

  What is the least-privileged database role needed to view the definition of a secure materialized view?

  A. USAGE_VIEWER
  B. OBJECT_VIEWER
  C. SECURITY_VIEWER
  D. GOVERNANCE_VIEWER
  A. USAGE_VIEWER

  ---

  Explanation

  The USAGE_VIEWER role is the minimum required to view metadata and definitions of governance- enabled or secure objects like secure materialized views .

  Snowflake Docs: Governance Roles

• Question 63:

  Which command will list all of the dropped accounts in an organization that have not been deleted?

  A. SHOW MANAGED ACCOUNTS;
  B. SHOW ORGANIZATION ACCOUNTS;
  C. SHOW ORGANIZATION ACCOUNTS HISTORY;
  D. SHOW ORGANIZATION ACCOUNTS LIKE 'myaccounts%';
  C. SHOW ORGANIZATION ACCOUNTS HISTORY;

  ---

  Explanation

  The SHOW ORGANIZATION ACCOUNTS HISTORY command lists all accounts within the Snowflake organization, including dropped accounts that have not yet been permanently deleted. Why Other Options Are Incorrect:

  A. SHOW MANAGED ACCOUNTS: Invalid command.

  B. SHOW ORGANIZATION ACCOUNTS: Shows active accounts, not historical ones.

  D. SHOW ORGANIZATION ACCOUNTS LIKE 'myaccounts%': Filters active accounts only, not dropped ones.

  References:

  SHOW ORGANIZATION ACCOUNTS HISTORY Documentation

• Question 64:

  By default, which role allows a user to manage a Snowflake Data Exchange share?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. USERADMIN
  A. ACCOUNTADMIN

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-privileges-shares

• Question 65:

  Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)

  A. ARRAY
  B. BINARY
  C. TEXT
  D. VARIANT
  E. VARCHAR
  A. ARRAY
  D. VARIANT

  ---

  Explanation

• Question 66:

  What is a characteristic of the maintenance of a materialized view?

  A. Materialized views cannot be refreshed automatically.
  B. An additional set of scripts is needed to refresh data in materialized views.
  C. A materialized view is automatically refreshed by a Snowflake managed warehouse.
  D. A materialized view can be set up with the auto-refresh feature using the SQL SET command.
  C. A materialized view is automatically refreshed by a Snowflake managed warehouse.

  ---

  Explanation

• Question 67:

  When a new Snowflake object is created, it is automatically owned by the user who created it.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 68:

  The use of which Snowflake table type will reduce costs when working with ETL workflows?

  A. External
  B. Permanent
  C. Temporary
  D. Transient
  C. Temporary

  ---

  Explanation

• Question 69:

  Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  A. Internal stages
  B. Incremental backups
  C. Time Travel
  D. Zero-copy clones
  E. Fail-safe
  C. Time Travel
  E. Fail-safe

  ---

  Explanation

  Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that

  has been changed or deleted):

  Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel. Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.

  https://docs.snowflake.com/en/user-guide/data-availability.html

• Question 70:

  What is used to diagnose and troubleshoot network connections to Snowflake?

  A. SnowCD
  B. Snowpark
  C. Snowsight
  D. SnowSQL
  A. SnowCD

  ---

  Explanation