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 object should be added to the share to allow Company B access to the files?
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis. Company A's Administrator created a share. What object should be added to the share to allow Company B access to the files?A...
When a role is dropped, which role inherits ownership of objects owned by the dropped role?
When a role is dropped, which role inherits ownership of objects owned by the dropped role?A . The SYSADMIN roleB . The role above the dropped role in the RBAC hierarchyC . The role executing the commandD . The SECURITYADMIN roleView AnswerAnswer: B Explanation: According to the Snowflake documentation1, when...
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?A . CURRENT_ROLEB . CURRENT ACCOUNTC . CURRENT_USERD . CURRENT_CLIENTView AnswerAnswer: C Explanation: According to the Working with Secure Views documentation, secure views are designed...
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...
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).A . Dropping a column from a tableB . Deleting data from a tableC . Unpublishing the data listingD . Renaming a tableE . Adding region availability to the listingView AnswerAnswer: AD...
Which queries will allow the user to view the historical data that was in the table before this query was executed?
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day. Which queries will allow the user to view...
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...
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?A . Reset a Snowflake user's passwordB . Manage system grantsC . Create new usersD . Create new rolesView AnswerAnswer: B Explanation: According to the Snowflake documentation1, the SECURITYADMIN role is responsible for managing all grants...
Which tasks can be performed by the ORGADMIN role? (Select THREE).
Which tasks can be performed by the ORGADMIN role? (Select THREE).A . Create one or more accounts in the organization.B . View a list of all regions enabled for the organization.C . Create secure views on application tables within the organization.D . View usage information for all accounts in the...