Azure Data Factory for Beginners - Build Data Ingestion - Create Metadata Tables and Stored Procedures

In this tutorial, the instructor guides students through creating a metadata database by setting up metadata tables, views, and stored procedures using SQL scripts. The process includes downloading necessary files, connecting to Azure Data Studio, and executing scripts to create database structures. The tutorial also covers inserting initial data and populating email addresses, with detailed instructions on modifying script values. The session concludes with a review of the completed tasks.

What is the first step in setting up the metadata tables?

• Inserting initial data

• Creating stored procedures

• Extracting the SQL scripts from the zip file

• Running the SQL scripts

Which tool is used to connect to the database for creating metadata tables?

• SQL Server Management Studio

• MySQL Workbench

• Azure Data Studio

• Oracle SQL Developer

After creating the metadata tables, what is the next step?

• Inserting initial data

• Creating stored procedures

• Customizing email scripts

• Creating the source to target view

What is the purpose of the stored procedures in this context?

• To extract data from the database

• To customize email scripts

• To act as the ingestion engine

• To create metadata tables

What is the final step in setting up the metadata database?

• Running SQL scripts

• Inserting initial data

• Creating metadata tables

• Creating stored procedures

What needs to be customized in the email scripts?

• The database connection string

• The SQL query

• The email addresses

• The metadata table names

How can you confirm that the email addresses have been successfully populated?

• By reviewing the SQL scripts

• By logging into Azure Data Studio

• By running a select query on email recipients

• By checking the metadata tables