- All Exams Instant Download
Snowflake has row level security
Snowflake has row level securityA . TRUE B. FALSEView AnswerAnswer: A Explanation: The below is an old Explanation: -------------- Currently row level security is not available in Snowflake. There is a work around to achieve this using views and permissions. New Explanation: ------- Snowflake has introduced row level security now....
How do you refresh a materialized view?
How do you refresh a materialized view?A . ALTER VIEW <MV_NAME> REFRESH B. REFRESH MATERIALIZED VIEW <MV_NAME> C. Materialized views are automatically refreshed by snowflake and does not require manual interventionView AnswerAnswer: C Explanation: Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view...
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
Which command do you run to remove files from stage?
Which command do you run to remove files from stage?A . REMOVE B. DELETE C. PURGE D. CLEANView AnswerAnswer: A Explanation: REMOVE Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in one of the following Snowflake internal stages: Named internal...
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...
By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tables
By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tablesA . TRUE B. FALSEView AnswerAnswer: B Explanation: SHOW TABLES Lists the tables for which you have access privileges, including dropped tables that are...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
If you run the below commands in your worksheet, what will happen?
If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...
To increase performance, materialized views can be created on external table without any additional cost
To increase performance, materialized views can be created on external table without any additional costA . TRUE B. FALSEView AnswerAnswer: B Explanation: Materialized views are designed to improve query performance for workloads composed of common, repeated query patterns. However, materializing intermediate results incurs additional costs. As such, before creating any...
