2023 Latest 100% Exam Passing Ratio - COF-C02 Dumps PDF
Pass Exam With Full Sureness - COF-C02 Dumps with 503 Questions
Snowflake COF-C02: SnowPro Core Certification exam is a computer-based exam that consists of multiple-choice and scenario-based questions. COF-C02 exam is designed to test the practical knowledge of candidates and their ability to apply their knowledge to real-world scenarios. COF-C02 exam is timed, and candidates have a limited amount of time to complete it.
NEW QUESTION # 37
When unloading data to an external stage, what is the MAXIMUM file size supported?
- A. 5 GB
- B. 16 GB
- C. 10 GB
- D. 1 GB
Answer: A
NEW QUESTION # 38
Which of the following describes how clustering keys work in Snowflake?
- A. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
- B. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
- C. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- D. Clustering keys sort the designated columns over time, without blocking DML operations
Answer: D
NEW QUESTION # 39
Which of the following objects can be cloned? (Choose four.)
- A. Databases
- B. Users
- C. Named File Formats
- D. Schemas
- E. Tables
- F. Shares
Answer: A,C,D,E
NEW QUESTION # 40
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A. True
- B. False
Answer: A
NEW QUESTION # 41
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A. ARRAY
- B. BLOB
- C. VARCHAR
- D. XML
- E. VARIANT
Answer: A,E
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
NEW QUESTION # 42
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
- A. Summarizing the throughput of Snowpipe costs for an account
- B. Gathering the hourly credit usage for an account
- C. Compiling an account's average cloud services cost over the previous month
- D. Calculating the funds left on an account's contract
Answer: B
NEW QUESTION # 43
A materialized view should be created when which of the following occurs? (Choose two.)
- A. There is minimal cost associated with running the query.
- B. The base table gets updated frequently.
- C. The results of the query do not change often and are used frequently.
- D. The query consumes many compute resources every time it runs.
- E. The query is highly optimized and does not consume many compute resources.
Answer: B,C
NEW QUESTION # 44
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
- A. select src:dealership from car_sales;
- B. select src:Dealership from car_sales;
- C. select src.dealership from car_sales;
- D. select dealership from car_sales;
Answer: A
NEW QUESTION # 45
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
- A. list @ %m.ystage;
- B. list @mytable;
- C. list @%raytable;
- D. list @mystage;
Answer: D
NEW QUESTION # 46
The FLATEEN function is used to query which type of data in Snowflake?
- A. Both of the above
- B. None of the above
- C. Structured data
- D. Semi-structured data
Answer: D
NEW QUESTION # 47
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an Internal Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an External Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: B,C,D
NEW QUESTION # 48
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?
- A. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
- B. It removes the outer array structure and loads the records into separate table rows,
- C. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
- D. It removes the last element of the outer array.
Answer: B
Explanation:
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO <table> command to remove the outer array structure and load the records into separate table rows:
copy into <table>
from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true);
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html
NEW QUESTION # 49
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
- A. Increase the warehouse size from Medium to 2XL.
- B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
- C. Configure the warehouse to a multi-cluster warehouse.
- D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Answer: B
NEW QUESTION # 50
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option is used when creating an Internal Stage
- B. validation_mode=return_all_errors is a parameter of the copy command
- C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Answer: B,D
NEW QUESTION # 51
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. True
- B. False
Answer: A
NEW QUESTION # 52
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?
- A. SHOW GRANTS ON ROLE DATA_SCIENCE
- B. SHOW GRANTS TO USER INQUISITIVE_PERSON
- C. SHOW GRANTS OF ROLE DATA_SCIENCE
- D. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
Answer: D
NEW QUESTION # 53
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
- A. 2 minutes
- B. 1 minute
- C. 6 minutes
- D. 8 minutes
Answer: C
NEW QUESTION # 54
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
- A. Metadata management
- B. Query processing
- C. Authentication and access control
- D. Database storage
- E. Local disk caching
Answer: A,B
NEW QUESTION # 55
What is the default character set used when loading CSV files into Snowflake?
- A. UTF-8
- B. UTF-16
- C. ISO S859-1
- D. ANSI_X3.A
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).
NEW QUESTION # 56
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
- A. The size of the virtual warehouse
- B. The number of active users assigned to the warehouse
- C. The duration of the queries that are executed
- D. The length of time the warehouse is running
- E. The number of queries executed
Answer: D,E
NEW QUESTION # 57
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
- A. Partitions scanned is equal to partitions total
- B. The query is spilling to remote storage
- C. An AggregateOperacor node is present
- D. A single join node uses more than 50% of the query time
Answer: B
NEW QUESTION # 58
Which objects together comprise a namespace in Snowflake? (Select TWO).
- A. Database
- B. Account
- C. Table
- D. Virtual warehouse
- E. Schema
Answer: A,E
NEW QUESTION # 59
......
Verified COF-C02 dumps Q&As - 100% Pass from ITExamDownload: https://testking.itexamdownload.com/COF-C02-valid-questions.html