Showing posts with label sas. Show all posts
Showing posts with label sas. Show all posts

January 28, 2020

Top 20 Azure Interview Questions & Answers

Ques: 1. What are the sizes of the Azure VM?

Ans: It is another basic question that finds its place in the series of top Microsoft Azure interview questions. The Windows Azure is destined to balance a variety of sizes. Most of the VM sizes are:
  • The extra-large computer has 8*1.6 GHz of Instance size, with instance storage of 2040 GB, CPU memory of 14 GB. The I/O performance is high. 
  • The large computer has 4*1.6 GHz of Instance size, with instance storage of 1000 GB, CPU memory of 7 GB. The I/O performance is high. 
  • The medium computer has 2*1.6 GHz of Instance size, with instance storage of 490 GB, CPU memory of 3.5 GB. The I/O performance is high. 
  • Small computer has 1.6 GHz of Instance size, with instance storage of 225 GB, CPU memory of 1.75 GB. The I/O performance is moderate. 
  • The extra small computer has 1.0 GHz of Instance size of 20 GB, with instance storage of 20 GB, CPU memory of 768MB. The I/O performance is low.

Ques: 2. How is Azure Resource Manager beneficial over the classic services?

Ans: 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 life cycle 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.

Ques: 3. What do you mean by SAS?

Ans: This is one of the common SQL Azure interview questions that should be answered by stating that SAS is an abbreviation for Statistical analytical System which is a software suite performing analysis of multiple variables. It is in linked to the predictive analysis, data handling, advanced analytics or cooperative intelligence. It produces a smooth interface that offers graphical and clicks based solution. It is user-friendly for the technical or the non-technical with advanced features.


Ques: 4. Describe the log analytics?

Ans: This question can be asked among the SQL Azure interview questions. The operational management service of the Log Analytics provides the entire requirement that runs the particular service. It manifests automation, security, log analytics and availability at a particular dashboard. It generates Power data source that enables the user to get the visuals of the raw data. It is introduced in three different tiers of prices that include free, premium and standard. You enjoy the convenience of searching the data at a single dashboard and export the results.


Ques: 5. State what will you do in case of a drive failure?

Ans: This is one of another Microsoft Azure interview questions for experienced that should be answered in the following manner. When there is an instance that the drive has failed the following step should be performed:
  • The first is that the drive should be not mounted enabling the object storage to function without fail. 
  • The second scenario is replacing the drive in which the desired step will be remounting, formatting the drive.

Ques: 6. Give a clear overview of API in Azure?

Ans: The Test Analytics in API is a web service that is built with the Azure learning. It is an effective tool to analyze the unstructured data like the extraction of the key phrase. It runs with the binomial scoring unit that is either 0 or 1 where 1 corresponds to a positive and 0 corresponds to a negative viewpoint. The advantage is that it does not need any assistance with designing and training which imply that the data is in the hands of directly the user. Proceed to find more Microsoft Azure interview questions for experienced.


Ques: 7. Differentiate between the PROC SUMMARY and PROC MEANS?

Ans:

PROC MEANS refers to the subgroup statist created in the persistence of the BY statement that will be involved. The data here is sorted beforehand with the assistance of BY variables.

PROC SUMMARY is the aid of statistics giving all varieties of information running simultaneously and is produced for every subgroup automatically. The information in the outlet is not created.


Ques: 8. If the client gets disconnected from cache with the services state the probable cause?

Ans: If the client gets disconnected the causal factor can be distributed into two categories:

The cause on the operator side: 
  • There might be a failure in the transfer of the standard cache from one node to the other. 
  • While the service was processing and dispatching the cache got deployed. 
  • There was a server update or an automated VM maintenance.
The fault on the client side:
  • The application of the client accidentally got redeployed. 
  • The application on the client side got auto-scaling. 
  • The layer of the network on the client side altered. 
  • There was a transient error on the network node. 
  • The bound operation took more time. 
  • The upper limit of the bandwidth was reached.

Ques: 9. What is purpose of cloud service configuration file (.cscfg)?  

Ans: Every cloud service type of project contains .cscfg file and primarily is used for storing.

  • Number of role instances to deploy for each role in cloud service project. 
  • Thumbprint of certificates used if any. 
  • And most important, User defined configuration settings.
The primary aim or purpose of this file is to allow configuration changes in production environment without downtime of your application.


Ques: 10. What are different types of Azure blobs and difference between them?

Ans: Azure storage has two type of blob – Block and Page.

BLOCK BLOB:
1. Block blob is ideal for sequential read, write operations.
2. Block blobs should be natural choice for storing the various types of files such as office file, pdf, mp3, video, byte array and so on.
3. The data constitutes from various blocks and each block can have max size of 4MB.
4. Write made to block blob using PutBlock is uncommitted and maintained only for 7 days. User have to call PutBlockList to commit the data permanently.

PAGE BLOB:
1. Page blob is ideal for random read, write operations.
2. Page blob being “sparse” type of storage, is natural choice for storing .VHD files backing the Azure Virtual Machines
3. The data constitutes of various page ranges and each page should be in multiple of 512 bytes.
4. Write made to page blob using PutPage is a direct commit.


Ques: 11. What is the difference between Table Storage and SQL Azure Table?
Ans:

TABLE STORAGE: 
1. This is NoSQL store on Azure
2. As NoSQL, the data is stored in Key-Value pair combination and data is referred as an Entity.
3. Schema is not enforced while storing the data.
4. Combination of partition and row key is treated as unique for an entity.
5. Can’t have relationship between tables.
6. Being key-value store, we can’t define objects such as Stored procedures, Views, functions.
7. General usage is observed for storing diagnostics information, error log information.

SQL AZURE TABLE
1. This is relational store on Azure
2. The data is stored in Rows and Columns combination.
3. Schema is enforces while storing the data. If schema is violated, then error is thrown.  
4. User can define various constraints such primary key, unique key.
5. We can define relationships between tables such as foreign key.
6. We can created Stored procedures, views, functions.
7. Used widely in transaction based systems.


Ques: 12. What are the other VNET options for achieving connectivity with on premise and azure resources?

Ans: Site to Site and express route are other options for achieving cross premises connectivity. Site to site to specifically use when you have large number of resources to be connected. In some cases, Site to Site or Point to Site connectivity may introduce network latency as VPN created by these features work on public infrastructure (Internet) only. To overcome on this situation “Express Route” option can be taken which offers dedicated Leased Line based offering to overcome on latency issue.


Ques: 13. On premises application running few windows services, console applications to handle certain tasks. What should be the approach for migration of such applications to Azure?

Ans: There are 3 ways by which we can achieve background process migration to Azure:

1.Azure Virtual Machine  
2.Worker role 
3.Azure Web Jobs


Ques:14. What is HDInsight in Microsoft Azure?

Ans: HDInsight is a could service which that makes it easy. It is fast and cost-effective to process a massive amount of data using with the help of open-source frameworks like Spark, Hadoop, Hive, Storm and R. HDInsight offers various type of scenarios which includes ETL, data warehousing, and Machine Learning.


Ques: 15. What are the important drawbacks of using Microsoft Azure?
Ans: The below are the major drawbacks of using Azure:
  • Cloud computing is not possible if you are not able to connect to the Internet.
  • Azure is a web-based app which needs a lot of bandwidth to download, as do large documents. 
  • Web-based applications can sometimes be slower compared accessing similar software program on your desktop PC.

Ques: 16. What are the main benefits of Traffic Manager?
Ans: Traffic management offers many advantages for the user:
  • Increase the performance. 
  • No Downtime required for update or Maintenance. 
  • You can easily configure Azure Traffic manager on Windows Azure portal.

Ques: 17. State the difference pricing model of Microsoft Azure.

Ans: The different pricing model of Microsoft Azure are:

BYOL Model: It brings your license model. It is just right to access model. You can obtain it outside of the Azure Marketplace. This model is not charged any fees.

Free Software Trial: It is a full-featured version which is promotionally free for a limited period of time. However, for excessive use, you need to pay fees.

Usage-based: This is a widely used model of Microsoft Azure. Here, user are changed for only that service which is used by them.

Monthly fee: Here, you need to pay a fixed monthly payment for a subscription.


Ques: 18. How can you categorizes Azure services?

Ans: Azure services are classified into into 11 types:
  1. Compute 
  2. Web 
  3. Mobile 
  4. Data storage 
  5. Analytics Networking 
  6. Media 
  7. Content Delivery Network (CDN) 
  8. Hybrid integration 
  9. Identity and access management (IAM) 
  10. Internet of Things (IoT) 
  11. Development Management and security 

Ques:19. What is Azure Service Fabric?

Ans: Azure Service Fabric is a distributed platform for deploying and managing microservices and containers. It allows the developers to focus on implementation which is scalable, reliable, and manageable and not be concerned about the infrastructure. It uses the Azure Service Fabric Resource Provider.
It allows developers to build applications which are composed of micro services. These services run on pool of Virtual machines known as a cluster.
It allows the services to massively scale out. You can create clusters for Service Fabric in many environments such as Linux, on premise. The microservices you can build with Service Fabric can be stateful or stateless.


Ques: 20. What is Service Bus?
Ans: Service bus is a messaging service in Azure.You can use Service bus for sending messages between applications.It is used for decoupling applications and provides asynchronous communication using queues.