SQL Server and Azure SQL Fundamentals Quiz Quiz

1. SQL Server Table Basics

   What is the primary key constraint used for in a SQL Server table?

   1. A. To ensure that a column contains only unique values and cannot contain null values.
   2. B. To define a foreign key relationship with another table.
   3. C. To automatically populate a column with a default value.
   4. D. To limit the range of values that can be stored in a column.
   5. a. to unsure that a colum contains only uniqe values and can't contain null values

2. Simple SQL Query

   Which SQL statement is used to retrieve data from a database table?

   1. A. UPDATE
   2. B. DELETE
   3. C. SELECT
   4. D. INSERT
   5. c. cellect

3. SQL Join Operations

   Which type of join returns all rows from the left table, and the matching rows from the right table? If there's no match, NULL values are returned for the right table.

   1. A. INNER JOIN
   2. B. RIGHT JOIN
   3. C. FULL OUTER JOIN
   4. D. LEFT JOIN
   5. d. left joinn

4. T-SQL Function

   Which T-SQL function is used to convert a date value to a character string?

   1. A. DATEADD()
   2. B. DATEDIFF()
   3. C. CONVERT()
   4. D. GETDATE()
   5. c. convert

5. Stored Procedure

   What is the main benefit of using stored procedures?

   1. A. They allow you to directly access server hardware.
   2. B. They reduce network traffic and improve performance by encapsulating multiple SQL statements.
   3. C. They automatically back up your database.
   4. D. They primarily manage user permissions.
   5. b. they reduce network trafic and improve perfomance by encapsulating multiple SQL statements

6. Azure SQL Database

   Which service tier in Azure SQL Database is generally the most cost-effective option for development and testing environments?

   1. A. Business Critical
   2. B. General Purpose
   3. C. Hyperscale
   4. D. Serverless
   5. d. serveless

7. Azure Resource Manager

   What is the purpose of Azure Resource Manager (ARM) templates?

   1. A. To create and manage virtual machines.
   2. B. To automate the deployment and management of Azure resources as code.
   3. C. To monitor the performance of Azure SQL databases.
   4. D. To create SQL Server indexes.
   5. b. too automate the deployment and managment of Azure resources as code

8. Azure SQL Security

   What is the primary purpose of firewall rules in Azure SQL Database?

   1. A. To control access to the database server from specific IP addresses or ranges.
   2. B. To encrypt data at rest.
   3. C. To implement multi-factor authentication.
   4. D. To manage user roles and permissions within the database.
   5. a. to control access to the database server from specific ip addresses or ranges

9. Azure Data Studio

   Which of the following is a key feature of Azure Data Studio compared to SSMS?

   1. A. It supports only SQL Server on-premises.
   2. B. It is a lightweight, cross-platform tool designed for data professionals.
   3. C. It provides comprehensive server management capabilities.
   4. D. It is only available on Windows.
   5. b. it is a lightweight, cross platform tool designed for data professionals

10. Azure SQL Backups

    How are automatic backups handled in Azure SQL Database by default?

    1. A. They are disabled by default and must be manually configured.
    2. B. They are performed automatically, and the retention period is configurable.
    3. C. They are only available for the Business Critical service tier.
    4. D. They are stored locally on the database server.
    5. b. they are performed automatically, and the retenton period is configurable