Total Page Preview:   000000009524

SQL Azure database Interview question for fresher and experienced

Question 1: What is SQL Azure?

Answer: SQL Azure is a cloud based relational database as a Service offered by Microsoft.SQL Azure Database provides predictable performance, scalability, business continuity, data protection, and near-zero administration for cloud developers.


Question 2What is cloud computing?

Answer: "Cloud computing is a general term for the delivery of hosted services over the internet".

Cloud computing is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction.


Question 3: What happens when the SQL Azure database reaches Max Size?

Answer:  Data Read/Fatch operations will continue to work but create/insert/update operations are stoped. You can drop/delete/truncate data.


Question 4: What is the current limitation of the size of SQL Azure DB?

Answer Maximum size of a SQL Azure database is  250 GB (s0, s1, s2 and s3) and 500GB (p1,p2,p3 and p6 ) and 4TB (p11 and p15)For More Details


Question 5: What encryption security is available in SQL Azure?

Answer: Only SSL connections are supported. SET Encryption = TRUE.


Question 6: What is SQL Azure Firewall?

Answer: SQL Azure firewall is a security mechanism that blocks requests based on its IP address.


Question 7: How many databases can we create in a single server?

Answer: 150 databases (including master database) can be created in a single SQL Azure server.


Question 8: How many servers can we create in a single subscription?

Answer: We can create six(6) servers under a single subscription.


Question 9: Tell me something about security and SQL Azure.

Answer: SQL Azure service allows blocking a request based on its IP address through SQL Azure firewall. It uses SQL server Authentication mechanism to authenticate connections. Also connections to SQL Azure are SSL-encrypted by default.


Question 10: What is the difference between web edition and business edition?

Answer: SQL Azure Web edition database Max Size is 5 GB whereas the business edition supports Max Size up to 50 GB

Web edition database can be increased/decreased of 1 GB whereas the size of a business edition can be increased/decreased of 10 GB.





Brijesh Kumar

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn :

Really helpful Thank You.
Pretty good theoretical questions, but definitely also practice practical SQL interview questions: Especially related to Azure and the cloud in general.
I have been browsing online more than three hours nowadays, yet I by no means found any attention-grabbing article like yours. It is pretty price enough for me. Personally, if all website owners and bloggers made excellent content material as you did, the web will likely be much more useful than ever before.
This is useful for azure developer
Hurrah! Finally I got a blog from where I know how to in fact obtain valuable data concerning my study and knowledge.
Everything is very open with a precise description of the challenges. It was definitely informative. Your site is very helpful. Many thanks for sharing!
I feel that is among the most important info for me. And i am glad reading your article. But should commentary on some normal issues, The site taste is perfect, the articles is actually great : D. Good job, cheers
Scaffolding rental is the ability to effectively perform work at heights. Thank you very much for sharing our post, thanks to you we know that our solutions will be well-known and passed on to larger circles of people. By reaching a larger group of people, we have the opportunity to develop and make life easier for others!
Hi there I am so grateful I found your weblog, I really found you by error, while I was searching on Aol for something else, Regardless I am here now and would just like to say thanks for a tremendous post and a all round exciting blog (I also love the theme/design), I don’t have time to read it all at the minute but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the great jo.
Hi, I do believe this is a great site. I stumbledupon it ;) I may revisit once again since I book marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide other people.




Facebook User: