DEA-C02 Question #73: Real Exam Question with Answer & Explanation

Question

A company would like to get data from a Snowflake Marketplace provider for data enrichment purposes. A Data Engineer needs to build a data pipeline that would blend existing data in the company's account with the provider's data, with some transformations. The provider's data is not available in the region where the company account resides. How can the Data Engineer make the data available to the company for processing?

Options

• ACreate a new reader account in the region where the provider's data is available and set up a
• BCreate a new reader account in the region where the provider's data is available and set up a
• CCreate a new account in the region where the provider's data is available. Get data from the
• DCreate a new account in the region where the provider's data is available. Get data from the

Explanation

Option D is correct because when Marketplace data is unavailable in your region, the solution requires a full Snowflake account (not a reader account) in the provider's region - this lets you subscribe to the Marketplace listing and then use Snowflake's database replication to sync that data to your home region account, where it can be blended and transformed alongside your existing data.

Options A and B are wrong because reader accounts are purpose-built to share data outward to external consumers who lack a Snowflake account; they cannot independently subscribe to Marketplace listings, run pipelines, or replicate data cross-region - they are read-only extensions of a parent account, not standalone accounts.

Option C is likely wrong because, while it correctly identifies the need for a new full account, it specifies an incorrect or incomplete mechanism for making the data available to the home account (likely omitting replication or using an unsupported transfer method).

Memory tip: Think of it as a relay race - a reader account is a dead end (it only passes data one way, outward), but a full account is a real "runner" that can receive Marketplace data and then pass the baton home via replication.

No community discussion yet for this question.