Microsoft Certifications are highly valued in the IT industry and this claim has been substantiated by many surveys to date. These certifications not only equip you with the practical knowledge about the various IT aspects, but also validate your skills and enhance your career prospects. If you are a Microsoft Certified professional, your prospective employer expects you to have a sound knowledge of the Microsoft domain and they don’t hesitate to check your knowledge during the interview. So, here we have listed some important Microsoft domain interview questions and answers, which will help you face the interview more confidently.
Q1. What are Microsoft security patches?
Microsoft security patches are meant to solve certain security loopholes and issues, and at the same time, upgrading the existing security features (if any). This would offer enhanced protection by reducing the vulnerabilities in security.
Q2. What is ASP.NET?
Q3. What is the difference between overriding and overloading in ASP.NET?
- Under this approach, multiple methods can be defined with the same name by changing their signature.
- The above action can be performed within a class as well as a child class.
- No permission is required from the parent for overloading its method in the child class.
- Under this approach, multiple methods can be defined with the same name and signature
- The above action can be performed only under child classes.
- It requires an explicit permission from the parent in order to override its method in the child class.
Q4. What is Microsoft SSIS?
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft’s SQL Server database. It can be utilized for a range of integration-related tasks such as data cleansing and data analyzing, along with running extracts, transform and load, or ETL, processes to update data warehouses.
Q5. What is Active Directory?
Active directory is Microsoft’s directory service that keeps information about the entire Network Objects such as domain controllers, computers, users, groups, shared resources, printers, etc. In other words, it provides a single unified view of the entire network objects and resources; it serves as the Information Hub of the complete network.
Q6. How to install Active Directory in Windows 7 and Windows 8 Computer?
Active Directory is not designed to be installed on Windows 7 and 8; it is meant for the Server Operating System.
Q7. What are Application Partitions?
Application partitions are basically directory partitions, which are replicated to domain controllers. They constitute an important part of the Active Directory System. Domain controllers included in the process of directory partitions contain a replica of that partition. The values and attributes of application partitions can reduce replication traffic. Unlike the domain directory partitions, the application partitions can solely focus on a single domain in the domain area. This property makes them more available and redundant.
Q8. What do you understand by Desktop Virtualization?
Desktop virtualization, in a nutshell, is a software technology that separates the desktop environment and associated application software from the physical client device used to access it. This technology basically separates an individual’s PC applications from his or her desktop. Virtualized desktops are usually hosted on a remote central server, unlike on the physical hard drive as in a traditional PC. Desktop virtualization is also sometimes called client virtualization due to the reason that the client-server computing model is used in it for the purpose of virtualizing the desktop. There are many approaches to desktop virtualization, and the major ones are: Operating System Provisioning, Remote Hosted Desktop, Remote Hosted Dedicated Virtual Desktops, Client-side Hosted Virtual Desktops, and Application Virtualization.
This virtualization software facilitates and enables the users in maintaining their personal desktops on a single, centrally located server. Users might connect to this server via LAN, WAN, or the internet. Desktop virtualization offers several advantages to the users such as decreased Total Cost of Ownership (TCO), enhanced security, energy efficiency, reduced downtime, and centralized management. However, there are several shortcomings of this technology as well, such as high complexity, high initial costs, and maintenance difficulty. But, the advantages surely outweigh the disadvantages.
Q9. What is “summary task” and where it is found in MS project?
In MS Project, a summary task, also called summary activity, is made up of subtasks and summarizes those subtasks. Summary task facilitates estimating the task period and organizes the task in order. The path to find it in MS Project is as follows: Main Menu > Insert > Summary.
Q10. List out the categories of tasks used in MS project?
There are four major types of tasks found in MS Project:
Summary tasks: These tasks consist of subtasks and their related properties
Sub-tasks: These are smaller tasks that are a part of a summary task
Recurring tasks: These are the tasks that fall at regular intervals
Milestones: These are high-priority tasks, which are like short-term goals in the project
Q11. What are the primary differences between Dialogs and workflow?
Following are the primary differences between Processes (Workflows) and Dialogs:
|They can be either manual or automated.
|They must be initiated by a user.
|They are asynchronous processes, and do not allow/require user input to run to completion. These processes run in the background.
|They are synchronous processes, which require user input to run to completion. The user has to select an appropriate process from a wizard-like interface presented to him/her by the system.
|AsyncOperation entities store the detailed information about a running workflow.
|ProcessSession entities store the information generated by a running dialog.
|Windows Workflow Foundation 4 and Windows Workflow Foundation 3.5 custom activities are supported.
|Windows Workflow Foundation 4 custom activities are supported are the only activities supported.
|The user got the freedom to create or update Processes outside of Microsoft Dynamics CRM by respectively creating or updating the underlying XAML file.
|The user cannot create or update Dialogs outside of Microsoft Dynamics CRM.
Q12. Explain what is VBA or Visual Basic for Applications?
Visual Basic for Apllications or VBA in short, is basically an event-driven programming language developed by Microsoft. Though VBA is designed to be used with MS Office apllications like MS-Excel, MS-Word, and MS-Access, but it is largely used with MS-Excel to write user defined functions and commands.
Q13. How many types of data formats are available in MS Excel? Name some of them.
There are eleven different types of data formats available in Microsoft Excel for data Storage. Following are some examples of them:
Text Formats – Store data as a string of texts
Date – Stores data as dates
Number – Stores data as a number
Currency – Stores data in the form of currency
Percentage – Stores numbers as a percentage
Q14. Who can assign permissions in Office 365?
Only global admins can assign an admin role in Office 365 Midsize Business, Office 365 Enterprise, Office 365 Business, Office 365 Business Premium, and Office 365 Business Essentials.
In Office 365 Small Business and Office 365 Small Business Premium, any Office 365 admin can assign admin permissions to the other Office 365 users.
Q15. What are the three main identity models used by Azure Active Directory to manage user authentication in Office 365?
Those three identity models are:
- Cloud Identity
- Synchronized Identity
- Federated Identity. Read More