ADA-C01 Exam Questions

How should an Administrator configure a Snowflake account to use AWS PrivateLink?

A Snowflake Administrator is investigating why a query is not re-using the persisted result cache. The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAG...

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in A...

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

A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database. Which of the following will achieve this?

What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)

A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-...

A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL: Given that the combined total o...

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and...

Two different roles are running queries on a production database. The queries are similar in complexity and duration, and there is generally about 3 minutes of idle time between qu...

What are important aspects of managing user-managed (virtual-warehousE. tasks in Snowflake? (Choose two)

A table has a dynamic data masking policy defined on its cc_num column. The masking policy allows the role SECURE_ROLE to view the credit card number; all other roles will see just...

Which of the following objects within a database are replicated to the secondary database during database replication? (Choose three)

How can administrators monitor Snowflake users who do not have MFA enabled? (Choose two)

When managing users and groups in Snowflake using SCIM, what is a key benefit?

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

Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis. Company A...

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 ST...

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external ref...

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

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transie...

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

Which of the following are important table design considerations in Snowflake? (Choose two)

An Administrator at a healthcare company needs to share data with a university medical institute. There is no Protected Health Information (PHI) in the data. The healthcare company...

What is important for managing data providers and consumers in Snowflake?

How does the size of a virtual warehouse in Snowflake affect data loading and query processing?

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

In which scenario will use of an external table simplify a data pipeline?

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that us...

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005...

What are characteristics of Dynamic Data Masking? (Choose two.)

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. T...

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema: Table Name : VWH_M...

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Infor...

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_DAT...

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