300+ Sql Azure FAQs and Answers [Experienced / Freshers]

Sql Azure Interview Questions with Answers

Question: 1. What Is Sql Azure?

Answer:

Microsoft SQL Azure is a cloud-primarily based relational database provider that is constructed on SQL Server technologies and runs in Microsoft records facilities on hardware that is owned, hosted, and maintained by using Microsoft.

Question: 2. What Is Sql Azure Federations?

Answer:

SQL Azure federation affords gear that permit developers to scale out (by way of sharding) in SQL Azure.

Here are some of the blessings of a sharded database: 

Taking gain of greater assets within the cloud on call for.
Allowing customers to have their very own database, to share databases or to get right of entry to many databases.
Reducing the publicity of a single factor of failure.
Benefiting from the decrease prices of the use of cloud assets on an as-wanted foundation and releasing them while achieved.
Reducing I/O bottlenecks and SQL Azure throttling.
MSBI Interview Questions
Question three. What Is Sharding?

Answer:

It is a method for partitioning massive statistics units, which improves performance and scalability. 
It also permits allotted querying of records throughout more than one tenants.
Question 4. What Is Federation Root Database?

Answer:

The federation root database is a SQL Azure database that carries metadata about the federations. It’s the primary factor you want to create while putting in place your very own federation

example:

CREATE DATABASE [fedRoot] COLLATE French_CI_AS (MAXSIZE = 100 GB, EDITION = ‘enterprise’)

SQL Database Tutorial
Question five. What Is Federation?

Answer:

The federation is where you outline the records kind (e.G., Customer ID, Product ID) you’ll shard on. 

As with developing the foundation database, you may create a federation through the SQL Azure database control portal, 

with SQLAzureMW or by using this T-SQL script at the same time as linked on your root database:

CREATE FEDERATION ( RANGE)

In this example, 

is the call of the federation (no longer the name of the physical database, that is a System-GUID). 

is the name for the distribution key, 

and is the distribution records kind that facts can be sharded on. 

The valid distribution information sorts are int, bigint, uniqueidentifier and varbinary (up to 900).

SQL Database Interview Questions
Question 6. What Is Federation Member?

Answer:

The federation member is the shard (i.E., the database containing a specific range of facts).

T-SQL script:

USE FEDERATION ROOT WITH RESET 

GO 

ALTER FEDERATION SPLIT AT (=