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...

February 2, 2024 No Comments READ MORE +

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?A . Any role with GRANT USAGE on SECURITY INTEGRATIONB . ACCOUNTADMIN and SYSADMINC . ACCOUNTADMIN and SECURITYADMIND . ACCOUNTADMIN onlyView AnswerAnswer: C Explanation: In Snowflake, setting up OAuth 2.0 integration typically requires...

February 2, 2024 No Comments READ MORE +

How can the Administrator protect the sensitive information, while maintaining the usability of the data?

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER. CREATE TABLE customer_data ( customer_first_name string, customer_last_name string, customer_address string, customer_email string, ... some other...

February 1, 2024 No Comments READ MORE +

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...

February 1, 2024 No Comments READ MORE +

Which role(s) can alter or drop table XYZ?

The following SQL command was executed: Use role SECURITYADMIN; Grant ownership On future tables In schema PROD. WORKING To role PROD_WORKING_OWNER; Grant role PROD_WORKING_OWNER to role SYSADMIN; Use role ACCOUNTADMIN; Create table PROD.WORKING.XYZ (value number); Which role(s) can alter or drop table XYZ?A . Because ACCOUNTADMIN created the table, only...

February 1, 2024 No Comments READ MORE +

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...

February 1, 2024 No Comments READ MORE +

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO). A. SYSADMIN B. SECURITYADMIN C. ACCOUNTADMIN D. IMPORT SHARE and CREATE DATABASE E. IMPORT PRIVILEGES and SHARED DATABASEView AnswerAnswer: CD Explanation: According to the Accessing a Data Exchange documentation,...

January 31, 2024 No Comments READ MORE +

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...

January 31, 2024 No Comments READ MORE +

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...

January 30, 2024 No Comments READ MORE +

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...

January 30, 2024 No Comments READ MORE +