Interview Questions.

Q1. What Is Sql Azure Federations?
SQL Azure alliance gives apparatuses that permit designers to scale out (by sharding) in SQL Azure.

Here are a portion of the advantages of a sharded data set:

Exploiting more prominent assets inside the cloud on request.
Permitting clients to have their own data set, to share data sets or to get to numerous information bases.
Decreasing the openness of a weak link.
Profiting from the lower expenses of utilizing cloud assets dependent upon the situation and delivering them when done.
Diminishing I/O bottlenecks and SQL Azure choking.
Q2. What Is Sql Azure Firewall?
SQL Azure firewall is a security instrument that blocks demands in light of its IP address.

Q3. How Do You Improve The Performance Of A Sql Azure Database?
We can tune a SQL Azure data set utilizing data accessible from execution plan and insights of an inquiry. We could utilize SQL Azure Dynamic Management perspectives to screen and oversee SQL Azure information base.

Additionally, SQL Azure execution is impacted by network inactivity and transfer speed. Taking into account this, code in application geography gives the best presentation.

Q4. What Is Federation Member?
The organization part is the shard (i.e., the data set containing a particular scope of data).

T-SQL script:

USE FEDERATION ROOT WITH RESET

GO

Change FEDERATION <Federation Name> SPLIT AT (<Distribution KeyName>=<script point>)

Q5. How Do We Backup Sql Azure Data?
SQL Azure keeps three copies of a data set to handle equipment level issues. To handle client level blunders, we can utilize COPY order that permits us to make an imitation of a SQL Azure data set. We can likewise reinforcement SQL Azure information to neighborhood SQL server utilizing BCP, SSIS, and so forth however at this point, specific moment recuperation isn't upheld.

Q6. What Is Federation?
The league is where you characterize the information type (e.g., Customer ID, Product ID) you'll shard on.

As with making the root data set, you can make a league through the SQL Azure data set administration entrance,

with SQLAzureMW or by utilizing this T-SQL script while associated with your root information base:

Make FEDERATION <FederationName>(<DistributionKeyName> <DistributionType> RANGE)

In this model,

<FederationName> is the name of the league (not the name of the actual data set, which is a System-GUID).

<DistributionKeyName> is the name for the circulation key,

what's more, <DistributionType> is the appropriation information type that information will be sharded on.

The legitimate dissemination information types are int, bigint, uniqueidentifier and varbinary (up to 900).

Q7. What number of Replicas Are Maintained For Each Sql Azure Db?
3 imitations are kept up with for each consistent DB.

Single essential is seen as the copy where genuine read/compose occur. When this goes down, another reproduction is redesigned consequently as a solitary essential.

Q8. How Is Sql Azure Different Than Sql Server?
SQL Azure is a cloud based help thus it has own arrangement of upsides and downsides when contrasted with SQL server. SQL Azure assistance benefits remembers for request provisioning, high accessibility, decreased administration above and adaptability. In any case, SQL Azure edited compositions a few subtleties from the endorser which can be positive or negative which relies upon the setting of the need.

Q9. What Happens When The Sql Azure Database Reaches Max Size?
Peruse activities keep on working however make/embed/update tasks are choked. You can drop/erase/shorten information.

Q10. What number of Servers Can We Create In A Single Subscription?
At this point, we can make six servers under a solitary membership.

Q11. What Is Cloud Computing?
Distributed computing:

Distributed computing is a model for empowering pervasive, helpful, on-request network admittance to a common pool of configurable processing assets (e.g., networks, servers, capacity, applications, and administrations) that can be quickly provisioned and delivered with negligible administration exertion or specialist co-op cooperation.

Q12. What number of Databases Can We Create In A Single Server?
150 data sets (counting ace data set) can be made in a solitary SQL Azure server.

Q13. What Is The Difference Between Web Edition And Business Edition?
SQL Azure Web version data set Max Size is 5 GB while the business release upholds Max Size up to 50 GB.

The size of a web release data set can be expanded (/diminished) in the augmentations (/decrements) of 1 GB

where as the size of a business release can be expanded in the additions of 10 GB.

Q14. How Do You Handle Datasets Larger Than 50 Gb?
At this point, we need to fabricate custom arrangement at application level that can deal with scale out of hidden SQL Azure information bases. However, Microsoft has declared, SQL Azure Federations that will help scaling out of SQL Azure information bases. Also, scale out implies that we are dividing the information into more modest subsets spread across various data sets.

Q15. What Is Federation Root Database?
The organization root data set is a SQL Azure information base that contains metadata about the leagues. It's the principal thing you want to make while setting up your own league

model:

Make DATABASE [fedRoot] COLLATE French_CI_AS (MAXSIZE = 100 GB, EDITION = 'business')

Q16. Which Tools Are Available To Manage Sql Azure Databases And Servers?
We can oversee SQL Azure data set utilizing SQL server the board server 2008 R@Also, we can oversee SQL Azure data sets and servers through a Silverlight application coordinated in Azure administration gateway.

Q17. What Is The Current Limitation Of The Size Of Sql Azure Db?
Greatest size of a SQL Azure data set is 50 GB.

Q18. Inform Me Something Regarding Security And Sql Azure?
SQL Azure help permits hindering a solicitation in view of its IP address through SQL Azure firewall. It utilizes SQL server Authentication component to verify associations. Additionally associations with SQL Azure are SSL-encoded of course.

Q19. When Does A Workload On Sql Azure Get Throttled?
At the point when data set arrives at its greatest size update/embed/make tasks get choked. Likewise there are strategies set up that doesn't permit to a responsibility to take advantage of a common actual server. At the end of the day, the strategies ensure that all responsibility get a decent amount of shared actual server. Presently, a responsibility can get delicate choked that implies that the responsibility has passed the wellbeing boundary. A responsibility can likewise got hard choked which implies that a SQL Azure machine is out of assets and it doesn't acknowledge new associations. We can find out about what occurred by unraveling reason codes.

Q20. What Is Sql Azure?
Microsoft SQL Azure is a cloud-based social data set help that is based on SQL Server advances and runs in Microsoft server farms on equipment that is claimed, facilitated, and kept up with by Microsoft.

Q21. How To Scale Out A Federation By Sql Statement?
Adjust FEDERATION <FederationName> SPLIT AT (<DistributionKeyName>=<value>)

Q22. What Is The Index Requirement In Sql Azure?
All tables probably grouped record. You can't have a table without bunched list.

Q23. How Do We Synchronize On Premise Sql Server With Sql Azure?
We could utilize a No code arrangement called DATA SYNC (at present in local area innovation see) to synchronize on-premise SQL server with SQL Azure. We can likewise foster custom arrangements utilizing SYNC system.

Q24. What Is The Current Pricing Model Of Sql Azure?
Charges for SQL Azure utilization depends on

Size
Information Transfer.
Q25. What number of Replicas Are Maintained For Each Sql Azure Database?
For every data set, three reproductions are kept up with for every data set that one arrangements. One of them is essential reproduction. All read/compose occur on essential reproduction and different imitations are kept in a state of harmony with essential copy. If for reasons unknown, essential goes down, other reproduction is elevated to essential. This occurs in the engine.

Q26. What Is Sharding?
It is a procedure for parceling enormous informational collections, which further develops execution and versatility.
It likewise empowers appropriated questioning of information across numerous occupants.
Q27. How Might We Migrate From Sql Server To Sql Azure?
For Data Migration, we can utilize BCP or SSIS. Furthermore, for pattern Migration we can utilize Generate Script Wizard. Likewise, we could utilize a Tool called SQL Azure movement wizard accessible on codeplex.

Q28. What Were The Latest Updates From Sql Azure Service's point of view?
Most recent SQL Azure updates incorporate different servers per membership, SQL Azure co director support, making Firewall rules for servers with IP distinguish.

Q29. What Is Code Near Application Topology?
Code close to application geography implies that the SQL Azure data set and the windows purplish blue facilitated administration consuming the information are facilitated in a similar Azure datacenter.