Total Page Preview:   000000015269

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 :


This is useful for azure developer
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.
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!
Everything is very open with a precise description of the challenges. It was definitely informative. Your site is very helpful. Many thanks for sharing!
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.
Hurrah! Finally I got a blog from where I know how to in fact obtain valuable data concerning my study and knowledge.
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
If you desire to obtain a great deal from this article then you have to apply these methods to your won web site.
You should be a part of a contest for one of the highest quality websites online. I most certainly will recommend this website!
Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Anyway I'll be subscribing to your augment and even I achievement you access consistently rapidly.
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.
Thank you for taking the time to write and post this material. King regards, Mead Schneider
Greate article. Keep writing such kind of info on your blog. Im really impressed by your blog. Hello there, You have performed a great job. I will definitely digg it and individually recommend to my friends. I'm confident they'll be benefited from this website.
I am sure this piece of writing has touched all the internet visitors, its really really pleasant paragraph on building up new weblog.
Just want to say your article is as astonishing. The clearness in your post is simply nice and i could assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please carry on the rewarding work.
It's really very difficult in this busy life to listen news on TV, so I just use internet for that reason, and get the latest news.
great publish, very informative. I wonder why the other experts of this sector do not realize this. You must continue your writing. I'm sure, you have a huge readers' base already! 0mniartist asmr
Thankfulness to my father who told me on the topic of this webpage, this weblog is really amazing. asmr 0mniartist
That is really interesting, You're an overly professional blogger. I have joined your rss feed and sit up for in the hunt for extra of your wonderful post. Additionally, I have shared your web site in my social networks asmr 0mniartist
I loved as much as you will receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this hike. asmr 0mniartist
Yes! Finally someone writes about website.
Every weekend i used to go to see this website, as i wish for enjoyment, as this this web site conations truly pleasant funny material too.
I'm not sure why but this web site is loading very slow for me. Is anyone else having this issue or is it a issue on my end? I'll check back later and see if the problem still exists.
Hello friends, fastidious article and fastidious arguments commented here, I am genuinely enjoying by these.
This article will assist the internet people for setting up new web site or even a weblog from start to end.
Hi would you mind sharing which blog platform you're working with? I'm going to start my own blog soon but I'm having a tough time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking for something completely unique. P.S Apologies for getting off-topic but I had to ask!
Just desire to say your article is as astounding. The clarity in your post is just excellent and i could assume you are an expert on this subject. Well with your permission allow me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please continue the rewarding work.
Hi there! I could have sworn I've visited this blog before but after browsing through some of the articles I realized it's new to me. Nonetheless, I'm definitely delighted I found it and I'll be bookmarking it and checking back often!
I really like your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz reply as I'm looking to construct my own blog and would like to find out where u got this from. thanks
Hello there! I know this is somewhat off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having difficulty finding one? Thanks a lot!
Your means of telling everything in this piece of writing is actually fastidious, every one be capable of simply understand it, Thanks a lot.




Facebook User: