A. Micro-partitions
B. Virtual warehouses
C. Metadata
D. Dashboards
A. Warehouse size
B. Auto-suspend time
C. Cloud provider region
D. Auto-resume
A. Only through stored procedures.
B. Using standard SQL WHERE clauses on the entire VARIANT column.
C. By converting the VARIANT column to a relational table first.
D. Using path notation to access specific elements within the VARIANT
A. It eliminates the need for data loading.
B. It simplifies data governance.
C. It allows independent scaling of resources.
D. It reduces network latency.
A. CONVERT_JSON()
B. PARSE_JSON()
C. TO_JSON()
D. EXTRACT_JSON()
A. It lets a user merge file rows into the table records.
B. It will try to detect data types.
C. It allows a user to insert the records of a supported file into a table.
D. It allows a user to optimize data loading into a table.
E. It creates permanent file formats that can be used to load data in the future.
A. Schema name
B. Role name
C. Database name
D. Table or view name
A. Categorizing customer support tickets based on topic
B. Translating a user manual into multiple languages
C. Extracting data from scanned invoices
D. Generating SQL code from natural language description
A. COLUMN_DELIMITER
B. FIELD_DELIMITER
C. DELIMITER
D. SEPARATOR
A. ACCOUNTADMIN
B. SYSADMIN
C. DATABASEADMIN
D. SECURITYADMIN
A. Compute Clusters
B. Virtual Warehouses
C. Virtual Machines
D. Data Nodes
A. To modify security settings for objects
B. To manage virtual warehouses
C. To create Snowsight worksheets
D. To view and filter database objects
A. Command-line input
B. Only supports cloud storage
C. Drag-and-drop interface
D. Manual data entry
A. SELECT * FROM employees LIMIT 10;
B. SELECT * FROM employees WHERE LIMIT 10;
C. SELECT LIMIT 10 * FROM employees;
D. LIMIT 10 SELECT * FROM employees;
A. Small
B. Xsmall
C. Medium
D. Tiny
