Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1201:

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

  A. PUT
  B. COPY INTO
  C. TRANSFER
  D. INSERT
  A. PUT

  ---

  Explanation

  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 1202:

  A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?

  A. ACCOUNTADMIN
  B. SYSADMIN
  C. Tables will be standalone or orphaned.
  D. The role that dropped the custom role.

  D. The role that dropped the custom role.

  ---

  Explanation

  Question 1203:

  What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  A. Via the Snowflake Web Interface (Ul)
  B. Via the data_share=true parameter
  C. Via SQL commands
  D. Via Virtual Warehouses

  A. Via the Snowflake Web Interface (Ul)
  C. Via SQL commands

  ---

  Explanation

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

  Question 1204:

  What authentication method does the Kafka connector use within Snowflake?

  A. Key pair authentication
  B. Multi-Factor Authentication (MFA)
  C. OAuth
  D. Username and password

  A. Key pair authentication

  ---

  Explanation

  Question 1205:

  How can a relational table be unloaded into a JSON file?

  A. Use the OBJECT_CONSTRUCT function in conjunction with the COPY INTO command.
  B. Use the COPY INTO command with the file_format set as JSON.
  C. Use the PUT command with the file_format set as JSON.
  D. Use the GET command with the file_format set as JSON.

  B. Use the COPY INTO command with the file_format set as JSON.

  ---

  Explanation

  Question 1206:

  What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PII)? (Select TWO)

  A. Dynamic Data Masking
  B. Transient tables
  C. Secure views
  D. Multi-Factor Authentication (MFA)
  E. Data encryption

  A. Dynamic Data Masking
  C. Secure views

  ---

  Explanation

  Question 1207:

  A query against which table will provide details about bytes consumed by active, Time Travel, and Fail-safe storage?

  A. METERING_HISTORY
  B. DATA_TRANSFER_HISTORY
  C. CREDIT_USAGE_HISTORY
  D. TABLE_STORAGE_METRICS

  D. TABLE_STORAGE_METRICS

  ---

  Explanation

  Question 1208:

  Where would a Snowflake user find information about query activity from 90 days ago?

  A. account__usage . query history view
  B. account__usage.query__history__archive View
  C. information__schema . cruery_history view
  D. information__schema-query history_by_ses s i on view

  A. account__usage . query history view

  ---

  Explanation

  Question 1209:

  What is a characteristic of data micro-partitioning in Snowflake?

  A. Micro-partitioning may introduce data skew
  B. Micro-partitioning requires the definition of a partitioning schema
  C. Micro-partitioning happens when the data is loaded
  D. Micro-partitioning can be disabled within a Snowflake account

  C. Micro-partitioning happens when the data is loaded

  ---

  Explanation

  Question 1210:

  A size X-Small virtual warehouse ran for 90 seconds, and was shut down. The warehouse was then run for another 30 seconds before being shut down again. How many seconds will be billed?

  A. 90 seconds
  B. 120 seconds
  C. 150 seconds
  D. 180 seconds

  D. 180 seconds

  ---

  Explanation

  • 1
  • 2
  • ...
  • 120
  • 121
  • 122
  • 123
  • ...
  • 169
  • 170

  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)

  • DAA-C01

    SnowPro Advanced: Data Analyst (DAA-C01)

  • DSA-C02

    SnowPro Advanced: Data Scientist Certification (DSA-C02)

  • SOL-C01

    SnowPro Associate: Platform Certification

  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.