QUESTION 1

Availability sets can be used in order to ensure that the two VMs containing your Always On Availability Group members are not running on the same physical host.

True

False

1 points

QUESTION 2

Azure SQL Database hyprtscale has maximum of 4 TB of storage per database. True

False

1 points

QUESTION 3

Delete command in SQL is used to remove a table and all its data from the database?

True

False

1 points

QUESTION 4

In varying length character string VARCHAR(n), 'n' represents maximum number of characters

True

False

1 points

QUESTION 5

Integrity constraint is a condition specified on a database schema and restricts the data that can be stored in an instance of the database.

True

False

1 points

QUESTION 6

Microsoft SQL Server is an example of open source Relational Database Management System (RDBMS)

True

False

1 points

QUESTION 7

SELECT CustomerName, QuantityPurchased, PricePerItem FROM Purchases WHERE QuantityPurchased > 8 OR PricePerItem > 3

The above SQL Statement will produce the following output:

CustomerName

QuantityPurchased

PricePerltem

Carol White

10

1.25

True

False

1 points

QUESTION 8

Standard SSD is the most commonly used type of disk for SQL Server workloads. They are available in all regions and support a wide variety of VM types. Premium disks strike a good balance between price and performance.

True

False

1 points

QUESTION 9

The following SQL statements will create tables successfully

True

False

1 points

QUESTION 10

SELECT CustomerName, QuantityPurchased FROM Purchases WHERE QuantityPurchased > 3 AND QuantityPurchased < 7

The above SQL Statement will produce the following output:

CustomerName

QuantityPurchased

Andrew Li

4

James Carpenter

5

True

False

1 points