Azure Sql interview questions
AZURE
Q) What is Azure Cloud Service?
Q)
How many servers can you create in the single subscription?
Q) How can you improve the performance of SQL
Azure databases?
Q)
What is the code new application topology?
Q) What are the benefits of a Sharded Database?
What is a service definition file?
What is a service configuration file?
What is a service package?
What is a cloud service deployment?
What is Azure Diagnostics?
What is Azure Service Level Agreement (SLA)?
How many types of deployment models are used in the
cloud?
What are the roles available in Windows Azure?
What is the difference between the Windows Azure
Platform and Windows Azure?
What are the three main components of the Windows
Azure Platform?
Answer:
What is Windows Azure compute emulator?
What is fabric?
What are the options to manage session state in
Windows Azure?
What is cspack?
What is csrun?
What is
the dead letter queue?
What is federation
in SQL Azure?
Q) What is Azure Cloud Service?
Ans: By creating a cloud service, you can deploy a multi-tier web application in Azure, defining multiple roles to distribute processing and allow flexible scaling of your application. A cloud service consists of one or more web roles and/or worker roles, each with its own application files and configuration. Azure Websites and Virtual Machines also enable web applications on Azure. The main advantage of cloud services is the ability to support more complex multi-tier architectures
Q)
How many servers can you create in the single subscription?
Answer: In the single subscription, it is possible to create six
servers while using SQL Azure.
Q) How many of the databases can you create in
the single server?
Answer: In the single SQL Azure server, it is possible to create
150 databases that will include a master database as well.
Q) Can you explain about the SQL Azure
security?
Answer: SQL Azure services will allow you to block the request
that will be based on IP address by using the SQL Azure firewall. It will use
the SQL server authentication process that will authenticate the connections.
By default, SQL Azure connections are SSL encrypted.
Q) How will you sync SQL Azure with on-premise
SQL server?
Answer: It is possible to use No code solution named as DATA SYNC
to sync SQL Azure with on-premise SQL server. It is also possible to develop
the custom solutions by using SYNC Framework for it.
SQL Azure allows users to run their SQL server workloads as a
hosted service (PaaS). So, you may also come across some of the PaaS interview
questions in the SQL Azure interview. Read few and get yourself ready for
everything.
Q) On which factors current pricing model
for SQL Azure consumption depend?
Answer: The charges for consumption of SQL Azure are currently
based on the following two factors
·
Size
·
Data Transfer
Q) How will you handle the data sets having a size larger
than 50 GB?
Answer: You will need to build a custom solution on
application level to handle out of scale SQL Azure database. According to the
Microsoft, you will be assisted by SQL Azure Federations for scaling out of the
SQL Azure database. Scaling out of data means that the data will be split into
smaller subsets and will be spread to multiple databases.
Q) How can you improve the performance of SQL
Azure databases?
Answer: To
improve the performance of SQL Azure databases, you can tune the database by
using the information from the execution plan as well as statistics of the
query. It is possible to use dynamic management views of SQL Azure for the
monitoring and management of the SQL Azure database. Network latency and
bandwidth also affect the performance of the SQL Azure database so it can be
used to improve the performance.
Q)
What is the code new application topology?
Answer: The
code in your application topology will mean that the database and Windows Azure
hosting services are consuming the data hosted in the same Azure data center.
Q) What are the benefits of a Sharded Database?
Answer: Followings are
some of the benefits of the sharded database –
·
Allows users to take benefit of
maximum resources within the cloud
·
Reduces the chances of a single
point of failure
·
Reduces SQL Azure throttling and
I/O bottlenecks
·
Enables users to have their own
database, to access other databases, and to share database
·
Benefits users by offering
low-cost cloud resources on-demand basis and releasing when done
What is a service definition file?
Answer: The
cloud service definition file (.csdef) defines the service model, including the
number of roles.
What is a service configuration file?
Answer: The
cloud service configuration file (.cscfg) provides configuration settings for
the cloud service and individual roles, including the number of role instances.
What is a service package?
Answer: The
service package (.cspkg) contains the application code and the service
definition file.
What is a cloud service deployment?
Answer: A
cloud service deployment is an instance of a cloud service deployed to the
Azure staging or production environment. You can maintain deployments in both
staging and production.
What is Azure Diagnostics?
Answer: Azure
Diagnostics is the API that enables you to collect diagnostic data from
applications running in Azure. Azure Diagnostics must be enabled for cloud
service roles in order for verbose monitoring to be turned on.
What is Azure Service Level Agreement (SLA)?
Answer: The
Azure Compute SLA guarantees that, when you deploy two or more role instances
for every role, access to your cloud service will be maintained at least 99.95
percent of the time. Also, detection and corrective action will be initiated
99.9 percent of the time when a role instance’s process is not running.
What is Cloud Computing?
Answer: Cloud
computing is the use of computing resources (hardware and software) that are
delivered
as a service over a network (typically the Internet).
What are the Service Model in Cloud Computing?
Answer: Cloud
computing providers offer their services according to three fundamental models:
Infrastructure as a service (IaaS), platform as a service (PaaS), and software
as a service (SaaS) where IaaS is the most basic and each higher model
abstracts from the details of the lower models.
Examples of IaaS include Amazon CloudFormation (and underlying services such as
Amazon EC2), Rackspace Cloud, Terremark, Windows Azure Virtual Machines, Google
Compute Engine. and Joyent.
Examples of PaaS include Amazon Elastic BeAnswertalk, Cloud Foundry, Heroku,
Force.com, EngineYard, Mendix, Google App Engine, Windows Azure Compute, and
OrangeScape.
Examples of SaaS include Google Apps, Microsoft Office 365, and Onlive. Source
from:
How many types of deployment models are used in the
cloud?
Answer: There
are 4 types of deployment models used in the cloud:
1. Public
cloud
2. Private
cloud
3. Community
cloud
4. Hybrid
cloud
What are the roles available in Windows Azure?
Answer: All
three roles (web, worker, VM) are essentially Windows Server 2008. Web and
Worker roles are nearly identical: With Web and Worker roles, the OS and
related patches are taken care for you; you build your app’s components without
having to manage a VM
What is the difference between the Windows Azure
Platform and Windows Azure?
Answer: The
former is Microsoft’s PaaS offering including Windows Azure, SQL Azure, and
AppFabric; while the latter is part of the offering and Microsoft’s cloud OS.
What are the three main components of the Windows
Azure Platform?
Answer:
1. Compute
2. Storage
3. AppFabric
What is Windows Azure compute emulator?
Answer: The
compute emulator is a local emulator of Windows Azure that you can use to build
and test your application before deploying it to Windows Azure.
What is fabric?
Answer: In
the Windows Azure cloud fabric is nothing but a combination of many virtualized
instances which run the client application
What are the options to manage session state in
Windows Azure?
Answer:
·
Windows Azure Caching
·
SQL Azure
·
Azure Table
What is cspack?
Answer: It
is a command-line tool that generates a service package file (.cspkg) and
prepares an application for deployment, either to Windows Azure or to the
compute emulator.
What is csrun?
Answer: It
is a command-line tool that deploys a packaged application to the Windows Azure
compute emulator and manages the running service.
What is
the dead letter queue?
Answer:
1. Messages
are placed on the dead-letter sub-queue by the messaging system in the
following scenarios.
2. When a
message expires and dead-lettering for expired messages is set to true in a
queue or subscription.
3. When the
max delivery count for a message is exceeded on a queue or subscription.
4. When a
filter evaluation exception occurs in a subscription and dead-lettering is
enabled on filter evaluation exceptions.
What is federation
in SQL Azure?
Organization in SQL
Azure is introduced for scalability. Federation helps both managers and
developers scale information. It helps managers by making repartitioning and
redistributing of information in a simpler manner. It enables developers in the
layer of routing and sharing of information. It helps in routing without
application downtime.
What is
profiling in Azure?
Profiling is only a
procedure for measuring the performance analysis of an application. It is
normally done to guarantee that the application is sufficiently steady and can
maintain overwhelming traffic.
Visual Studio gives
us different tools to do it by gathering the performance information from the
application that likewise helps in troubleshooting issues.
Once the profiling
wizard is run, it sets up the execution session and collects the data of the
sample.
The profiling
reports help in:
• Deciding the
longest running strategies inside the application
• Measuring the execution time of every strategy in the call stack
• Assessing memory allocation
Comments
Post a Comment