Microsoft Azure Architect Design (AZ-301) Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Design (AZ-301) Exam with interactive quizzes featuring flashcards and multiple-choice questions, each packed with hints and explanations to ace your certification test!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

Which option should be used to configure firewall rules for databases in Azure?

Azure PowerShell
The REST API
Transact-SQL
Azure Portal

The correct answer is: Transact-SQL

The selection of Transact-SQL for configuring firewall rules for databases in Azure is appropriate due to the functionality it provides in managing Azure SQL Database. Transact-SQL (T-SQL) is the primary programming language used to interact with SQL Server and Azure SQL Database, allowing you to execute a range of commands directly on the database, including the creation and management of firewall rules. Configuring firewall rules using T-SQL is particularly beneficial because it allows for direct execution within the context of the database, providing precise control over the rules applied to that specific instance. This can include defining which IP addresses or ranges are allowed to connect to the database, making it a straightforward and efficient method for securing access. Other methods like Azure PowerShell, the REST API, and the Azure Portal can also be used to configure firewall rules, each with its specific interfaces and purposes. However, T-SQL specifically allows the user to perform database-specific commands seamlessly within SQL Server Management Studio or through other database query tools. This level of integration and specificity makes it an advantageous choice for configuring firewall rules in Azure, particularly for users who are already familiar with T-SQL and working within the database environment.