SnowPro Advanced: Administrator Certification Exam
Last Update May 7, 2024
Total Questions : 72
To help you prepare for the ADA-C01 Snowflake exam, we are offering free ADA-C01 Snowflake exam questions. All you need to do is sign up, provide your details, and prepare with the free ADA-C01 practice questions. Once you have done that, you will have access to the entire pool of SnowPro Advanced: Administrator Certification Exam ADA-C01 test questions which will help you better prepare for the exam. Additionally, you can also find a range of SnowPro Advanced: Administrator Certification Exam resources online to help you better understand the topics covered on the exam, such as SnowPro Advanced: Administrator Certification Exam ADA-C01 video tutorials, blogs, study guides, and more. Additionally, you can also practice with realistic Snowflake ADA-C01 exam simulations and get feedback on your progress. Finally, you can also share your progress with friends and family and get encouragement and support from them.
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?
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).
A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are
grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning,
with large amounts of bytes processed by even simple queries.
Why is this occurring?