A Data Engineer has been asked by the development team to create a snapshot of production data from the ABC database into the developer account. None of the data is Personal Identifiable Information (PII) or sensitive. Both accounts are in the same region and use the same cloud provider.The Engineer performs these steps:In the production account:use role accountadmin;create database ABC_CLONE clone ABC;create share ABC_SHARE;grant usage on database ABC_CLONE to share ABC_SHARE;alter share ABC_share add accounts = dev_account;In the developer account:use role accountadmin;create database ABC_DEV FROM share prod_account.ABC_SHARE; grant imported privileges on database ABC_DEV to role developers;What is the reason the development team cannot see the data in the tables in the developer account?
Answer(s): A
In Snowflake, granting database usage alone is not enough for shared data access. The schema and tables within the shared database also need explicit privileges. The engineer should have added:GRANT USAGE ON SCHEMA ABC_CLONE.SCHEMA_NAME TO SHARE ABC_SHARE; GRANT SELECT ON ALL TABLES IN SCHEMA ABC_CLONE.SCHEMA_NAME TO SHARE ABC_SHARE; Without these grants, the developer account cannot see the tables in the shared database.
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?
Answer(s): D
Snowflake Marketplace data is only accessible within the same region as the provider's account. The best approach is to create a new Snowflake account in the provider's region and access the Marketplace data from there.Cross-region data sharing is not supported, so replicating the data to the company's account ensures availability for transformation and blending.
A Data Engineer is creating a pipe by executing the following statement:create or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage;The Data Engineer adds a file data.csv.gz to the stage and it successfully loads into the table mytable.What will cause the file data.csv.gz to be loaded a second time? (Choose two.)
Answer(s): C,D
Dropping and recreating mytable removes its metadata, including tracking of previously loaded files.When the new table is created, Snowpipe does not recognize that data.csv.gz was already processed, so it gets reloaded.Replacing the pipe recreates it, resetting its metadata. Running ALTER PIPE mypipe REFRESH forces Snowpipe to scan all staged files again, causing data.csv.gz to be reloaded.
How can a directory table be used when working with unstructured data? (Choose two.)
Answer(s): A,E
A directory table stores metadata (e.g., filenames, sizes, and URLs) of unstructured data in a stage, allowing file URLs to be shared externally.A directory table can be joined with structured tables to combine file metadata with other data, enabling better organization and retrieval.
A Data Engineer needs to obtain details about data loading history for tables in a specific database and schema. The tables were loaded using Snowpipe in the last 24 hours.How should the Engineer accomplish these tasks?
Answer(s): B
The LOAD_HISTORY view provides Snowpipe load details, and querying it requires USAGE on the database and schema plus any privilege on the target table.
Post your Comments and Discuss Snowflake SnowPro Advanced Data Engineer exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the SnowPro Advanced Data Engineer content, but please register or login to continue.