Azure Data Factory for Beginners - Build Data Ingestion - Creating the Metadata Database

This tutorial covers the creation and configuration of an Azure SQL database to manage metadata for executing pipelines. It includes signing in with a new user, setting up a database, configuring storage and network settings, and deploying the resource. The video also demonstrates how to manage firewall settings and pin resources to a dashboard.

What is the primary purpose of creating a metadata database in Azure SQL?

• To backup data

• To host web applications

• To manage executing pipelines in a batch

• To store user credentials

Which Azure service is used to manage user sign-ins and access?

• Azure Functions

• Azure Storage

• Azure SQL Database

• Azure Active Directory

What is the first step in creating a new Azure SQL database?

• Create a new server

• Sign in to Azure

• Choose a database name

• Select a resource group

Why is it important to select a location close to you when creating a database?

• To lower costs

• To enhance security

• To increase storage capacity

• To reduce latency

What is the purpose of configuring firewall rules for the database?

• To allow public access

• To restrict access to specific IPs

• To increase database speed

• To enable data encryption

Which setting is not required during the finalization of the database creation?

• Azure Defender for SQL

• Database tags

• Division assignment

• Product owner assignment

What action can be performed after the database deployment is complete?

• Pin the resource to a dashboard

• Delete the database

• Modify the server location

• Change the database name