最新的Snowflake SnowPro Core Recertification - COF-R02免費考試真題

A. Authentication and access control

B. Time Travel data

C. Security

D. Query execution

E. Data loading

A. Parquet

B. CSV

C. JSON

D. XML

A. Compute Credits = 120 Credits Cloud Services = 10

B. Compute Credits = 50 Credits Cloud Services = 10

C. Compute Credits = 80 Credits Cloud Services = 5

D. Compute Credits = 200 Credits Cloud Services = 26

E. Compute Credits = 10 Credits Cloud Services = 9

A. Standard

B. Business Critical Edition

C. Premier

D. Enterprise

A. Object-level access control

B. Multi-factor Authentication (MFA)

C. SOC 2 type II certification

D. Column-level security

A. Database storage

B. Local disk caching

C. Query processing

D. Authentication and access control

E. Metadata management

A. A Materialized View can only reference up to two tables

B. A Materialized View cannot be joined with other tables

C. A Materialized View cannot support any aggregate functions

D. A Materialized View cannot be defined with a JOIN

A. USE WAREHOUSE <<warehouse name>>;

B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

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

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

A. Tables, secure views, and secure UDFs can be shared

B. Shares can be shared

C. Data consumers can clone a new table from a share

D. Access to a share cannot be revoked once granted

A. ORC

B. Parquet

C. CSV

D. JSON

E. XML

F. AVRO

A. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

B. Micro-partitions can be defined on a schema-by-schema basis

C. Micro-partitions are immutable objects that support the use of Time Travel.

D. Micro-partitions cannot overlap in their range of values

E. Rows are automatically stored in sorted order within micro-partitions

A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

C. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

A. Better query scheduling

B. Double the numbers of servers In the compute duster

C. Higher storage costs

D. More micro-partitions

A. False

B. True