- All Exams Instant Download
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?A . CONTINUE B. SKIP_FILE C. ABORT_STATEMENT D. FAILView AnswerAnswer: A,B,C Explanation: Copy Options (copyOptions) You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):...
What may be the issue?
One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue? A . This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in...
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?
When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?A . String truncation B. Reordering columns C. Casts D. Join E. Omission of columnsView AnswerAnswer: A,B,C,D,E Explanation: Unloading operation is more flexible than the load operation. All the...
You can define a clustering key directly on top of VARIANT columns
You can define a clustering key directly on top of VARIANT columnsA . TRUE B. FALSEView AnswerAnswer: B Explanation: You cannot use a VARIANT column in clustering key. However, you can specify an expression to extract value in clustering key.
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...
