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 2: What 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.

Thanks

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 : https://www.linkedin.com

Comments

Enderby 19-Oct-2021 Your means of telling everything in this piece of writing is actually fastidious, every one be capable of simply understand it, Thanks a lot. http://rrunonotnew125.com Relpy Peter 18-Dec-2017 Pretty good theoretical questions, but definitely also practice practical SQL interview questions: https://www.testdome.com/d/sql-interview-questions/17 Especially related to Azure and the cloud in general. Relpy Plumb 21-Sep-2018 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. http://fairbeautytrends.com/the-best-curling-wands-2018/ Relpy Rajneesh 31-Jan-2017 This is useful for azure developer Relpy Lemke 28-Jul-2020 If you desire to obtain a great deal from this article then you have to apply these methods to your won web site. http://heistheway1.com Relpy Mullagh 21-Nov-2019 Hurrah! Finally I got a blog from where I know how to in fact obtain valuable data concerning my study and knowledge. http://tinyurl.com/quest-bars-cheap-39003 Relpy Hartung 13-Nov-2019 Everything is very open with a precise description of the challenges. It was definitely informative. Your site is very helpful. Many thanks for sharing! http://tinyurl.com/t2ptndt Relpy Aunger 08-Nov-2020 Thank you for taking the time to write and post this material. King regards, Mead Schneider https://nearum.com/stores/american-express-locations Relpy Wegener 08-Aug-2020 You should be a part of a contest for one of the highest quality websites online. I most certainly will recommend this website! http://cheyuwo.com/home.php?mod=space&uid=186249&do=profile&from=space Relpy Ferrell 21-Nov-2019 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 http://tinyurl.com/rrh47s8 Relpy Page 05-Oct-2019 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! https://www.hqscaffolding.co.uk/ Relpy Lachance 16-Nov-2019 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. http://bit.ly/2OaNv3D Relpy Fedler 18-Jan-2021 I am sure this piece of writing has touched all the internet visitors, its really really pleasant paragraph on building up new weblog. http://oniyokay32.com Relpy Neill 29-Jan-2021 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. http://yhoo.it/2Yq7Vvi Relpy Fernandez 08-Aug-2020 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. http://bbs.mumayi.net/space-uid-9716024.html Relpy Hallowell 15-Sep-2020 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. http://herenfsdd3dfdd.com Relpy Loera 15-Mar-2021 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. http://roswitheid21.com Relpy Edelson 08-Apr-2021 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 http://0mniartist.tumblr.com Relpy Ritchard 09-Apr-2021 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 http://0mniartist.tumblr.com Relpy Carrell 09-Apr-2021 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 http://0mniartist.tumblr.com Relpy Barnette 30-Jun-2021 Yes! Finally someone writes about website. http://http:/ntyyrg35.com Relpy Fryett 09-Jul-2021 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. http://http:/ntyyrg35.com Relpy McCloughry 10-Jul-2021 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. http://http:/ntyyrg35.com Relpy Glenelg 09-Aug-2021 Hello friends, fastidious article and fastidious arguments commented here, I am genuinely enjoying by these. http://http:/ntyyrg42.com Relpy Garibay 13-Aug-2021 This article will assist the internet people for setting up new web site or even a weblog from start to end. http://rrunonotnew95.com Relpy Sewell 23-Aug-2021 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! http://j.mp/3zbD8ms Relpy Apple 23-Aug-2021 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. http://j.mp/3zbD8ms Relpy Wilkins 24-Aug-2021 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! http://bit.ly/3zbD8ms Relpy Kincaid 27-Aug-2021 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 http://rrunonotnew100.com Relpy Carswell 13-Sep-2021 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! http://rrunonotnew107.com Relpy Siede 16-Nov-2020 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. http://seeonyowith62.com Relpy Dodery 09-Apr-2021 Thankfulness to my father who told me on the topic of this webpage, this weblog is really amazing. asmr 0mniartist http://0mniartist.tumblr.com Relpy

Please enter your comment.                             Please enter your Email-Id. Please enter valid Email-Id                             Please enter your name.                             Notify me of new comments via email. Notify me of new posts via email.