ADA-C01 試験問題を無料オンラインアクセス

A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?

• A.grant imported privileges on account to role dp_team;
  grant create database on account to role dp_team;
• B.grant import share on account to role dp_team;
  grant create database on account to role dp_team;
• C.grant marketplace in account to role dp_team;
  grant create database from share to role dp_team;
• D.grant usage on snowflake_marketplace to role dp_team;
  grant create database on account to role dp_team;

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 usage on data exchange EXCHANGE_NAME to ROLE_NAME;
• B.Grant ownership on data exchange EXCHANGE_NAME to ROLE NAME;
• C.Grant imported privileges on data exchange EXCHANGE_NAME to ROLE_NAME;
• D.Grant modify on data exchange EXCHANGE_NAME to ROLE_NAME;

An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO
FROM CUSTOMERS
WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7); What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

• A.Wrap the query in a User-Defined Function (UDF) to match syntax execution.
• B.Assign everyone on the sales team to the same virtual warehouse.
• C.Leverage the CURRENT_DATE function for date calculations.
• D.Assign everyone on the sales team to the same security role.

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

• A.The role above the dropped role in the RBAC hierarchy
• B.The SYSADMIN role
• C.The role executing the command
• D.The SECURITYADMIN role

Which Snowflake objects can be managed using SCIM integration? (Select TWO).

• A.Users
• B.Roles
• C.Warehouses
• D.Shares
• E.Stages