- All Exams Instant Download
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?A . The account_level policy will override the user_level policy.B . The user_level policy will override the account_level policy.C . The user_level network policies will not be supported.D . A network policy error will...
Which action would provide optimal performance for the second SQL query?
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set. Which action would provide optimal performance for the second SQL query?A . Assign additional...
According to best practices, how should these requirements be met?
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert...
What set of object references needs to be re-pointed before granting access for usage?
A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references. What set of object references needs to be re-pointed before granting access for usage?A . Sequences, views, and secure viewsB . Sequences,...
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));View AnswerAnswer: C Explanation: According to the Using Persisted Query Results documentation, the RESULT_SCAN function allows you to query the result set of a previous command as if it were a table. The LAST_QUERY_ID function...
According to best practices, how should these requirements be met?
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert...
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements?
An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table. How...
In which scenario will use of an external table simplify a data pipeline?
In which scenario will use of an external table simplify a data pipeline?A . When accessing a Snowflake table from a relational databaseB . When accessing a Snowflake table from an external database within the same regionC . When continuously writing data from a Snowflake table to external storageD ....
What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).
What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).A . The account requires at least one ORGADMIN role within one of the organization's accounts.B . The account name is immutable and cannot be changed.C . The account name must be specified when the...
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));View AnswerAnswer: C Explanation: According to the Using Persisted Query Results documentation, the RESULT_SCAN function allows you to query the result set of a previous command as if it were a table. The LAST_QUERY_ID function...
