Question 1101 · 1323 in bank
Select 2Which types of charts does Snowsight support? (Choose two.)
Show answer
Answer: BE
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Which types of charts does Snowsight support? (Choose two.)
Answer: BE
Which role in Snowflake allows a user to enable replication for multiple accounts?
Answer: D
Which Snowflake tool is recommended for data batch processing?
Answer: B
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
Answer: A
This is True. Correct answer should be A https://docs.snowflake.com/en/user-guide/ui-worksheet Note Your current interface role determines the default role for worksheets that you open, but the worksheets are not tied to the interface role. Each worksheet has its own role that can be set independently.
Source: Adapted from community discussion — Prajdeo
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Answer: C
While clustering a table, columns with which data types can be used as clustering keys? (Choose two.)
Answer: AC
AC correct - A clustering key can be defined when a table is created by appending a CLUSTER Where each clustering key consists of one or more table columns/expressions, which can be of any data type, except GEOGRAPHY, VARIANT, OBJECT, or ARRAY https://docs.snowflake.com/en/user-guide/tables-clustering-keys
Source: Adapted from community discussion — Heetec
Which use case does the search optimization service support?
Answer: D
D correct. Search optimization can improve the performance of these types of queries: 1)Equality or IN Predicates 2)Substrings and Regular Expressions (LIKE/ILIKE/RLIKE/CONTAINS,... ) 3)Fields in VARIANT Columns 4)Geospatial Functions 5)Conjunctions of Supported Predicates (AND) 6)Disjunctions of Supported Predicates (OR) ----------------------------------------------------------------------------------- The search optimization service does not directly improve the performance of joins. https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-queries
Source: Adapted from community discussion — BobFar
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
Answer: C
What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO [table] command when loading data from a JSON file into a table?
Answer: B
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1101. 1323 questions available.
Version 1.0.0. How we source questions