최신Snowflake Certified SnowPro Associate - Platform Certification - SOL-C01무료샘플문제

A. To create data backups.

B. To specify the format and structure of data files being loaded (e.g., CSV delimiter, JSON compression)

C. To manage virtual warehouse sizes.

D. To define security policies for data files

A. REVOKE

B. ASSIGN

C. GRANT

D. CREATE

A. Automated data masking

B. Role-based access control (RBAC)

C. End-to-end encryption for all data, in transit and at rest

D. Network perimeter defense

A. Share data through the Snowflake Marketplace.

B. Load semi-structured data.

C. Simplify unstructured data workflows.

D. Enhanced data security.

E. Extract and classify text.

A. 1

B. 90

C. 0

D. 7

A. LIST

B. COPY INTO

C. GET

D. PUT

A. DATABASEADMIN

B. SECURITYADMIN

C. ACCOUNTADMIN

D. SYSADMIN

A. To replicate databases across regions.

B. To create new virtual warehouses.

C. To load data from staged files into a table.

D. To manage user roles and permissions.

A. Use the LOAD_HISTORY view.

B. Use the QUERY_HISTORY view.

C. Use the SHOW WAREHOUSES command.

D. Use the DESCRIBE WAREHOUSE command.

A. The schema "marketing_schema" is created if it does not exist

B. The schema "marketing_schema" is dropped only if it exists

C. An error is returned if the schema does not exist

D. The schema "marketing_schema" is dropped even if it contains tables

A. INSERT INTO

B. IMPORT DATA

C. COPY INTO

D. LOAD DATA

A. It creates a full physical copy of data for archival.

B. It allows creating writable copies of databases or tables without duplicating stored data.

C. It prevents any modifications to the cloned data.

D. It enables real-time data synchronization between regions.

A. Clones can only be created from databases, not tables or schemas.

B. Clones initially consume minimal/no storage, with storage only being used for changes made to the clone or the original.

C. Clones are automatically synchronized with the original object.

D. Clones consume the same storage as the original object.

A. To define user tasks

B. To manage and enforce permissions on objects

C. To control which data types users can query

D. To optimize query execution plans

A. Stages

B. File formats

C. Schemas

D. Virtual warehouses