# Microsoft Certification Questions

## What is Microsoft Certification?

Microsoft Certification is a globally recognized Certification for IT professionals. Microsoft encloses the current certifications:
- Microsoft Certified Solutions Associate (MCSA)
- Microsoft Certified Solutions Expert (MCSE)
- Microsoft Certified Solutions Developer (MCSD)
- Microsoft Specialist (MS)

Microsoft Certified Solutions Associate (MCSA) - MCSA offers certifications in Windows Server 2012, Windows Server 2008, Windows 8, Windows 7, Sql Server 2012, Sql Server 2012, Sql Server 2008, Office 365.

Microsoft Certified Solutions Expert (MCSE)-MCSE offers certifications in Server Infrastructure, Desktop Infrastructure, Private Cloud, Data Platform, Business Intelligence, Messaging, Communication, SharePoint.

Microsoft Certified Solutions Developer (MCSD) - MCSD offers certifications in Windows Store Apps, Web Applications, SharePoint Applications, Application Life cycle Management.

Microsoft Specialist (MS) - MS offers certifications in Visual Studio, Windows UX Design, Office 365, Microsoft Project 2013,Microsoft Dynamics.

We have a large database of sample questions on 'Microsoft certification' frequently asked in the certification exams for your practice.

• #### MOS-Microsoft Office Specialist

Q:

As a network administrator you have been requested to move a printer from your company's Marketing OU to your company's Research OU. After the move you test the printer and find that the local administrator assigned to the Marketing OU still has access and can remove print jobs from it. What can you do to change this?

 A) Remove the permissions for the local administrator from the printer. B) Remove printer permissions from the local administrator. C) Remove the Everyone group from the printer. D) Delete the printer object.

Explanation:

5 5257
Q:

You recently been promoted to Network Administrator for DLM Shipping. When you took over this position the first thing you notice is this Windows 2000 environment using DNS naming convention, root domain is DIM.COM, with numerous child domains. User accounts are stored in the child domains. However your supervisor informs you that root domain is misspelled and should be DLM.COM. He explains this is causing tremendous problems with the users and customers. He wants you to rename the domain. What will happen if you rename this root domain server?

 A) When you rename the root domain server you will only have to rebuild the user accounts since the root domain holds the authentication (SAM) database. B) When you rename the root domain server you will simply rename the child domain also. C) When you rename the root domain server you will lose the entire network orphaning the child domains. D) When you rename the root domain server you will not need to do anything else since domain names are inherited the child domains will acquire the new domain name.

Answer & Explanation Answer: C) When you rename the root domain server you will lose the entire network orphaning the child domains.

Explanation:

7 4292
Q:

How many-shares of market value RS.25 each can be purchased for Rs.12750, brokerage being 2% ?

 A) Rs.450 B) Rs.500 C) Rs.550 D) Rs.600

Explanation:

CP. of each share= Rs.(25 + 2% of 25) = Rs.25.50.

Number of shares= $1275025.50$= 500

0 4096
Q:

You have a computer that runs Windows 7.
You need to confirm that all device drivers installed on the computer are digitally signed. What should you do?

 A) At a command prompt, run Verify. B) At a command prompt, run Sigverif.exe. C) From Device Manager, click Scan for hardware changes. D) From Device Manager, select the Devices by connection view.

Explanation:

6 3455
Q:

Which hardware platform (or platforms) are supported by Windows 2000?

 A) The Intel Pentium/ 166MHZ (and higher) platform B) The Compac Alpha platform C) The PowerPC platform D) The MIPS R4000 platform

Answer & Explanation Answer: A) The Intel Pentium/ 166MHZ (and higher) platform

Explanation:

The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.

0 3373
Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.When parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the Exhibit button.)

You want the database to update the InStock field automatically. What should you do?

 A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table. B) Use a view that creates anInStock field as part of an aggregate query. C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables. D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.

Answer & Explanation Answer: A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

Explanation:

Triggers are a special class of stored procedure defined to fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. They are powerful tools that can be used to enforce business rules automatically when data is modified. Triggers can extend the integrity checking logic of SQL Server constraints, defaults, and rules, although constraints and defaults should be used instead whenever they provide all the needed functionality. In this scenario an AFTER UPDATE trigger can be used to update the tables to update the PartsShipped and the PartsReceived tables that update the InStock column in the parts table.

0 3346
Q:

Your network consists of a single Active Directory domain. You have 10 Web servers run Windows Server 2003 Service Pack 2 (SP2). You need to archive all of the application event logs for all the Web servers. The archived logs must contain all information from the original logs. What should you do?

 A) Connect to each Web Server by using Event Viewer. Save the Application logs as the CSV file type. B) Connect to each Web Server by using Event Viewer. Save the Application logs as the Event Log file type. C) On each Web server, open the Security Configuration and Analysis snap in, analyze the computer, and then export the settings. D) Run Security Configuration Wizard for each Web Server. Save the data to an .inf file.

Answer & Explanation Answer: B) Connect to each Web Server by using Event Viewer. Save the Application logs as the Event Log file type.

Explanation:

6 3286
Q:

You have a computer named Computer1 that runs Windows Vista and a computer named Computer2 that runs Windows 7. You plan to migrate all profiles and user files from Computer1 to Computer2.

You need to identify how much space is required to complete the migration.
What should you do?

 A) On Computer1 run Loadstate c:\store /nocompress B) On Computer1 run Scanstate c:\store /nocompress /p C) On Computer2 run Loadstate \\computer1\store /nocompress D) On Computer2 run Scanstate \\computer1\store /nocompress /p

Answer & Explanation Answer: B) On Computer1 run Scanstate c:\store /nocompress /p

Explanation: