Share Latest Dec-2024 COF-C02 DUMP with 697 Questions and Answers
PDF Dumps 2024 Exam Questions with Practice Test
NEW QUESTION # 84
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
- A. select metadata$filename from @bronzestage;
- B. list @bronzestage;
- C. select * from directory(@bronzestage);
- D. select * from table(information_schema.stage_directory_file_registration_history(
Answer: C
Explanation:
stage name=>'bronzestage1));
Explanation:
According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL has the following format:
https://<account_identifier>/api/files/<db_name>.<schema_name>.<stage_name>/<relative_path> Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is B. select * from directory(@bronzestage);
NEW QUESTION # 85
Users are responsible for data storage costs until what occurs?
- A. Data is truncated from a table
- B. Data expires from Fail-safe
- C. Data expires from Time Travel
- D. Data is deleted from a table
Answer: B
NEW QUESTION # 86
What is cached during a query on a virtual warehouse?
- A. The columns in the result set of the query
- B. All columns in a micro-partition
- C. Any columns accessed during the query
- D. All rows accessed during the query
Answer: C
NEW QUESTION # 87
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- A. Query execution
- B. Metadata
- C. Compute resources
- D. Authentication
- E. Data storage
Answer: B,D
Explanation:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
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
NEW QUESTION # 88
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
- A. SYSADMIN
- B. USERADMIN
- C. SECURITYADMIN
- D. ACCOUNTADMIN
Answer: D
Explanation:
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should ideally be granted to the ACCOUNTADMIN role. This recommendation stems from the best practices for implementing a least privilege access control model, ensuring that only the necessary permissions are granted at each level of the role hierarchy. The ACCOUNTADMIN role has the highest level of privileges in Snowflake, including the ability to manage all aspects of the Snowflake account. By assigning the top-most custom role to ACCOUNTADMIN, you ensure that the administration of role hierarchies and the assignment of roles remain under the control of users with the highest level of oversight and responsibility within the Snowflake environment.
References:
* Snowflake Documentation on Access Control: Managing Access Control
NEW QUESTION # 89
In which use cases does Snowflake apply egress charges?
- A. Query result retrieval
- B. Loading data into Snowflake
- C. Data sharing within a specific region
- D. Database replication
Answer: C
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%20data%20egress,out%20of%20the%20cloud%20platform.
NEW QUESTION # 90
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
- A. USAGE
- B. CREATE
- C. MODIFY
- D. OWNERSHIP
Answer: D
NEW QUESTION # 91
How does Snowflake handle the bulk unloading of data into single or multiple files?
- A. It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
- B. It assigns each unloaded data file a unique name.
- C. It uses the put command to download the data by default.
- D. It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
Answer: B
NEW QUESTION # 92
Which function is used to unload a relational table into a JSON file*?
- A. OBJECT_CONSTRUCT
- B. TO_JSON
- C. JSON_EXTRACT_PATH_TEXT
- D. PARSE_JSON
Answer: B
Explanation:
TheTO_JSONfunction in Snowflake is used to convert a relational table or individual rows into JSON format.
This function is helpful for exporting data in JSON format.
* Using TO_JSON Function:
SELECT TO_JSON(OBJECT_CONSTRUCT(*))
FROM my_table;
* Exporting Data:TheTO_JSONfunction converts the table rows into JSON format, which can then be exported to a file.
References:
* Snowflake Documentation: TO_JSON Function
* Snowflake Documentation: Exporting Data
NEW QUESTION # 93
The FLATEEN function is used to query which type of data in Snowflake?
- A. None of the above
- B. Structured data
- C. Semi-structured data
- D. Both of the above
Answer: C
NEW QUESTION # 94
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
- A. Quick provisioning of Dev and Test/QA environments
- B. Point in time snapshots
- C. Performance optimization
- D. Data backups
Answer: A,B,D
NEW QUESTION # 95
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Load files that are approximately 25 MB or smaller.
- B. Avoid using embedded characters such as commas for numeric data types
- C. Load files that are approximately 100-250 MB (or larger)
- D. Remove all dates and timestamps.
- E. Remove semi-structured data types
Answer: B,C
NEW QUESTION # 96
A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).
- A. SnowSQL
- B. SnowCD
- C. Snowsight worksheets
- D. Python connector
- E. SQL API
Answer: A,C
Explanation:
To upload a file to an internal Snowflake stage using a PUT command, you can use:
* B. SnowSQL: SnowSQL, the command-line client for Snowflake, supports the PUT command, allowing users to upload files directly to Snowflake stages from their local file systems.
* E. Snowsight worksheets: Snowsight, the web interface for Snowflake, provides a user-friendly environment for executing SQL commands, including the PUT command, through its interactive worksheets.
References:
* Snowflake Documentation: Loading Data into Snowflake using SnowSQL
* Snowflake Documentation: Using Snowsight
NEW QUESTION # 97
What does the TableScan operator represent in the Query Profile?
- A. The list of values provided with the VALUES clause
- B. The access to data stored in stage objects
- C. The records generated using the TABLE (GENERATOR (...)) construct
- D. The access to a single table
Answer: D
NEW QUESTION # 98
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
- A. USAGE
- B. OPERATE
- C. MODIFY
- D. MONITOR
Answer: B
Explanation:
The OPERATE privilege is required for a role to resume a suspended warehouse if auto-resume is not enabled. This privilege allows the role to start, stop, suspend, or resume a virtual warehouse3.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 99
What is the minimum Snowflake edition required to create a materialized view?
- A. Standard Edition
- B. Virtual Private Snowflake Edition
- C. Business Critical Edition
- D. Enterprise Edition
Answer: D
Explanation:
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
NEW QUESTION # 100
Which of the following objects are contained within a schema? (Choose two.)
- A. External table
- B. Stream
- C. Warehouse
- D. Role
- E. Share
- F. User
Answer: A,C
NEW QUESTION # 101
Which of the following SQL statements will list the version of the drivers currently being used?
- A. Execute SELECT CURRENT_ODBC_CLlENT(); from the Web Ul
- B. Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL
- C. Execute SELECT CURRENT_CLIENT(); from an application
- D. Execute SELECT CURRENT_VERSION (); from the Python Connector
Answer: B
Explanation:
The correct SQL statement to list the version of the JDBC (Java Database Connectivity) drivers currently being used is to execute SELECT CURRENT_JDBC_VERSION(); from within SnowSQL or any client application that utilizes JDBC for connecting to Snowflake. Snowflake provides specific functions to query the version of the client drivers or connectors being used, such as JDBC, ODBC, and others. The CURRENT_JDBC_VERSION() function is designed specifically to return the version of the JDBC driver in use.
It's important to note that Snowflake supports various types of drivers and connectors for connecting to different client applications, including ODBC, JDBC, Python, and others. Each of these connectors has its own method or function for querying the current version in use. For JDBC, the appropriate function is CURRENT_JDBC_VERSION(), reflecting the specificity required to obtain version information relevant to the JDBC driver specifically.
References:
* Snowflake Documentation on Client Functions: This information can typically be found in the Snowflake documentation under the section that covers SQL functions, particularly those functions that provide information about the client or session.
NEW QUESTION # 102
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: A
NEW QUESTION # 103
Which privilege is required to use the search optimization service in Snowflake?
- A. GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>
- B. GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
- C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
- D. GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
Answer: C
NEW QUESTION # 104
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Load files that are approximately 25 MB or smaller.
- B. Avoid using embedded characters such as commas for numeric data types
- C. Load files that are approximately 100-250 MB (or larger)
- D. Remove all dates and timestamps.
- E. Remove semi-structured data types
Answer: B,C
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 105
How many network policies can be assigned to an account or specific user at a time?
- A. Three
- B. Two
- C. One
- D. Unlimited
Answer: C
Explanation:
According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts. References: Based on my internal knowledge as of 2021.
NEW QUESTION # 106
......
Dumps for Free COF-C02 Practice Exam Questions: https://braindumps.exam4docs.com/COF-C02-study-questions.html
