COF-C02 practice questions 521–530

1. Question 521 · 1323 in bank

   Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

   • APipe
   • BExternal stage
   • CTask
   • DStream

   Show answer

   Answer: A

   Explanation

   A is correct answer. Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.

   Source: Adapted from community discussion — learner2023

   References

   • Snowflake documentation

   Next question

2. Question 522 · 1323 in bank

   A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the STRIP_OUTER_ARRAY file format option. What does the STRIP_OUTER_ARRAY file format do?

   • AIt removes the last element of the outer array.
   • BIt removes the outer array structure and loads the records into separate table rows.
   • CIt removes the trailing spaces in the last element of the outer array and loads the records into separate table columns.
   • DIt removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records.

   Show answer

   Answer: B

   Explanation

   STRIP_OUTER_ARRAY, Removes the outer set of square brackets [ ] when loading the data, separating the initial array into multiple lines

   Source: Adapted from community discussion — SV1122

   Next question

3. Question 523 · 1323 in bank

   Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

   • AEach Snowflake account can be hosted in a different cloud vendor and region.
   • BEach Snowflake account must be hosted in a different cloud vendor and region.
   • CAll Snowflake accounts must be hosted in the same cloud vendor and region.
   • DEach Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

   Show answer

   Answer: A

   Explanation

   The cloud platform you choose for each Snowflake account is completely independent from your other Snowflake accounts. In fact, you can choose to host each Snowflake account on a different platform, although this may have some impact on data transfer billing when loading data. https://docs.snowflake.com/en/user-guide/intro-cloud-platforms.html

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

4. Question 524 · 1323 in bank

   If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

   • AThe columns that are queried in the select clause.
   • BThe columns with very high cardinality.
   • CThe columns with many different values.
   • DThe columns most actively used in the select filters.

   Show answer

   Answer: D

   Explanation

   D is correct answer. Snowflake recommends prioritizing keys in the order below: Cluster columns that are most actively used in selective filters. For many fact tables involved in date-based queries (for example “WHERE invoice_date > x AND invoice date <= y”), choosing the date column is a good idea. For event tables, event type might be a good choice, if there are a large number of different event types. (If your table has only a small number of different event types, then see the comments on cardinality below before choosing an event column as a clustering key.) If there is room for additional cluster keys, then consider columns frequently used in join predicates, for example “FROM table1 JOIN table2 ON table2.column_A = table1.column_B”.

   Source: Adapted from community discussion — learner2023

   Next question

5. Question 525 · 1323 in bank

   Select 2

   What are value types that a VARIANT column can store? (Choose two.)

   • ASTRUCT
   • BOBJECT
   • CBINARY
   • DARRAY
   • ECLOB

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

6. Question 526 · 1323 in bank

   A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?

   • AUse auto-ingest Snowpipes to load large files in a serverless model.
   • BProduce the largest files possible, reducing the overall number of files to process.
   • CProduce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
   • DUse an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

   Show answer

   Answer: C

   Explanation

   Snowpipe is designed for continuous ingestion and is built on COPY. The COPY command enables loading batches of data available in external cloud storage or an internal stage. So for the initial stage i think that i s a better solution COPY So the answer is C

   Source: Adapted from community discussion — BigDataBB

   References

   • Snowflake documentation

   Next question

7. Question 527 · 1323 in bank

   True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   Answer is B False: E.g. JDBC: https://docs.snowflake.com/en/user-guide/jdbc.html Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.

   Source: Adapted from community discussion — redsky0

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 528 · 1323 in bank

   For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

   • ACHECK_OPTION
   • BIS_SECURE
   • CIS_UPDATEABLE
   • DTABLE_NAME

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 529 · 1323 in bank

   The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

   • AIn the metadata of the target table for 14 days
   • BIn the metadata of the pipe for 14 days
   • CIn the metadata of the target table for 64 days
   • DIn the metadata of the pipe for 64 days

   Show answer

   Answer: C

   Explanation

   data bulk load history ===> in the metadata of the target table for 64 days snowpipe ====> in the metadata of the pipe for 14 days

   Source: Adapted from community discussion — fahfouhi94

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 530 · 1323 in bank

    User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command will show all privileges granted to that schema?

    • ASHOW GRANTS ON ROLE DATA_SCIENCE
    • BSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
    • CSHOW GRANTS TO USER INQUISITIVE_PERSON
    • DSHOW GRANTS OF ROLE DATA_SCIENCE

    Show answer

    Answer: B

    References

    • Snowflake documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 521. 1323 questions available.