- All Exams Instant Download
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...
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the columnB . Snowflake automatically assigns a default value and let the change happenC . Snowflake drops the row and...
How can this data be shared?
A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?A . The healthcare company will need to change the institute’s Snowflake edition in the accounts...
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...
