COF-C02 practice questions 311–320

1. Question 311 · 1323 in bank

   What type of query benefits the MOST from search optimization?

   • AA query that uses only disjunction (i.e., OR) predicates
   • BA query that includes analytical expressions
   • CA query that uses equality predicates or predicates that use IN
   • DA query that filters on semi-structured data types

   Show answer

   Answer: C

   Explanation

   The correct answer is C. 2: Below are the recommended checks to consider for the query: At least one of the columns accessed through the query filter operation has at least 100k-200k distinct values. The query uses equality predicate or predicates that use IN. The query returns a few rows with highly selective filters. The query typically runs for at least tens of seconds. https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

2. Question 312 · 1323 in bank

   Select 2

   What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)

   • AData can be filtered by an optional WHERE clause.
   • BIncoming data can be joined with other tables.
   • CColumns can be reordered.
   • DColumns can be omitted.
   • ERow level access can be defined.

   Show answer

   Answer: CD

   Explanation

   Using a query as the source for the COPY statement for column reordering [C], column omission [D], and casts (i.e. transforming data during a load) is supported. For usage examples, see Transforming Data During a Load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported [E].

   Source: Adapted from community discussion — EmiB

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 313 · 1323 in bank

   Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

   • AAuto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
   • BThe ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
   • CSnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
   • DA user cannot specify a default warehouse when using the ODBC driver.
   • EThe default virtual warehouse size can be changed at any time.

   Show answer

   Answer: C

   Explanation

   CE are correct. I cant believe exam topics wants to charge for this test. We cant even vote for the correct answer in this case. What a joke.

   Source: Adapted from community discussion — nintendogamer64

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 314 · 1323 in bank

   Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

   • AINSERT
   • BPUT
   • CGET
   • DCOPY

   Show answer

   Answer: D

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 315 · 1323 in bank

   The Snowflake Cloud Data Platform is described as having which of the following architectures?

   • AShared-disk
   • BShared-nothing
   • CMulti-cluster shared data
   • DServerless query engine

   Show answer

   Answer: C

   Explanation

   https://docs.snowflake.com/en/user-guide/intro-key-concepts#snowflake-architecture "Snowflake uses a central data repository for persisted data that is accessible from all compute nodes in the platform" So it is definitely shared data "Snowflake processes queries using MPP (massively parallel processing) compute clusters" And it uses multiple clusters for processing. So the answer is C, Multi-cliuster shared data. Sometimes the question answers aren't verbatim from the docs, you have to understand the meaning of words.

   Source: Adapted from community discussion — MBrat

   References

   • Snowflake documentation

   Next question

6. Question 316 · 1323 in bank

   Which of the following is a data tokenization integration partner?

   • AProtegrity
   • BTableau
   • CDBeaver
   • DSAP

   Show answer

   Answer: A

   Explanation

   The following partners facilitate external tokenization in Snowflake. To use these partner integrations, follow the instructions in the partner documentation or contact the partner to begin the configuration process: ALTR Baffle Fortanix MicroFocus CyberRes Voltage Protegrity Privacera SecuPI Skyflow

   Source: Adapted from community discussion — kjdfsafc87456

   References

   • Snowflake documentation

   Next question

7. Question 317 · 1323 in bank

   Select 2

   Snowflake is designed for which type of workloads? (Choose two.)

   • AOLAP (Analytics) workloads
   • BOLTP (Transactional) workloads
   • CConcurrent workloads
   • DOn-premise workloads

   Show answer

   Answer: AC

   Explanation

   A. OLAP (Analytics) workloads C. Concurrent workloads Snowflake is primarily designed for analytical processing (OLAP) and can efficiently handle concurrent workloads due to its architecture, which allows multiple virtual warehouses to operate independently and scale as needed. It is not optimized for OLTP (Transactional) workloads, which typically require low-latency operations, nor is it designed specifically for on-premise workloads, as it is a cloud-based data warehousing solution.

   Source: Adapted from community discussion — PrashantGupta1616

   Next question

8. Question 318 · 1323 in bank

   Select 2

   What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

   • ACustom Edition
   • BVirtual Private Snowflake
   • CBusiness Critical Edition
   • DStandard Edition
   • EEnterprise Edition

   Show answer

   Answer: BC

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 319 · 1323 in bank

   Select 3

   What are supported file formats for unloading data from Snowflake? (Choose three.)

   • AXML
   • BJSON
   • CParquet
   • DORC
   • EAVRO
   • FCSV

   Show answer

   Answer: BCF

   References

   • Snowflake documentation

   Next question

10. Question 320 · 1323 in bank

    Select 2

    The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

    • ALocal disk caching
    • BAuthentication and access control
    • CMetadata management
    • DQuery processing
    • EDatabase storage

    Show answer

    Answer: BC

    Explanation

    Correct answer should be BC Cloud Services: The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

    Source: Adapted from community discussion — isolated_sniper

    References

    • Snowflake documentation

    Next question

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

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