View Full Snowflake SnowPro Core COF-C03 Exam Dumps and Practice Test Dumps.

 

Question 81

Which Snowflake feature can be used to securely connect an application without exposing a traditional password?

1. Key-pair authentication
2. Table stage
3. Query tag
4. Materialized view

Correct Answer: 1

Explanation

Key-pair authentication allows supported Snowflake users and applications to authenticate using a cryptographic key pair instead of relying on a traditional password. The public key is associated with the Snowflake user, while the private key remains with the client and must be protected securely. This approach is particularly useful for automated applications, scripts, and service connections because passwords do not need to be embedded in application configuration. A stage, query tag, or materialized view serves a different purpose. Key-pair authentication therefore provides an important option for strengthening authentication in programmatic Snowflake connections.

Question 82

Which Snowflake object can be used to represent an external cloud storage location for data files?

1. Internal table
2. External stage
3. Virtual warehouse
4. Secure view

Correct Answer: 2

Explanation

An external stage defines a connection to a supported external cloud storage location where data files can reside. Snowflake can use the stage as part of loading data into tables or unloading data to external storage. This allows organizations to maintain files in their existing cloud storage environment while using Snowflake for data processing and analytics. Internal stages instead store files within Snowflake-managed storage. Virtual warehouses provide compute resources, and secure views provide controlled query representations. External stages are therefore the appropriate Snowflake object when files are maintained outside Snowflake in supported cloud storage.

Question 83

A company stores CSV files in cloud object storage and wants Snowflake to load them without first copying them into an internal stage. What should it configure?

1. External stage
2. Temporary table
3. Materialized view
4. Resource monitor

Correct Answer: 1

Explanation

An external stage is appropriate when source files remain in supported cloud object storage and Snowflake needs to access those files for loading operations. The external stage stores information about the cloud storage location and can include settings needed to access the files. A COPY INTO command can then use the stage as the source for loading data into Snowflake tables. A temporary table stores relational data for a session, while a materialized view and resource monitor serve performance and cost-management purposes. External staging therefore avoids the need to first place the files in Snowflake-managed internal storage.

Question 84

Which Snowflake command is used to create a named stage?

1. CREATE STAGE
2. CREATE LOCATION
3. CREATE FILE
4. CREATE STORAGE

Correct Answer: 1

Explanation

CREATE STAGE is the Snowflake SQL command used to create a named stage. Named stages can be internal or external depending on the configuration and are useful when multiple loading or unloading operations need to reference a reusable staging location. Once created, the stage can be referenced by commands such as COPY INTO. CREATE LOCATION, CREATE FILE, and CREATE STORAGE are not the standard SQL commands for creating Snowflake stages. Named stages also provide administrators with a manageable object to which appropriate privileges can be assigned, making them useful in governed data-ingestion workflows.

Question 85

Which command can list files currently available in a Snowflake stage?

1. SHOW FILES
2. LIST
3. DESCRIBE FILE
4. SHOW STAGE FILES

Correct Answer: 2

Explanation

The LIST command is used in Snowflake to list files in a stage. It can help users verify whether expected files are present before performing a loading operation. This is particularly useful when troubleshooting ingestion problems, checking staged file names, or confirming that an upload completed successfully. SHOW FILES and SHOW STAGE FILES are not the standard Snowflake commands for listing staged files. DESCRIBE FILE is also not the normal command for this task. Checking stage contents with LIST can therefore be an important operational step before executing COPY INTO for data ingestion.

Question 86

A CSV file uses a pipe character as the field delimiter. Which file format property should be configured?

1. FIELD_DELIMITER
2. FILE_EXTENSION
3. COMPRESSION
4. RECORD_DELIMITER

Correct Answer: 1

Explanation

FIELD_DELIMITER specifies the character that separates fields within delimited text files such as CSV files. If a source file uses a pipe character instead of a comma, the file format should define the pipe as the field delimiter so Snowflake interprets the columns correctly during loading. RECORD_DELIMITER serves a different purpose by identifying row boundaries. COMPRESSION describes file compression, while FILE_EXTENSION identifies the file extension rather than the field separator. Correct delimiter configuration is important because an incorrect value can cause Snowflake to interpret an entire row as one field or otherwise load columns incorrectly.

Question 87

Which file format property determines how rows are separated in a delimited text file?

1. FIELD_DELIMITER
2. RECORD_DELIMITER
3. NULL_IF
4. SKIP_HEADER

Correct Answer: 2

Explanation

RECORD_DELIMITER defines the character or sequence that separates records, or rows, in a delimited text file. This setting is important when a source file uses a particular line or record termination convention that differs from the expected default. FIELD_DELIMITER instead controls how individual fields within each record are separated. NULL_IF specifies strings that should be interpreted as SQL NULL values, while SKIP_HEADER controls the number of initial rows skipped during loading. Correct record and field delimiter settings together ensure that Snowflake can parse text files into the intended table structure.

Question 88

A CSV file contains a header row that should not be loaded into the target table. Which file format option can address this?

1. SKIP_HEADER
2. NULL_IF
3. TRIM_SPACE
4. FIELD_OPTIONALLY_ENCLOSED_BY

Correct Answer: 1

Explanation

The SKIP_HEADER file format option can specify the number of header rows that Snowflake should skip when loading a delimited text file. For example, if a CSV file contains one column-name row before the actual data, the file format can be configured to skip that row. NULL_IF identifies strings that should become NULL values, TRIM_SPACE handles whitespace behavior, and FIELD_OPTIONALLY_ENCLOSED_BY controls optional enclosure of field values. Correctly configuring SKIP_HEADER prevents column headings from being inserted as data rows and is a common requirement when ingesting structured text files.

Question 89

Which file format option can identify strings that should be interpreted as SQL NULL values during loading?

1. SKIP_HEADER
2. NULL_IF
3. RECORD_DELIMITER
4. FIELD_DELIMITER

Correct Answer: 2

Explanation

NULL_IF specifies one or more strings that Snowflake should interpret as NULL values when processing supported file formats. This is useful when source systems represent missing information using textual placeholders such as specific tokens rather than an actual database NULL representation. SKIP_HEADER controls header rows, RECORD_DELIMITER separates records, and FIELD_DELIMITER separates fields. Correct NULL handling is important because treating a missing-value marker as ordinary text can produce inaccurate analytical results. By configuring NULL_IF appropriately, data engineers can make the loaded table more accurately reflect the source system’s representation of missing values.

Question 90

Which option can specify that text fields in a CSV file may be enclosed by quotation marks?

1. FIELD_OPTIONALLY_ENCLOSED_BY
2. RECORD_DELIMITER
3. NULL_IF
4. SKIP_HEADER

Correct Answer: 1

Explanation

FIELD_OPTIONALLY_ENCLOSED_BY specifies a character that may optionally surround field values in supported delimited files. Double quotation marks are a common example in CSV data, especially when fields contain delimiter characters or other special content. RECORD_DELIMITER identifies record boundaries, NULL_IF defines strings treated as NULL, and SKIP_HEADER controls how many initial rows are skipped. Proper enclosure settings help Snowflake correctly interpret fields containing embedded delimiters or other characters that could otherwise be mistaken for structural separators. This is an important file-format configuration when ingesting real-world CSV exports.

Question 91

Which Snowflake command is commonly used to inspect the structure and metadata of a table?

1. DESCRIBE TABLE
2. LIST TABLE
3. SHOW ROWS
4. INSPECT TABLE

Correct Answer: 1

Explanation

DESCRIBE TABLE provides information about a table’s structure, including columns and their associated data types and other metadata. It is useful when users need to understand the schema of an existing table before writing queries, loading data, or troubleshooting a mismatch between source files and target columns. LIST is used for stage files rather than table definitions. SHOW ROWS and INSPECT TABLE are not standard Snowflake commands for describing table structure. Understanding table metadata is essential when designing ingestion pipelines because incoming fields must be compatible with the target table’s expected structure and data types.

Question 92

Which Snowflake command can display information about objects such as tables within a schema?

1. SHOW TABLES
2. LIST TABLES
3. DESCRIBE SCHEMA TABLES
4. DISPLAY OBJECTS

Correct Answer: 1

Explanation

SHOW TABLES displays information about tables available to the executing role within the relevant scope. It can help administrators and developers identify existing tables when exploring a schema or troubleshooting object availability. DESCRIBE TABLE is instead used to inspect the structure of a specific table. LIST is associated with staged files, while DISPLAY OBJECTS is not the standard Snowflake command for listing tables. SHOW commands are useful administrative tools because they provide metadata about Snowflake objects without requiring users to query the underlying business data itself.

Question 93

Which SQL command can be used to retrieve the definition or metadata of a view?

1. DESCRIBE VIEW
2. LIST VIEW
3. SHOW VIEW ROWS
4. INSPECT VIEW DATA

Correct Answer: 1

Explanation

DESCRIBE VIEW can be used to obtain information about a Snowflake view, including its columns and associated metadata. This can help users understand what a view exposes before using it in queries or troubleshooting downstream dependencies. Views are logical query definitions rather than independent copies of their source table data. LIST VIEW and SHOW VIEW ROWS are not standard Snowflake commands for inspecting a view. Depending on the administrative requirement, Snowflake also provides other metadata commands and information sources. DESCRIBE VIEW is therefore a relevant command for examining a specific view’s structure.

Question 94

Which Snowflake feature provides centralized metadata about databases, tables, columns, and other account objects?

1. Information Schema
2. Result cache
3. Resource monitor
4. User stage

Correct Answer: 1

Explanation

Snowflake Information Schema provides metadata views and functions that allow users to inspect information about databases, schemas, tables, columns, privileges, and other supported objects. It is useful for administrative queries, auditing, documentation, and automation because metadata can be retrieved using SQL. Result cache is associated with query-result reuse, resource monitors track credit usage, and user stages store files for individual users. Information Schema is therefore an important source when organizations need programmatic visibility into Snowflake object metadata rather than manually inspecting individual objects through the interface.

Question 95

A data engineer needs a SQL-based way to find tables in a database based on metadata conditions. What should be considered?

1. Information Schema
2. Time Travel
3. Search optimization
4. Multi-cluster warehouse

Correct Answer: 1

Explanation

Information Schema provides SQL-accessible metadata about Snowflake objects and can be queried to identify tables, columns, views, privileges, and other information according to supported metadata views. This makes it useful for automation and inventory tasks where an engineer needs to filter or analyze object metadata programmatically. Time Travel is concerned with historical data, search optimization improves selected query patterns, and multi-cluster warehouses address concurrency. Information Schema therefore fits requirements involving metadata discovery through SQL. Users should also consider the scope and privileges associated with the specific Information Schema views they query.

Question 96

Which Snowflake feature allows users to query metadata about objects in a database without directly querying the underlying business tables?

1. Information Schema
2. Materialized view
3. Secure data share
4. Table stage

Correct Answer: 1

Explanation

Information Schema provides metadata views that describe Snowflake objects without requiring users to query the underlying business data. This can include information about tables, columns, views, schemas, privileges, and other supported objects. Such metadata access is useful for inventory, governance, automation, and administrative reporting. A materialized view contains maintained query results, a secure data share provides controlled access to shared data, and a table stage stores files associated with a table. Information Schema is therefore the appropriate capability when the requirement is to inspect structural or administrative metadata using SQL.

Question 97

Which Snowflake capability allows data to be shared with consumers while keeping the provider responsible for the shared data?

1. Secure Data Sharing
2. Local file transfer
3. Table duplication
4. Manual CSV export

Correct Answer: 1

Explanation

Secure Data Sharing allows a data provider to share selected Snowflake data with consumers without requiring the traditional creation of duplicate physical datasets for each consumer. The provider controls the shared objects and can manage what is made available through the sharing configuration. This model simplifies distribution and can help consumers access current shared information without maintaining separate copies. Manual CSV exports and table duplication require additional data movement and management, while local file transfer is not the core Snowflake sharing model. Secure Data Sharing is therefore well suited to governed data distribution.

Question 98

A provider wants another Snowflake account to access a selected table but does not want to grant access to unrelated tables. What should the provider configure?

1. A share containing the required objects
2. ACCOUNTADMIN for the consumer
3. A shared virtual warehouse
4. A user stage

Correct Answer: 3

Explanation

A Snowflake share can be configured to expose selected objects to another account without granting access to unrelated database objects. The provider can control which supported databases, schemas, tables, or views are included in the share and manage the associated access model. Granting ACCOUNTADMIN would provide excessive privileges and is not an appropriate mechanism for controlled data sharing. A virtual warehouse supplies compute resources and a user stage is for file staging. Using a share allows organizations to distribute specific datasets while maintaining boundaries around information that should remain private.

Question 99

Which Snowflake feature is intended to allow secure sharing of data across different Snowflake accounts?

1. Secure Data Sharing
2. Query Profile
3. Search Optimization Service
4. Automatic clustering

Correct Answer: 1

Explanation

Secure Data Sharing enables supported Snowflake data to be shared across accounts without requiring the provider to copy the shared data into the consumer’s environment through traditional file-based transfer. The provider controls which objects are exposed, while consumers access the shared data according to the sharing configuration. Query Profile helps analyze query execution, Search Optimization Service improves certain selective workloads, and automatic clustering addresses data organization and performance. Secure Data Sharing is therefore the feature directly associated with cross-account data distribution. It can reduce duplication and simplify controlled access to datasets maintained by a provider.

Question 100

Which Snowflake capability is designed to provide controlled access to data without requiring a consumer to maintain a traditional physical copy of the shared dataset?

1. Secure Data Sharing
2. COPY INTO
3. Internal staging
4. File format

Correct Answer: 1

Explanation

Secure Data Sharing provides controlled access to selected Snowflake data without requiring the consumer to receive and maintain a traditional copied dataset. This model can simplify data distribution because the provider manages the shared objects and determines what consumers can access. COPY INTO is used for loading and unloading data, internal stages provide Snowflake-managed file storage, and file formats define how files are interpreted. Secure Data Sharing is therefore the appropriate capability when an organization wants governed data access while avoiding the operational overhead associated with repeatedly exporting, transferring, and importing duplicate datasets.