Snowflake ADA-C02 real dump : SnowPro Advanced Administrator ADA-C02

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)

• A. Increase the multi-cluster maximum to 20 or more clusters.
• B. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
• C. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
• D. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
• E. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

Which tasks can be performed by the ORGADMIN role? (Choose three.)

• A. Create secure views on application tables within the organization.
• B. Perform zero-copy cloning on account data.
• C. View a list of all regions enabled for the organization.
• D. View usage information for all accounts in the organization.
• E. Create one or more accounts in the organization.
• F. Create a reader account to share data with another organization.

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 IoT 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? (Choose two.)

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

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose two.)

• A. Unpublishing the data listing
• B. Dropping a column from a table
• C. Deleting data from a table
• D. Renaming a table
• E. Adding region availability to the listing

What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

• A. IdP account details
• B. IdP encryption key
• C. URL endpoint for SAML requests
• D. Authentication certificate
• E. SAML response format