Tuesday, March 6, 2012

Interview Question Answers on SQL Azure and Cloud Computing

Ques: What is SQL Azure?
Sol: SQL Azure is a cloud based relational database as a Service offered by Microsoft. Conceptually it is SQL server in the cloud.

Ques: What is cloud computing?
sql azure and cloud computing question answersSol: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.

Ques: What is the current limitation of the size of SQL Azure DB?
Sol: Maximum size of a SQL Azure database is 50 GB.

Ques: How is SQL Azure different than SQL server?
Sol:SQL Azure is a cloud based service and so it has own set of pros and cons when compared to SQL server. SQL Azure service benefits includes on demand provisioning, high availability, reduced management overhead and scalability. But SQL Azure abstracts some details from the subscriber which can be good or bad which depends on the context of the need.
Ques: How many replicas are maintained for each SQL Azure database?
Sol:For each database, three replicas are maintained for each database that one provisions. One of them is primary replica. All read/write happen on primary replica and other replicas are kept in sync with primary replica. If for some reason, primary goes down, other replica is promoted to primary. All this happens under the hood.

Ques: Which tools are available to manage SQL Azure databases and servers?
Sol: We can manage SQL Azure database using SQL server management server 2008 R2. Also, we can manage SQL Azure databases and servers through a Silverlight app integrated in Azure management portal.

Ques: Tell me something about security and SQL Azure.
Sol: 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.

Ques: What were the latest updates to SQL Azure service?
Sol: Latest SQL Azure updates include multiple servers per subscription, SQL Azure co administrator support, creating Firewall rules for servers with IP detect.

Ques: What is SQL Azure Firewall?
Sol: SQL Azure firewall is a security mechanism that blocks requests based on its IP address.
Ques: What is the difference between web edition and business edition?
Sol: SQL Azure Web edition database Max Size is 5 GB whereas the business edition supports Max Size up to 50 GB. The size of a web edition database can be increased (/decreased) in the increments (/decrements) of 1 GB whereas the size of a business edition can be increased in the increments of 10 GB.

Ques: How do we synchronize On Premise SQL server with SQL Azure?
Sol: We could use a No code solution called DATA SYNC (currently in community technology preview) to synchronize on-premise SQL server with SQL Azure. We can also develop custom solutions using SYNC framework.

Ques: How can we migrate from SQL server to SQL Azure?
Sol: For Data Migration, we can use BCP or SSIS. And for schema Migration we can use Generate Script Wizard. Also, we could use a Tool called SQL Azure migration wizard available on codeplex.

Ques: How do we Backup SQL Azure Data?
Sol: SQL Azure keeps three replicas of a database to tackle hardware level issues. To tackle user level errors, we can use COPY command that allows us to create a replica of a SQL Azure database. We can also backup SQL Azure data to local SQL server using BCP, SSIS, etc. but as of now, point in time recovery is not supported.
Ques: How do you handle datasets larger than 50 GB?
Sol: As of now, we have to build custom solution at application level that can handle scale out of underlying SQL Azure databases. But Microsoft has announced, SQL Azure Federations that will assist scaling out of SQL Azure databases. And scale out means that we are splitting the data into smaller subsets spread across multiple databases.

Ques: What happens when the SQL Azure database reaches Max Size?
Sol: Read operations continue to work but create/insert/update operations are throttled. You can drop/delete/truncate data.

Ques: How many databases can we create in a single server?
Sol: 150 databases (including master database) can be created in a single SQL Azure server.

Ques: How many servers can we create in a single subscription?
Sol: As of now, we can create six servers under a single subscription.

Ques: How do you improve the performance of a SQL Azure Database?
Sol: We can tune a SQL Azure database using information available from execution plan and statistics of a query. We could use SQL Azure’s Dynamic Management views to monitor and manage SQL Azure database.
Also, SQL Azure performance is affected by network latency and bandwidth. Considering this, code near application topology gives the best performance.

Ques: What is code near application topology?
Sol: Code near application topology means that the SQL Azure database and the windows azure hosted service consuming the data are hosted in the same Azure datacenter.
[FYI: in the code far application topology, the app connects to SQL Azure from outside the Microsoft data center]


Powered by Code Imagine