Rebirth COF-C02 Training Tools For SnowPro Core Certification Exam (COF-C02) Certification

NEW QUESTION 1

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 @mytable;
• B. list @%raytable;
• C. list @ %m.ystage;
• D. list @mystage;

Answer: D

Explanation:
The command list @mystage; is used to view the list of files that have been uploaded to an internal stage in Snowflake. The list command displays the metadata for all files in the specified stage, which in this case is mystage. This command is particularly useful for verifying that files have been successfully unloaded from a Snowflake table to the stage and for managing the files within the stage.
References:
✑ Snowflake Documentation on Stages
✑ SnowPro® Core Certification Study Guide

NEW QUESTION 2

Which type of workload traditionally benefits from the use of the query acceleration service?

• A. Workloads with a predictable data volume for each query
• B. Workloads that include on-demand data analyses
• C. Queries with small scans and non-selective filters
• D. Queries that do not have filters or aggregation

Answer: B

Explanation:
The query acceleration service in Snowflake is beneficial for workloads that include on- demand data analyses. This service optimizes query performance by dynamically allocating additional resources to execute queries faster, particularly useful for ad-hoc analysis where data volume and complexity can vary.
References:
✑ Snowflake Documentation: Query Acceleration Service

NEW QUESTION 3

Which Snowflake object does not consume any storage costs?

• A. Secure view
• B. Materialized view
• C. Temporary table
• D. Transient table

Answer: C

Explanation:
Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges4. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 4

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

• A. Snowflake leverages a Role-Based Access Control (RBAC) model.
• B. Snowflake requires a user to configure an IAM user to connect to the database.
• C. All data in Snowflake is encrypted.
• D. Snowflake can run within a user's own Virtual Private Cloud (VPC).
• E. All data in Snowflake is compressed.

Answer: AC

Explanation:
Snowflake uses a Role-Based Access Control (RBAC) model to manage access to data and resources. Additionally, Snowflake ensures that all data is encrypted, both at rest and in transit, to provide a high level of security for data stored within the platform. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 5

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: B

Explanation:
In Snowflake, to extract a specific element from a JSON stored in a VARIANT column, the correct syntax is to use the dot notation. Therefore, the query select src.dealership from car_sales; will return the dealership information contained within each JSON object in the src column.
References: For a detailed explanation, please refer to the Snowflake documentation on querying semi-structured data.

NEW QUESTION 6

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

• A. Data:employee.name
• B. DATA:employee.name
• C. data:Employee.name
• D. data:employee.name

Answer: D

Explanation:
In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive.
Therefore, to extract the employee??s name from the ??Data?? column, the correct syntax is data:employee.name.

NEW QUESTION 7

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A. Grant the OWNERSHIP privilege on the schema.
• B. Grant the OWNERSHIP privilege on the database.
• C. Grant the MANAGE GRANTS global privilege.
• D. Grant ALL privileges on the schema.

Answer: C

Explanation:
To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege. This privilege allows the user to manage access control through grants on all securable objects within Snowflake2. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 8

How can a user improve the performance of a single large complex query in Snowflake?

• A. Scale up the virtual warehouse.
• B. Scale out the virtual warehouse.
• C. Enable standard warehouse scaling.
• D. Enable economy warehouse scaling.

Answer: A

Explanation:
Scaling up the virtual warehouse in Snowflake involves increasing the compute resources available for a single warehouse, which can improve the performance of large and complex queries by providing more CPU and memory resources. References: Based on general cloud data warehousing knowledge as of 2021.

NEW QUESTION 9

What factors impact storage costs in Snowflake? (Select TWO).

• A. The account type
• B. The storage file format
• C. The cloud region used by the account
• D. The type of data being stored
• E. The cloud platform being used

Answer: AC

Explanation:
The factors that impact storage costs in Snowflake include the account type (Capacity or On Demand) and the cloud region used by the account. These factors determine the rate at which storage is billed, with different regions potentially having different rates3.

NEW QUESTION 10

Which copy INTO command outputs the data into one file?

• A. SINGLE=TRUE
• B. MAX_FILE_NUMBER=1
• C. FILE_NUMBER=1
• D. MULTIPLE=FAISE

Answer: B

Explanation:
The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of files generated by the command, ensuring that only one file is created
regardless of the amount of data being exported.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Data Unloading

NEW QUESTION 11

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

• A. Whether or not it is also a secure view
• B. How often the underlying base table is queried
• C. How often the base table changes
• D. Whether the materialized view has a cluster key defined
• E. How often the materialized view is queried

Answer: CD

Explanation:
The credit consumption for maintaining a materialized view is impacted by how often the base table changes © and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view??s maintenance. References: SnowPro Core Certification materialized view credit consumption

NEW QUESTION 12

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

• A. Bytes scanned
• B. Bytes written to result
• C. Partitions scanned
• D. Partitions total
• E. Percentage scanned from cache

Answer: CD

Explanation:
The statistics that can be used to identify queries with inefficient pruning are ??Partitions scanned?? and ??Partitions total??. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.

NEW QUESTION 13

What action can a user take to address query concurrency issues?

• A. Enable the query acceleration service.
• B. Enable the search optimization service.
• C. Add additional clusters to the virtual warehouse
• D. Resize the virtual warehouse to a larger instance size.

Answer: C

Explanation:
To address query concurrency issues, a user can add additional clusters to the virtual warehouse. This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

NEW QUESTION 14

When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

• A. echo
• B. quiet
• C. output_file
• D. output_format
• E. force_put_overwrite

Answer: CD

Explanation:
When unloading data from SnowSQL (Snowflake's command-line client), to a file on a local machine, you need to specify certain configuration options to determine how and where the data should be outputted. The correct configuration options required are:
✑ C. output_file: This configuration option specifies the file path where the output from the query should be stored. It is essential for directing the results of your SQL query into a local file, rather than just displaying it on the screen.
✑ D. output_format: This option determines the format of the output file (e.g., CSV, JSON, etc.). It is crucial for ensuring that the data is unloaded in a structured format that meets the requirements of downstream processes or systems.
These options are specified in the SnowSQL configuration file or directly in the SnowSQL command line. The configuration file allows users to set defaults and customize their usage of SnowSQL, including output preferences for unloading data.
References:
✑ Snowflake Documentation: SnowSQL (CLI Client) at Snowflake Documentation
✑ Snowflake Documentation: Configuring SnowSQL at Snowflake Documentation

NEW QUESTION 15

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?

• A. Row access policies
• B. Data masking policies
• C. Data encryption
• D. Role based access control

Answer: B

Explanation:
Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others. This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.

NEW QUESTION 16

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

• A. Caching query results
• B. Running EXPLAIN and SHOW commands
• C. Cloning a database
• D. Running a custom query
• E. Running COPY commands

Answer: BD

Explanation:
Running EXPLAIN and SHOW commands, as well as running a custom query, consume virtual warehouse credits in the Snowflake environment. These activities require computational resources, and therefore, credits are used to account for the usage of these resources. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 17

Snowflake's access control framework combines which models for securing data? (Select TWO).

• A. Attribute-based Access Control (ABAC 1
• B. Discretionary Access Control (DAC)
• C. Access Control List (ACL)
• D. Role-based Access Control (RBAC)
• E. Rule-based Access Control (RuBAC)

Answer: BD

Explanation:
Snowflake's access control framework utilizes a combination of Discretionary Access Control (DAC) and Role-based Access Control (RBAC). DAC in Snowflake allows the object owner to grant access privileges to other roles. RBAC involves assigning roles to users and then granting privileges to those roles. Through roles, Snowflake manages which users have access to specific objects and what actions they can perform, which is central to security and governance in the Snowflake environment.References:Snowflake Documentation on Access Control,

NEW QUESTION 18

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

• A. Column compression
• B. Data clustering
• C. Micro-partitioning
• D. Metadata management

Answer: C

Explanation:
Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning. It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.

NEW QUESTION 19
......