최신 COF-R02 무료덤프 - Snowflake SnowPro Core Recertification

A. SECURITYADMIN

B. ORGADMIN

C. SYSADMIN

D. ACCOUNTADMIN

A. Store the files on the external stage to ensure caching is maintained

B. Organize files into logical paths

C. Load the data in one large file

D. Use pattern matching for regular expression execution

A. Row level access can be defined

B. Columns can be reordered

C. Incoming data can be joined with other tables

D. Data can be filtered by an optional where clause

E. Columns can be omitted

A. External Tokenization

B. Materialized Views

C. User-Defined Table Functions (UDTF)

D. External Tables

A. 10-50 MB

B. 1000-1500 MB

C. 100-250 MB

D. 300-500 MB

A. Zero-copy clones

B. Fail-safe

C. Internal stages

D. Incremental backups

E. Time Travel

A. The clustering key must be included in the COPY command when loading data into Snowflake.

B. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

C. Clustering can be disabled within a Snowflake account.

D. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

A. True

B. False

A. A task allows a user to execute a set of SQL commands on a predefined schedule.

B. A task can be executed using a SELECT statement to run a predefined SQL command.

C. A task allows a user to execute a single SQL statement/command using a predefined schedule.

D. A task can be called using a CALL statement to run a set of predefined SQL commands.

A. The columns that are queried in the select clause.

B. The columns with very high cardinality.

C. The columns most actively used in the select filters.

D. The columns with many different values.

A. It was built specifically for the cloud

B. it was built as an on-premises solution and then potted to the cloud

C. It was built for Hadoop architecture

D. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

E. It's based on an Oracle Architecture

A. Stream

B. Pipe

C. External stage

D. Task

A. The clone is created almost instantly.

B. The clone always stays in sync with the original table.

C. The clone saves space by not duplicating storage.

D. The clone will have time travel history from the original table.

E. The clone has better query performance.

A. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

B. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

C. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

D. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

E. Scaling out adds clusters of varying sizes to a virtual warehouse.

F. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

A. Set the Warehouse type to "Auto"

B. Configure the Maximum Clusters setting to "Auto-Scale"

C. Set the Minimum Clusters and Maximum Clusters settings to the same value

D. Set the Minimum Clusters and Maximum Clusters settings to the different values

A. USE WAREHOUSE <<warehouse name>>;

B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

C. COPY WAREHOUSE FROM <<config file>>;

D. SET WAREHOUSE = <<warehouse name>>;

A. Authentication and access control

B. Local disk caching

C. Query processing

D. Database storage

E. Metadata management