- All Exams Instant Download
Which command below will load data from result_scan to a table?
Which command below will load data from result_scan to a table?A . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id()));B . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id());C . INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());View AnswerAnswer: B Explanation: This command uses the CREATE OR...
How will you resume it?
You have created a TASK in snowflake. How will you resume it?A . No need to resume, the creation operation automatically enables the taskB . ALTER TASK mytask1 RESUME;C . ALTER TASK mytask1 START;View AnswerAnswer: B Explanation: It is important to remember that a Task that has just been created...
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?A . Create multiple clustering keys for a table.B . Create multiple materialized views with different cluster keys.C . Create super projections that will automatically create clustering.D . Create a clustering key that...
Who can provide permission to EXECUTE TASK?
Who can provide permission to EXECUTE TASK?A . ACCOUNTADMINB . THE TASK OWNERC . SYSADMINView AnswerAnswer: A Explanation: If the role does not have the EXECUTE TASK privilege, assign the privilege as an account administrator (user with the ACCOUNTADMIN role), e.g.: use role accountadmin; grant execute task on account to...
Materialized views based on external tables can improve query performance
Materialized views based on external tables can improve query performanceA . TRUEB . FALSEView AnswerAnswer: B Explanation: Currently, Snowflake does not support materialized views on external tables. Materialized views can only be created on regular tables within Snowflake.
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...
To meet these requirements, which design elements must be implemented?
An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows: 1) Use Tri-Secret Secure in Snowflake 2) Share some information stored in a view with another Snowflake customer 3) Hide portions of sensitive information from some columns...
Which alter command below may affect the availability of column with respect to time travel?
Which alter command below may affect the availability of column with respect to time travel? A. ALTER TABLE...DROP COLUMN B. ALTER TABLE...SET DATA TYPE C. ALTER TABLE...SET DEFAULTView AnswerAnswer: A Explanation: For the alter command that may affect the availability of a column with respect to time travel: A. ALTER...
Snowflake has row level security
Snowflake has row level securityA . TRUEB . 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....
Which design will meet these requirements?
A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers...
