Snowflake SnowPro Advanced Administrator - ADA-C01 Free Exam Questions

A. Authentication certificate

B. IdP encryption key

C. IdP account details

D. URL endpoint for SAML requests

E. SAML response format

A. The SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role ACCOUNTADMIN.

B. The table object DB1. S1. T1 will be dropped.

C. The SELECT privileges for roles B and C will remain.

D. The OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN role.

A. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

B. Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

C. The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

D. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.

E. The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

A. No, because the optimizer might decide against it.

B. No, because joins are not supported by materialized views.

C. No, because the materialized view may not be up-to-date.

D. Yes, because materialized views are always faster.

A. grant marketplace in account to role dp_team;
grant create database from share to role dp_team;

B. grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;

C. grant import share on account to role dp_team;
grant create database on account to role dp_team;

D. grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;

A. The SECURITYADMIN role

B. The SYSADMIN role

C. The role executing the command

D. The role above the dropped role in the RBAC hierarchy

A. create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session ('MASKED_VIEW_ROLE') then ' ** else val end;
*,

B. create or replace masking policy maskString as (val string) returns string -> case when current_role() in ('MASKED_VIEW_ROLE') then ' ********* ' else val end;

C. create or replace masking policy maskString as (val string) returns string -> case when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '* else val end;
** '

D. create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in ('MASKED_VIEW_ROLE') then else val end;
' **

A. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

B. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

C. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

D. The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.