Online Access Free ADA-C01 Exam Questions

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

• A.Create new roles
• B.Create new users
• C.Manage system grants
• D.Reset a Snowflake user's password

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:
USE ROLE SECURITYADMIN;
CREATE ROLE ROLE_MANAGED_ACCESS;
GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS;
GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS;
USE ROLE ROLE_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS;
USE ROLE SECURITYADMIN;
GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

• A.ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;
• B.USE ROLE ROLE_MANAGED_ACCESS;
  DROP SCHEMA WORK. SCHEMA MANAGED_ACCESS;
  CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;
  Then recreate all needed objects.
• C.REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM ROLE_MANAGED_ACCESS; ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;
• D.USE ROLE ROLE MANAGED_ACCESS;
  DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;
  CREATE SCHEMA SCHEMA_MANAGED_ACCESS;
  Then recreate all needed objects.

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 to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).

• A.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.
• B.The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
• C.The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.
• D.Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.
• E.Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

What access control policy will be put into place when future grants are assigned to both database and schema objects?

• A.An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
• B.Database privileges will take precedence over schema privileges.
• C.An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.
• D.Schema privileges will take precedence over database privileges.

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.
The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.
Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

• A.The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.
• B.In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.
• C.Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.
• D.The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.