最新的Snowflake SnowPro Core Certification - SnowPro-Core免費考試真題

A. Object-level access control

B. Up to 90 days of data recovery through Time Travel

C. Column-level security to apply data masking policies to tables and views

D. Customer-managed encryption keys through Tri-Secret Secure

E. Automatic encryption of all data

A. The virtual warehouse that is defined at the session level will be used to read all data.

B. No virtual warehouse will be used, data will be read from the local disk cache.

C. The default virtual warehouse will be used to read all data.

D. No virtual warehouse will be used, data will be read from the result cache.

A. SHOW STORAGE BY TABLE;

B. Information Schema -> TABLE_HISTORY

C. Information Schema -> TABLE_FUNCTION

D. Information Schema -> TABLE_STORAGE_METRICS

E. SHOW TABLES;

A. Create a task that runs a copy into operation from an external stage every 5 minutes

B. Create a task that puts the files in an internal stage and automate the data loading wizard

C. Create a task that runs a GET operation to intermittently check for new files

D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

A. The number of data files that are processed in parallel is determined by the virtual warehouse.

B. Create small data files and stage them in cloud storage frequently.

C. Create large data files to maximize the processing overhead for each file.

D. The number of load operations That run in parallel can exceed the number of data files to be loaded.

A. To return errors from the last executed COPY command into table t1 in the current session

B. To validate a file for errors before it gets executed using a COPY command

C. To validate task SQL statements against table t1 in the last 14 days

D. To validate external table files in table t1 across all sessions

A. It improves the performance of range searches.

B. It defines different clustering keys on the same source table.

C. It improves the performance of all queries running against a given table.

D. It improves the performance of equality searches.

A. When loading data into a table

B. When executing a show command

C. When executing a list command

D. When creating a table

E. When unloading data from a table

A. Network policies

B. OAuth

C. Multi-Factor Authentication (MFA)

D. Single Sign-On (SSO)

A. SQL

B. Java

C. Scala

D. Python

E. Javascript