Which of the following grants are required for the role kafka_load_role_1 running the Snowflake Connector for Kafka, with the intent of loading data to Snowflake? (Choose three.)(Assume this role already exists and has usage access to the schema kafka_schema in database kafka_db, the target for data loading.)
Answer(s): A,C,D
A pipe is necessary for Snowpipe, which continuously ingests Kafka data into Snowflake. Without this permission, the Kafka connector cannot create the ingestion pipeline.A stage is needed as an intermediate storage location for incoming Kafka data before it is loaded into tables.The connector requires this permission to manage the staging process.Since the Kafka Connector loads data into Snowflake tables, the role needs permission to create tables in kafka_schema.
A Data Engineer creates a pipe called mypipe.What command needs to be run to verify that the pipe is configured correctly and is running?
Answer(s): B
To check if a Snowpipe is correctly configured and running, the SYSTEM$PIPE_STATUS function is used. This function returns details about the current status of the pipe, including whether it is running, paused, or encountering errors.
Which attribute is used by Snowpipe to ensure the same file is not loaded twice from a path in a stage?
Answer(s): D
Snowpipe tracks previously loaded files using their filenames to prevent duplicate ingestion. When a file is processed, its filename and associated metadata are recorded in Snowflake's metadata. If the same file appears again, Snowpipe ignores it unless explicitly reloaded.Snowflake maintains metadata on loaded files for 14 days to ensure idempotent behavior, preventing accidental duplicate loads.
A company called IOT Corporation has subsidiary companies in Germany and Japan.The German subsidiary has a Snowflake account called IOTGER in AWS region EU (Frankfurt) (Region ID: eu-central-1).The Japanese subsidiary has a Snowflake account called IOTJPN in Azure region Japan East (Tokyo)(Region ID: japaneast).The subsidiaries are totally independent of one another, and their Snowflake accounts belong to different Snowflake organizations.A Data Engineer needs to share data in a database called IOT_PROD from the German account to the Japanese account.What steps need to be taken by the German subsidiary so that the Japanese subsidiary can use the shared data?
Snowflake does not support direct cross-cloud data sharing between different cloud providers (AWS and Azure) or across different organizations. The only way to share data between IOTGER (AWS Frankfurt) and IOTJPN (Azure Tokyo) is through database replication.Steps required for cross-cloud sharing:1. Create an additional Snowflake account (IOTGER2) in Japan East (Azure).- This account will act as an intermediary between IOTGER (AWS Frankfurt) and IOTJPN (Azure Tokyo).2. Replicate the database (IOT_PROD) from IOTGER (AWS) to IOTGER2 (Azure).- Snowflake's Database Replication feature allows database copies to be synchronized across Snowflake accounts in different cloud providers.3. Create a share (S1) in IOTGER2 and add the replicated objects.- Once the data is available in Azure Japan East, the standard data sharing mechanism can be used.4. Grant access to IOTJPN (Azure Tokyo) from IOTGER2.- Since both IOTGER2 and IOTJPN exist on the same Azure cloud, data sharing is now possible.
A Data Engineer made modifications to staged files and re-staged them. A pipe is running but the changed data is not appearing in the table.What step should the Engineer take in order to see the changed data without duplicating data?
Snowpipe tracks filenames to prevent duplicate loads. If a file with the same name is re-staged, Snowpipe ignores it. To load the modified data, the engineer must create new files with unique names.
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.