Updated Jan-2024 Official licence for COF-C02 Certified by COF-C02 Dumps PDF
Grab latest Amazon COF-C02 Dumps as PDF Updated on 2024
Snowflake COF-C02 certification exam is an industry-recognized credential that showcases the candidate's proficiency in cloud data warehousing. SnowPro Core Certification Exam certification program is ideal for professionals who are looking to enhance their skills in cloud data management and analytics. SnowPro Core Certification Exam certification provides a competitive edge to the candidates over others in the industry and increases their chances of getting hired by top organizations.
NEW QUESTION # 198
In which use cases does Snowflake apply egress charges?
- A. Query result retrieval
- B. Data sharing within a specific region
- C. Loading data into Snowflake
- D. Database replication
Answer: B
Explanation:
Explanation
Cloud providers apply data egress charges in either of the following use cases:
* Data is transferred from one region to another within the same cloud platform.
* Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20d
NEW QUESTION # 199
Fail-safe is unavailable on which table types?
- A. Permanent
- B. Provisional
- C. Transient
- D. Temporary
Answer: C,D
NEW QUESTION # 200
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Compute Layer
- B. Database Layer
- C. Storage Layer
- D. Cloud Service Layer
Answer: D
NEW QUESTION # 201
What Snowflake role must be granted for a user to create and manage accounts?
- A. ORGADMIN
- B. SYSADMIN
- C. SECURITYADMIN
- D. ACCOUNTADMIN
Answer: D
NEW QUESTION # 202
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
- A. Physical storage of micro-partitions
- B. Authentication
- C. Resource management
- D. Query parsing and optimization
- E. Virtual warehouse caching
- F. Query execution
Answer: B,D,F
NEW QUESTION # 203
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. VARCHAR
- B. RAW
- C. LOB
- D. VARIANT
Answer: D
NEW QUESTION # 204
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
- A. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
- B. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
- C. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
- D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
- E. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
- F. Scaling out adds clusters of varying sizes to a virtual warehouse.
Answer: B,E
NEW QUESTION # 205
Which statement is true about running tasks in Snowflake?
- A. A task allows a user to execute a single SQL statement/command using a predefined schedule.
- B. A task allows a user to execute a set of SQL commands on a predefined schedule.
- C. A task can be called using a CALL statement to run a set of predefined SQL commands.
- D. A task can be executed using a SELECT statement to run a predefined SQL command.
Answer: B
NEW QUESTION # 206
What does Snowflake's search optimization service support?
- A. External tables
- B. Materialized views
- C. Casts on table columns (except for fixed-point numbers cast to strings)
- D. Tables and views that are not protected by row access policies
Answer: D
NEW QUESTION # 207
Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?
- A. LOAD_HOSTORY
- B. QUERY_HISTORY
- C. ACCESS_HISTORY
- D. COPY_HISTORY
Answer: C
NEW QUESTION # 208
What are characteristics of reader accounts in Snowflake? (Select TWO).
- A. Reader account users can share data to other reader accounts.
- B. Data consumers are responsible for reader account setup and data usage costs.
- C. Reader account users cannot add new data to the account.
- D. A single reader account can consume data from multiple provider accounts.
- E. Reader accounts enable data consumers to access and query data shared by the provider.
Answer: C,E
NEW QUESTION # 209
Which are true of Snowflake roles?
- A. The public role controls at other roles
- B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- C. Roles are a subset of users and users own objects In Snowflake
- D. All grants to objects are given to roles, and never to users
Answer: B,D
NEW QUESTION # 210
Which of the following statements describe features of Snowflake data caching? (Choose two.)
- A. When the data cache is full, the least-recently used data will be cleared to make room.
- B. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
- C. The RESULT_SCAN table function can access and filter the contents of the query result cache.
- D. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
- E. A user can only access their own queries from the query result cache.
Answer: A,B
NEW QUESTION # 211
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 last element of the outer array.
- B. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
- C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
- D. It removes the outer array structure and loads the records into separate table rows,
Answer: D
NEW QUESTION # 212
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION # 213
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: B
NEW QUESTION # 214
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
- A. OBJECT
- B. GEOMETRY
- C. VARIANT
- D. BINARY
- E. GEOGRAPHY
Answer: D,E
NEW QUESTION # 215
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. True
- B. False
Answer: B
NEW QUESTION # 216
What is the minimum Snowflake edition required for row level security?
- A. Business Critical
- B. Virtual Private Snowflake
- C. Enterprise
- D. Standard
Answer: C
NEW QUESTION # 217
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A. True
- B. False
Answer: B
Explanation:
Explanation
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
NEW QUESTION # 218
......
Latest COF-C02 Exam Dumps Snowflake Exam from Training: https://www.passleader.top/Snowflake/COF-C02-exam-braindumps.html
Newly Released COF-C02 Dumps for SnowPro Core Certified: https://drive.google.com/open?id=1FSjK-zWqJfYX-As497vpW4GCBG0KH70Y