Feb-2025 COF-R02 Study Material, Preparation Guide and PDF Download
Free COF-R02 Certification Sample Questions with Online Practice Test
NEW QUESTION # 48
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
- B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
- C. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- D. Enclose fields that contain delimiter characters in single or double quotes.
- E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- F. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
Answer: B,D,E
NEW QUESTION # 49
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. A Windows server file share on Azure
- B. An HTTPS server with WebDAV
- C. A Google Cloud storage bucket
- D. An FTP server with TLS encryption
Answer: C
NEW QUESTION # 50
What COPY INTO SQL command should be used to unload data into multiple files?
- A. MULTIPLE=FALSE
- B. SINGLE=TRUE
- C. MULTIPLE=TRUE
- D. SINGLE=FALSE
Answer: A
NEW QUESTION # 51
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Is activated using an "ALTER DATABASE" command
- B. Restricts or enables access to specific IP addresses
- C. Is only available to customers with Business Critical Edition
- D. Is available to all Snowflake Editions
Answer: B,D
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html
NEW QUESTION # 52
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
- A. The size of the data required for each query
- B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C. The complexity of each query
- D. The tool that s executing the query
Answer: A,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 53
Which of the following statements describe features of Snowflake data caching? (Choose two.)
- A. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
- B. A user can only access their own queries from the query result cache.
- C. When the data cache is full, the least-recently used data will be cleared to make room.
- D. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
- E. The RESULT_SCAN table function can access and filter the contents of the query result cache.
Answer: A,C
NEW QUESTION # 54
Which TABLE function helps to convert semi-structured data to a relational representation?
- A. PARSE_JSON
- B. TO_JSON
- C. CHECK_JSON
- D. FLATTEN
Answer: A
NEW QUESTION # 55
What happens when a virtual warehouse is resized?
- A. Users who are trying to use the warehouse will receive an error message until the resizing is complete
- B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
- C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- D. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
Answer: B
NEW QUESTION # 56
When loading data into Snowflake, how should the data be organized?
- A. Into files of maximum size of 4 GB of compressed data per file
- B. Into files of maximum size of 1 GB of compressed data per file
- C. Into single files with 100-250 MB of compressed data per file
- D. Into single files with 1-100 MB of compressed data per file
Answer: C
NEW QUESTION # 57
What happens when an external or an internal stage is dropped? (Select TWO).
- A. When dropping an external stage, the files are not removed and only the stage is dropped
- B. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
- C. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
- D. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
- E. When dropping an external stage, both the stage and the files within the stage are removed
Answer: A,B
NEW QUESTION # 58
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. IBM Cloud
- B. Docker
- C. Microsoft Azure Cloud
- D. Oracle Cloud
- E. Google Cloud Platform
- F. Amazon Web Services
Answer: B,C,E
NEW QUESTION # 59
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
- A. 4 minutes
- B. 10 minutes
- C. 24 minutes
- D. 14 minutes
Answer: D
NEW QUESTION # 60
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
- A. Metadata
- B. Authentication
- C. Data storage
- D. Query execution
- E. Compute resources
Answer: A,B
NEW QUESTION # 61
What type of query benefits the MOST from search optimization?
- A. A query that uses only disjunction (i.e., OR) predicates
- B. A query that filters on semi-structured data types
- C. A query that uses equality predicates or predicates that use IN
- D. A query that includes analytical expressions
Answer: C
Explanation:
Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use
NEW QUESTION # 62
In a Snowflake role hierarchy, what is the top-level role?
- A. ORGADMIN
- B. SECURITYADMIN
- C. SYSADMIN
- D. ACCOUNTADMIN
Answer: A
NEW QUESTION # 63
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 64
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.
NEW QUESTION # 65
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
- A. Materialized view
- B. Clustered table
- C. Secure view
- D. Sequence
- E. Transient table
Answer: B,E
NEW QUESTION # 66
Which Snowflake partner specializes in data catalog solutions?
- A. DataRobot
- B. Alation
- C. Tableau
- D. dbt
Answer: B
Explanation:
Explanation
Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html
NEW QUESTION # 67
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. False
- B. True
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION # 68
Which of the following can be executed/called with Snowpipe?
- A. A single copy_into statement
- B. A User Defined Function (UDF)
- C. A single insert__into statement
- D. A stored procedure
Answer: A
NEW QUESTION # 69
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- B. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
- C. A multi-cluster Warehouse can scale down when query activity slows
- D. A multi-cluster Warehouse can add clusters automatically based on query activity
Answer: A,B,C,D
NEW QUESTION # 70
......
COF-R02 Certification Study Guide Pass COF-R02 Fast: https://pdfpractice.actual4dumps.com/COF-R02-study-material.html