Total Page Preview:   000000010304

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.

 

 

 

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

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.
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.
Rajneesh
31-Jan-2017
This is useful for azure developer
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.
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.
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!
Aunger
08-Nov-2020
Thank you for taking the time to write and post this material. King regards, Mead Schneider
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!
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
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!
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.
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.
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.
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.
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.
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.
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
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
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
Barnette
30-Jun-2021
Yes! Finally someone writes about website.
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.
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.
Glenelg
09-Aug-2021
Hello friends, fastidious article and fastidious arguments commented here, I am genuinely enjoying by these.
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.
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!
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.
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!
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
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!
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.
Dodery
09-Apr-2021
Thankfulness to my father who told me on the topic of this webpage, this weblog is really amazing. asmr 0mniartist

                           
                           

                           

                           

Recent Posts

How to get the alternate rows or records from table in sql server
07-Jun-2017
Data Warehouse Three Tier Architecture
20-Aug-2017
SQL Server - Fragmentation on azure sql database
07-Oct-2018
Limitations of Azure SQL Database
19-Sep-2019
PIVOT and UNPIVOT in SQL Server with Example
29-Jun-2017
SQL Server - Find all index with key columns on Azure SQL Database
02-Oct-2018
SQL Server - Find unused indexes on azure SQL database scripts
02-Oct-2018
Find Resource usage in Azure SQL Database using script or T-SQL
07-Oct-2018
How to Set client IP Address using the firewall security in Azure SQL Using Portal
29-Jun-2017
What is a Trigger and type of trigger in SQL server?
10-Sep-2021
What is Table Variable? Explain its advantages and disadvantages?
10-Sep-2021
Top 60 SQL Server Interview Questions Answers for freshers and experienced
17-Sep-2021
Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced
31-Aug-2021
Top 16 performance query optimization techniques in SQL Database?
16-Sep-2021
Data warehouse Interview Questions Answers for freshers and experienced
16-Sep-2021
What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?
10-Sep-2021
What are the different types of Error Handling in SQL Server?
11-Sep-2021
What are the differences between OLTP and OLAP?
07-Sep-2021
How many types of dimension tables available in data warehouse?
16-Sep-2021
What are characteristics and advantages of stored procedure?
10-Sep-2021

Facebook User: