Enjoy 15% Discount With Coupon 15off

Monthly Archives - December 2022

20Dec

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):...

By ARA-C010 Comments
Read more...
20Dec

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...

By ARA-C010 Comments
Read more...
19Dec

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...

By ARA-C010 Comments
Read more...
19Dec

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....

By ARA-C010 Comments
Read more...
19Dec

What are the three types of CPTED solutions?

What are the three types of CPTED solutions?A . Mechanical measures Electronic Lighting and Direction of Flow B. Legal Guidelines Human and organisational measures Natural measures C. Mechanical measures Human and organisational measures Lighting and Direction D. Mechanical measures Human and organisational measures Natural measuresView AnswerAnswer: D

By ASIS-APP0 Comments
Read more...
19Dec

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...

By ARA-C010 Comments
Read more...