Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 21:

  Which role must be used to create resource monitors?

  A. SECURITYADMIN

  B. ACCOUNTADMIN

  C. SYSADMIN

  D. ORGADMIN

  Correct Answer: B

  The ACCOUNTADMIN role in Snowflake has the necessary privileges to create and manage resource monitors. Resource monitors are used to manage and monitor the usage of resources (such as compute credits) within the Snowflake account. The ACCOUNTADMIN role has the highest level of administrative privileges required to perform this task.

• Question 22:

  What step does Snowflake recommend when loading data from a stage?

  A. Use PURGE when using the COPY INTO command.

  B. Use REMOVE when using the COPY INTO command.

  C. Use the LOAD HISTORY function to view the status of loaded files.

  D. Use the COPY HISTORY function to update the status of loaded files.

  Correct Answer: C

  Snowflake recommends using the COPY INTO

  ... command to load data from a stage into a table. After the data is loaded, the LOAD HISTORY function (which can be accessed via the INFORMATION_SCHEMA.LOAD_HISTORY view or by querying the COPY_HISTORY table function) is used to view the status of loaded files. This helps to ensure that files are loaded correctly and to check for any errors during the load process.

  Question 23:

  Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

  A. SnowSQL

  B. Dashboards

  C. Python worksheets

  D. Provider Studio

  Correct Answer: C

  Question 24:

  How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

  A. Create transient tables and periodically copy them to permanent tables.

  B. Create temporary tables and periodically copy them to permanent tables.

  C. Create regular tables with extended Time Travel and Fail-safe settings.

  D. Create regular tables with default Time Travel and Fail-safe settings.

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/tables-storage-considerations

  Question 25:

  Which actions can be performed using a resource monitor in Snowflake? (Choose two.)

  A. Monitor the performance of individual queries in real-time.

  B. Automatically allocate more storage space to a virtual warehouse.

  C. Modify the queries being executed within a virtual warehouse.

  D. Suspend a virtual warehouse when its credit usage reaches a defined limit.

  E. Trigger a notification to account administrators when credit usage reaches a specified threshold.

  Correct Answer: DE

  Question 26:

  What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO

  command when loading data from a JSON file into a table?

  A. It flattens multiple arrays into a single array.

  B. It removes the outer array structure and loads separate rows of data.

  C. It transforms a pivoted table into an array.

  D. It tokenizes each data string using the defined delimiters.

  Correct Answer: B

  Question 27:

  Which access control entity in Snowflake can be created as part of a hierarchy within an account?

  A. Securable object

  B. Role

  C. Privilege

  D. User

  Correct Answer: B

  Question 28:

  A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned.

  How should this query be optimized?

  A. Create a view on the table.

  B. Add a clustering key to the table.

  C. Add a LIMIT clause to the query.

  D. Add a Dynamic Data Masking policy to the table.

  Correct Answer: B

  Question 29:

  When an object is created in Snowflake, who owns the object?

  A. The public role

  B. The user's default role

  C. The current active primary role

  D. The owner of the parent schema

  Correct Answer: C

  Question 30:

  Which role is responsible for managing the billing and credit data within Snowflake?

  A. ORGADMIN

  B. ACCOUNTADMIN

  C. SYSADMIN

  D. SECURITYADMIN

  Correct Answer: B

  • 1
  • 2
  • 3
  • 4
  • 5
  • ...
  • 120
  • 121

  Related Exams:

  • ADA-C01

    SnowPro Advanced: Administrator Certification (ADA-C01)

  • ARA-C01

    SnowPro Advanced: Architect Certification (ARA-C01)

  • COF-C02

    SnowPro Core Certification (COF-C02)

  • COF-R02

    SnowPro Core Recertification (COF-R02)

  • DSA-C02

    SnowPro Advanced: Data Scientist Certification (DSA-C02)

  Tips on How to Prepare for the Exams

  Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.