ADA-C01 Question 479
Single answerInstall the clean room native appA Snowflake administrator needs to install the Snowflake Data Clean Rooms native app for a business unit that will act as the provider in a collaboration. The company has strict governance requirements: the app must be installed only after the organization approves the package source, and the business unit wants its own isolated application objects rather than sharing an installation used by another team. Which action should the administrator take to meet these requirements?
- A
Install the clean room native app from the approved listing in Snowflake Marketplace into the business unit's account, using an application role with privileges to create the application objects in that account.
- B
Clone the existing clean room database and shares from another internal account so the business unit gets an isolated copy without installing a separate native app.
- C
Create a new database from data shared by Snowflake and then enable clean room features by running SQL scripts from Snowsight.
- D
Ask the provider team in the other business unit to grant imported privileges on its existing clean room application so both teams can use the same installation with separate policies.
Show answer and explanation
Correct answer: A
Explanation
The key requirement is to install the Snowflake Data Clean Rooms solution as a Snowflake Native App from an approved source and to do so separately in the business unit's own account to maintain isolation. In practice, administrators install native apps from listings after internal governance review of the package/listing. This aligns with Snowflake best practices for Native Apps and Marketplace listings: review the listing/provider, approve the package source, then install the application into the consumer account where its application objects are created and governed. Trying to clone another account's installation, manually reproduce the app with SQL, or reuse another team's installed application does not satisfy the requirement for an approved source plus isolated deployment. Candidates should recognize that clean room installation is an app-installation workflow, not a database-cloning or script-deployment workflow.
- A. Correct.
Correct. Snowflake Data Clean Rooms is delivered as a Snowflake Native App and is installed from an approved listing, typically through Snowflake Marketplace or the appropriate listing workflow. If the company requires source approval, the administrator should ensure the listing/package is approved before installation. Installing the app in the target business unit's own account satisfies the isolation requirement because Native App objects are created within that account's application context rather than by reusing another team's installation.
- B. Incorrect.
Incorrect. Cloning an existing clean room setup from another account is not how the clean room native app is installed or isolated. Cross-account cloning of an installed native app is not the supported installation pattern for Snowflake Native Apps. This option reflects the misconception that a native app behaves like a standard database deployment that can simply be copied between accounts.
- C. Incorrect.
Incorrect. The clean room capability is not enabled by manually creating a database and running standalone SQL scripts. The supported approach is installation of the Snowflake Native App package. This distractor targets the common misunderstanding that all Snowflake solutions can be deployed as plain SQL objects without using the app framework.
- D. Incorrect.
Incorrect. Granting access to another team's existing application may allow shared use in some scenarios, but it does not meet the stated requirement for isolated application objects for the business unit. It also does not address the governance requirement to approve and install the app package source for that business unit's own deployment.