Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1161:

  Which of the following statements are true of Snowflake data loading? Choose 3 answers

  A. VARIANT "nut" values are not the same as SQL Null values

  B. It is recommended to do frequent, single row DMLS

  C. It is recommended to validate the data before loading into the Snowflake target table

  D. It is recommended to use staging tables to manage MERGE statements

  Correct Answer: ACD

• Question 1162:

  What command is used to load files into an Internal Stage within Snowflake? Select one.

  A. PUT

  B. COPY INTO

  C. TRANSFER

  D. INSERT

  Correct Answer: A

  You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO

  command when loading data into a table from the staged files.

  Question 1163:

  Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

  A. Micro-partitions

  B. Clustering keys

  C. Key partitions

  D. Clustered partitions

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

  Question 1164:

  What is the minimum Snowflake edition that provides data sharing?

  A. Standard

  B. Premier

  C. Enterprise

  D. Business Critical Edition

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

  Question 1165:

  Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

  A. MIN(< < column value>>)

  B. COPY

  C. SUM(<< column value >>)

  D. UPDATE

  Correct Answer: BCD

  Question 1166:

  When creating a user it is advisable sable to: Choose 2 answers

  A. Set the user to be initially disabled

  B. Force an immediate password change

  C. Set a default role for the user

  D. Set the number of minutes to unlock to 15 minutes

  E. Set the users access to expire within a specified timeframe

  Correct Answer: BC

  Question 1167:

  For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

  A. The number of queries that ran using the Warehouse.

  B. The size of the Warehouse and the number of clusters that ran within a given time period.

  C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

  D. The number of users who accessed the Warehouse.

  Correct Answer: B

  Question 1168:

  What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

  A. Installing and configuring hardware

  B. Patching software

  C. Physical security

  D. Maintaining metadata and statists

  Correct Answer: ABD

  Question 1169:

  True or False: Once created, a micro-partition will never be changed.

  A. True

  B. False

  Correct Answer: A

  Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

  Question 1170:

  Which of the following statements are true of Snowflake releases: (Choose two.)

  A. They happen approximately weekly

  B. They roll up and release approximately monthly, but customers can request early release application

  C. During a release, new customer requests/queries/connections transparently move over to the newer version

  D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

  Correct Answer: AC

  https://docs.snowflake.com/en/user-guide/intro-releases.html

  • 1
  • 2
  • ...
  • 116
  • 117
  • 118
  • 119
  • ...
  • 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.