Provisioning SQL Databases Quiz Questions and Answers

 _________ is free database software running free SQL Server technology.

Answer :
  • SQL Server Express

Which of the following versions of SQL Server introduces LocalDB?

Answer :
  • 2012

What is the current limitation of the size of SQL Azure DB?

Answer :
  • 50GB

What model allows you to restore a database to a specific point in time?

Answer :
  • Full Recovery Model

When the SQL server is installed, which of the following databases are created by default?

Answer :
  • Root

Can we temporarily disable a login name?

Answer :
  • Yes

The parser checks that you have followed the rules of the Transact-SQL language and outputs a syntax tree, which is a simplified representation of the queries to be executed.Identify the above Statements are True or False ?The Algebrizer converts the syntax tree into a relational algebra tree, where operations are represented by logic objects, rather than words. Mark True or False.

Answer :
  • True

When a task needs to wait for a resource, it is placed on a list until the resource is available. The task is then signaled so that it can continue, though it still needs to wait for another share of CPU time. This allocation of CPUs to resources is a function of the SQLOS. Are the above statements True or False?

Answer :
  • True

Tables you create in tempdb will still be present after you restart the SQL Server instance. Is the statement True or False?

Answer :
  • False

You plan to deploy 20 Microsoft Azure SQL Database instances to an elastic pool in Azure to support a batch processing application. Two of the databases in the pool reach their peak workload threshold at the same time every day. This leads to inconsistent performance for batch completion. You need to ensure that all batches perform consistently. What should you do?

Answer :
  • Increase the total number of elastic Database Transaction Units (eDTUs) in the pool