Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Configure Snowflake Connectivity in Airflow

What is the first step after modifying the requirements.txt file?

• Create a new Airflow environment

• Delete the file from the local system

• Upload the file to S3 and restart the Airflow environment

• Install additional libraries

What is the purpose of the Snowflake_CON name in the Airflow setup?

• To identify the Snowflake server

• To configure the Airflow UI

• To store the Snowflake password

• To be used as a reference in the DAG Python script

Which parameter is NOT required when setting up a Snowflake connection?

• Account

• Warehouse

• Region

• Schema

What should you do after adding a new Snowflake connection in Airflow?

• Restart the Airflow server

• Change the Airflow UI theme

• Delete the existing connections

• Save the connection and proceed with DAG deployment

Which of the following is a compulsory parameter for the Snowflake connection?

• Schema

• Region

• Port

• Protocol

What is the role of the IAM role in the Airflow and Glue integration?

• To store data in Snowflake

• To manage Airflow UI settings

• To trigger Glue jobs from Airflow

• To provide network access

What is the sequence of tasks when using Airflow with Snowflake and Glue?

• Only trigger Glue job

• Run both tasks simultaneously

• Ingest data into Snowflake, then trigger Glue job

• Trigger Glue job, then ingest data into Snowflake