Interview Questions.

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 <FederationName>(<DistributionKeyName> <DistributionType> RANGE)

In this example, 

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

<DistributionKeyName> is the name for the distribution key, 

and <DistributionType> 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 <Federation Name> SPLIT AT (<Distribution KeyName>=<script point>)

Question 7. How To Scale Out A Federation By Sql Statement?

Answer :

ALTER FEDERATION <FederationName> SPLIT AT (<DistributionKeyName>=<value>)

MySQL Tutorial MySQL Interview Questions
Question 8. What Is Sql Azure Firewall?

Answer :

SQL Azure firewall is a protection mechanism that blocks requests based totally on its IP address.

Question nine. What Is The Difference Between Web Edition And Business Edition?

Answer :

SQL Azure Web edition database Max Size is 5 GB whereas the enterprise version supports Max Size up to 50 GB. 

The length of a web version database can be multiplied (/decreased) in the increments (/decrements) of one GB 

where as the scale of a business edition may be extended inside the increments of 10 GB.

DB2 Using SQL Interview Questions
Question 10. How Many Databases Can We Create In A Single Server?

Answer :

one hundred fifty databases (which include grasp database) can be created in a unmarried SQL Azure server.

DB2 Using SQL Tutorial
Question eleven. How Many Servers Can We Create In A Single Subscription?

Answer :

As of now, we can create six servers under a single subscription.

SQL DBA Interview Questions
Question 12. How Many Replicas Are Maintained For Each Sql Azure Db?

Answer :

three replicas are maintained for every logical DB. 

Single primary is observed as the replica in which actual study/write take region. Once this goes down, some other duplicate is upgraded mechanically as a unmarried primary.

MSBI Interview Questions
Question thirteen. What Is The Index Requirement In Sql Azure?

Answer :

All tables must have clustered index. You can't have a desk with out clustered index.

Microsoft Azure Tutorial
Question 14. What Is Cloud Computing?

Answer :

Cloud Computing:

Cloud computing is a model for permitting ubiquitous, convenient, on-demand community get admission to to a shared pool of configurable computing resources (e.G., networks, servers, garage, packages, and offerings) that may be swiftly provisioned and launched with minimum management effort or provider company interaction.

Question 15. How Is Sql Azure Different Than Sql Server?

Answer :

SQL Azure is a cloud based carrier and so it has own set of execs and cons when compared to SQL server. SQL Azure carrier benefits includes on demand provisioning, excessive availability, reduced management overhead and scalability. But SQL Azure abstracts some info from the subscriber which can be accurate or awful which depends at the context of the need.

MYSQL DBA Interview Questions
Question 16. How Many Replicas Are Maintained For Each Sql Azure Database?

Answer :

For each database, 3 replicas are maintained for every database that one provisions. One of them is number one duplicate. All read/write appear on number one reproduction and other replicas are kept in sync with primary reproduction. If for some cause, number one goes down, other reproduction is promoted to number one. All this happens below the hood.

Hyper SQL Database Tutorial
Question 17. How Can We Migrate From Sql Server To Sql Azure?

Answer :

For Data Migration, we will use BCP or SSIS. And for schema Migration we will use Generate Script Wizard. Also, we ought to use a Tool referred to as SQL Azure migration wizard to be had on codeplex.

Microsoft Azure Interview Questions
Question 18. Which Tools Are Available To Manage Sql Azure Databases And Servers?

Answer :

We can control SQL Azure database the usage of SQL server management server 2008 R2. Also, we are able to manipulate SQL Azure databases and servers through a Silverlight app integrated in Azure management portal.

SQL Database Interview Questions
Question 19. Tell Me Something About Security And Sql Azure?

Answer :

SQL Azure provider allows blockading a request primarily based on its IP deal with via SQL Azure firewall. It makes use of SQL server Authentication mechanism to authenticate connections. Also connections to SQL Azure are SSL-encrypted through default.

Question 20. How Do We Synchronize On Premise Sql Server With Sql Azure?

Answer :

We should use a No code solution referred to as DATA SYNC (currently in network technology preview) to synchronize on-premise SQL server with SQL Azure. We also can develop custom answers the usage of SYNC framework.

Hyper SQL Database Interview Questions
Question 21. How Do We Backup Sql Azure Data?

Answer :

SQL Azure keeps three replicas of a database to address hardware stage issues. To address person degree mistakes, we will use COPY command that allows us to create a reproduction of a SQL Azure database. We also can backup SQL Azure data to neighborhood SQL server the use of BCP, SSIS, etc. However as of now, point in time healing isn't always supported.

Question 22. What Is The Current Pricing Model Of Sql Azure?

Answer :

Charges for SQL Azure intake is based on

Size
Data Transfer.
Question 23. What Is The Current Limitation Of The Size Of Sql Azure Db?

Answer :

Maximum length of a SQL Azure database is 50 GB.

Azure Cosmos DB Interview Questions
Question 24. How Do You Handle Datasets Larger Than 50 Gb?

Answer :

As of now, we need to build custom answer at application level that may manage scale out of underlying SQL Azure databases. But Microsoft has announced, SQL Azure Federations with the intention to assist scaling out of SQL Azure databases. And scale out means that we're splitting the records into smaller subsets unfold across multiple databases.

MySQL Interview Questions
Question 25. What Happens When The Sql Azure Database Reaches Max Size?

Answer :

Read operations keep to work but create/insert/replace operations are throttled. You can drop/delete/truncate records.

Question 26. How Do You Improve The Performance Of A Sql Azure Database?

Answer :

We can music a SQL Azure database the use of information to be had from execution plan and statistics of a query. We ought to use SQL Azure Dynamic Management views to reveal and manipulate SQL Azure database.

Also, SQL Azure overall performance is stricken by network latency and bandwidth. Considering this, code in application topology gives the first-class overall performance.

Rational Unified Process Interview Questions
Question 27. What Is Code Near Application Topology?

Answer :

Code close to utility topology method that the SQL Azure database and the windows azure hosted carrier ingesting the facts are hosted within the equal Azure datacenter.

DB2 Using SQL Interview Questions
Question 28. What Were The Latest Updates To Sql Azure Service?

Answer :

Latest SQL Azure updates encompass a couple of servers per subscription, SQL Azure co administrator aid, creating Firewall regulations for servers with IP stumble on.

Question 29. When Does A Workload On Sql Azure Get Throttled?

Answer :

When database reaches its maximum length replace /insert /create operations get throttled. Also there are regulations in region that does not allow to a workload to take advantage of a shared physical server. In different phrases, the guidelines ensure that all workload get a honest percentage of shared bodily server. Now, a workload can get smooth throttled meaning that the workload has crossed the protection threshold. A workload can also were given difficult throttled because of this that a SQL Azure gadget is out of resources and it does no longer accept new connections. We can know more about what befell by way of deciphering reason codes.

Azure B2C Interview Questions