Snowflake Certified SnowPro Associate - Platform Certification - SOL-C01 Exam Practice Test

A. Classifying text into predefined categories B. Extracting data from documents C. Generating text completions based on a given prompt D. Translating text to different languages

A. To automatically create column names from the header row. B. To ignore empty rows in the data file. C. To skip a specified number of header rows. D. To include the header row as data.

A. Managed Stages B. External Stages C. Internal Stages D. Permanent Stages E. Temporary Stages

A. An error is returned if the schema does not exist B. The schema "marketing_schema" is dropped only if it exists C. The schema "marketing_schema" is created if it does not exist D. The schema "marketing_schema" is dropped even if it contains tables

A. Manual data entry B. Drag-and-drop interface C. Only supports cloud storage D. Command-line input

A. Compute Layer B. Data Storage Layer C. Query Processing Layer D. Cloud Services Layer

A. ACCOUNTADMIN B. SECURITYADMIN C. SYSADMIN D. DATABASEADMIN

A. Network perimeter defense B. Automated data masking C. End-to-end encryption for all data, in transit and at rest D. Role-based access control (RBAC)

A. By writing HTML code B. By manually editing data files C. By configuring network settings D. By using placeholders in SQL queries

A. 7 days B. 1 day C. 90 days D. 45 days

A. To define user tasks B. To control which data types users can query C. To optimize query execution plans D. To manage and enforce permissions on objects

A. It will try to detect data types. B. It allows a user to optimize data loading into a table. C. It creates permanent file formats that can be used to load data in the future. D. It allows a user to insert the records of a supported file into a table. E. It lets a user merge file rows into the table records.

A. Providing a virtual table based on the result set of a query B. Managing user authentication C. Executing network configurations D. Storing raw data

A. DESCRIBE FILE FORMAT B. LIST FILE FORMAT C. ALTER FILE FORMAT D. SHOW FILE FORMATS

A. Loading, unloading, and managing data B. Managing the hardware on which Snowflake is installed C. Managing table metadata D. Software installation and updates