- All Exams Instant Download
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...
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...
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...
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...
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,...
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...
How can this requirement be met?
An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role. How can this requirement be met?A . Grant imported privileges on data exchange EXCHANGE_NAME to ROLE_NAME;B . Grant modify on data exchange EXCHANGE_NAME to ROLE_NAME;C . Grant...
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 are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?A . Database: Usage Schema: Usage Table: Select, Create StreamB . Database: Usage Schema: Usage Table: SelectC . Database: Usage, Create Stream Schema: Usage Table: SelectD . Database: Usage Schema:...
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...
