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 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 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....
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
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...
How many years of experience should a new investigative hire have?A . As a rule of thumb, new hires should have at least two years of experience conducting investigations B. As a rule of thumb, new hires should have at least three years of experience conducting investigations C. As a...
What is the best way to recruit a good candidate for a job?A . Internal recommendations B. Open competitions C. Direct Appointments D. Closed competitionsView AnswerAnswer: A
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...
What three factors should determine selection of a CCTV camera?A . Sensitivity Degradation Features B. Sensitivity Resolution Features C. Sensitivity Degradation Timing D. Resolution Degradation TimingView AnswerAnswer: B
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...
