Q. What is Microsoft Azure?
Microsoft Azure is a cloud computing platform that provides 200+ products and cloud services planned in a way to help in bringing new solutions to life for solving challenges and creating the future. This also provides the solutions for building, running, and managing applications over multiple clouds, on-premises, and at the edge using the tools and frameworks of your choice.
Q. According to you, what makes Azure a better cloud provider?
Firstly, the important thing is to trust your cloud. Microsoft Azure provides security from the ground up with a team of experts and proactive compliance.
Secondly, here you can use the hybrid smoothly. This offers on-premises over multiple clouds and at the edge. There you can integrate and manage your environments with services made for the hybrid cloud.
Thirdly, with having the support of all languages and frameworks, you can create the way you want and deploy where you want to.
Lastly, Microsoft’s continuous innovation supports your development today and your product visions for tomorrow.
Q. You have selected the Microsoft Azure service, do you think it is secure?
Yes, Azure puts security and privacy as a priority. That is to say, Microsoft has always committed to offer the highest levels of trust, transparency, standards conformance, and regulatory compliance. This offers the most comprehensive set of compliance offerings of any cloud service provider.
Q. Name some of the top customers who are using Azure?
Of the Fortune 500 companies, 95 percent depend on Azure for trusted cloud services. However, companies of all sizes and maturities use Azure in their digital transformation. Some of them include:
- Daimler AG
Q. Is Microsoft Azure only available for Windows apps and services?
No, Azure has support for open source technologies that provide you access to use various tools and technologies. Moreover, this lets you run any application virtually using your data source on your operating system or on your device.
Q. Is Azure cost-effective?
Yes, with having no upfront cost Azure follows the pay for what you use model. This provides flexible purchasing and pricing options for all your cloud scenarios which include the Azure Hybrid Benefit and offers extensive tools for helping you in managing your cloud spend.
Q. According to you, what makes Azure different from other clouds?
Azure is the only compatible hybrid cloud that delivers unparalleled developer productivity. This is the ability for providing comprehensive, multilayered security and the largest compliance coverage of any cloud provider. Moreover, in this, you have to pay less for Windows Server and SQL Server.
Q. Explain the difference between AWS, Azure, and Google Cloud on the basis of Availability Zones?
These cloud providers are well known for hosting in multiple locations worldwide. But, there is a difference between them in the availability zones.
Firstly, AWS has 66 availability zones with 12 more on the way.
Secondly, Microsoft Azure has 54 regions globally and is available in 140 countries.
Lastly, GCP has been available in 20 regions around the world with 3 more on their way.
Q. Explain the types of roles in Microsoft Azure?
There are three types of roles:
1. Web Role
This is for deploying websites by using language that supports the IIS platform customized for running the web apps.
2. Worker Role
This is for executing the process that runs in the background by
3. VM Role
This helps in scheduling the windows services and tasks.
Q. Explain Azure Active Directory (AD) service?
Azure Active Directory (Azure AD) refers to a multi-tenant cloud-based identity and directory management service which is a mixture of core directory services, application access management, and identity protection.
Q. What is the main role of the Azure Service Level Agreement (SLA)?
Azure SLA service makes sure that while sending two or more role instances for each role, access to your cloud service will be maintained 9 out of 10 times. This explains Microsoft’s commitments for uptime and connectivity.
Q. What is the role of Azure Diagnostics API?
Azure Diagnostics API is used for collecting diagnostic data like performance monitoring, and system event log from the applications that are running on Azure. Further, it can be used for:
Firstly, monitoring of the data
Secondly, building visual chart representations
Thirdly, creating performance metric alerts.
Q. What is the Azure storage key?
Azure storage key helps in authentication for validating access for the azure storage service in order for controlling access of data depending on the project requirements. However, while creating a storage account, Azure generates two 512-bit storage account access keys. These keys further use shared key authorizations for authorizing access to data in the storage account.
Q. Define SQL Azure database.
Azure SQL Database refers to a fully managed platform as a service (PaaS) database engine that controls most of the database management functions like upgrading, patching, backups, and monitoring without user involvement. This always running on the latest stable version of the SQL Server database engine. Moreover, it consists of PaaS capabilities that help in focusing on the domain-specific database administration and optimization activities that are critical for your business.
Q. What is cmdlet in Azure?
A cmdlet is basically a command used in the Microsoft Azure PowerShell environment. The cmdlets are collected by the Azure PowerShell that automates the script in the command line. However, Azure PowerShell is a set of cmdlets for managing Azure resources directly from the PowerShell command line.
Q. What do you mean by a BLOB and what are their types?
BLOB is a Binary Large Object that is composed of any size and type of file. They are mainly of two types-the page and the block blob.
Q. What is meant by the block blob and page BLOB?
Blob is a block that is having a specific block ID. Each block in this block BLOB comprises of the 4MB and maximum size of this BLOB limits to 200 GB. Whereas the Page blob contains pages in which data range is determined by the offsets. The maximum limit is 1TB where a single page is of the size 1TB.
Q. Differentiate between the Windows Azure bus queues and Windows Azure queues?
Windows Azure queues take care of the storage infrastructure of Windows Azure. The features include the REST based Peek/Get/Put interface that enables the users to get persistent messaging in-between the services and reliability.
Bus queues are a broader aspect of the messaging infrastructure with publishing and subscribing the integrating patterns of remote web service.
Q. What is meant by the DeadLetter queue?
Messages are transferred to the DeadLetter queue in the following situation;
When the delivery count has exceeded for a message that is on a queue.
When the expiry date of the message has crossed and the entire expired message is held in a queue.
When there is an evaluation exception set by default and the subscription is enabled with dead letter filter.
Q. Explain the Window Azure platform?
It is collectively a PaaS developed by the Microsoft programmed to run a deployment vehicle and a runtime for the data center to host the cloud computing.
Q. How is the price of the Azure subscription placed?
The prices vary in accordance with the product type. The various pricing models are;
The free model where our customers can avail the system exempted from the market fee.
The BYOL scheme where the Azure is fetched the Azure with a fee that is not encircled around the limits of market price.
The trial of the free software where the client gets the full version with an advanced feature for a limited period of time. With the expiration of the introductory period, you will be charged standard rates.
Usage Based Fee that is billed in accordance with the service that you have taken. Like if you are subscribed for the virtual image then hourly fees may be charged.
Monthly bills are activated if you sign a particular plan. The fee is not allocated for cancellation or mid-month unused service.
Q. What do you mean by lookup transformation?
Lookup transformation aids to determine source qualifier. It can be active or passive lookup transformation. The process is yield to get the access the relevant information or the data.
Q. What is meant by the connected lookups?
In the unconnected lookup, the input is directly taken from the transformation that takes part in the flow of data. The connected data lookup is built as both a static and dynamic cache. This can be oriented via multiple ports that can give the output. It is defined by user defined entity.
Q. What is meant by the unconnected lookups?
The answer to this Microsoft Azure interview question should be that in the unconnected lookups the input is taken by the LKP operation. Nature is dynamic having a single output port. User-defined values are disregarded in the unconnected lookups.
Q. What is meant by the command task?
Command task is an operational window that sets off the flow of one or multiple command shell while the system is still running.
Q. What are the PowerCenter commands that can be used in Informatica?
The languages for transformation that can be provided with some basic comment signifiers that are;
If these common signifiers are absent in the line the power integration service will ignore the text.
If you want to land your dream job as an Azure Data Engineer, you must pass the DP 200 and DP 201 certification exams to achieve the Microsoft Certified Azure Data Engineer badge. It will enhance your chances of cracking the interview.
Q. What is the difference between copy and shortcut?
The answer to this Microsoft Azure interview question will be copied is transferring an object from one to another folder that takes double space. There is no change that corresponds to the original object.
The shortcut is a dynamic link of the object that saves the space reflecting changes in the original object.
Q. What do you mean by a service fabric in Azure?
This is one of the advanced Microsoft azure interview questions that should be answered by stating Service fabric is a middleware platform of the following generation that gives the more scalable outcome. It renders with the more managed and reliable enterprise.
Q. What are the benefits of the traffic manager in Windows Azure?
Traffic manager is allocated to control the distribution of the user to deploy the cloud service. The benefit of the traffic manager constitutes;
It makes the application to be available worldwide through automated traffic control machinery.
The traffic managing service contributes to high performance by loading the page faster and convenient usage.
There is no lag of time to maintain or upgrade the existing system. The system keeps running in the back while the system takes time for up gradation.
The configuration is made easy through the Azure portal.
Q. Discuss the different database types in SQL Azure?
This is one of the commonly asked SQL Azure interview questions that must be answered by stating that there are two major type of database in SQL Azure;
Web Edition – It is having a limit of 5GB SQL that is related to the relational database. The basic advantage is that they can be self-maintained, tolerant to a fault and highly available.
Business-based Edition – they support 50GB of T-SQL that is self-managed, tolerant to a fault and highly available. They are suited for the custom web applications or ISV application.
Q. How is Azure Resource Manager beneficial over the classic services?
The benefits of the Azure Resource Manager that overshadows the benefit of the classic services are;
The resources need not be managed, deployed or monitored one at a time. They are chain deployment activities throughout the lifecycle without the need for individual data handling.
The data is also deployed at a consistent pace with the ARM service. It enables the user to use a declarative template that indicates the deployment.
Since the role-based control is present in the management platform that provides you with the access to the resources that leads you to control.
You can mark dependencies between the resources that enable you to get the correct order of deployment.
The resources may be tagged and organized logically so that it is convenient to follow up the billing of your company.
Q. Enlist the monitoring features that are present in the SharePoint 2010?
This is one of the SQL Azure interview questions that should be answered by stating that the SharePoint 2010 is a diagnostic logging that takes into the data that are a direct indication of the state of the system. Sometimes it also specifies some timer tasks that are performed to monitor the collected information. The features include;
It collects the data on event log, timer service, and performance counter.
They are involved with data that are search usage.
They provide matrices that are yielding a collection of sites.
Q. State the class that can be used to retrieve data?
The class that can be used to get data from more than one list is the SPSite Data Query that is able to query data that are present in more than one list all across the diverse web collections. It is featured to aggregate data without the external links and only through the SharePoint.
Q. Compare the STS and SPS and state its important features?
SPS is the SharePoint Portal Service which manages the documents and has a search engine more efficient in penetrating the multiple sources of content.
STS stands for the SharePoint team management. As the name suggests they are better for the document management for a large organization and has a moderate search engine.
Q. Explain MOSS?
The answer to this SQL Microsoft Azure interview question for experienced will be MOSS is abbreviated for Microsoft Office SharePoint Server that constitutes a complete version of the portal platform that yields the user to manage, share and even create the document.
Q. What is the difference between a library and a list?
The library is an interface that yields one to manage and store a document that can be created using Excel, PowerPoint or Word. The list is the representation of the item in a tabulated format using column and rows. Lists are not used to make a document but can attach documents.
For more Click Here