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.


Q:

You want to configure bindings and provider order on a Windows 2000 computer. Which tool should you use?

A) Network and Dial-up Connections folder B) Windows Explorer
C) System D) Device Manager
 
Answer & Explanation Answer: A) Network and Dial-up Connections folder

Explanation:

Use the Advanced Settings option in the Advanced menu in the Network and Dial-up Connections folder to configure bindings and provider order

Report Error

View Answer Report Error Discuss

0 2315
Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A) EXEC sp_defaultdb 'Andrew','FinanceData' B) GRANT ALL ON FinanceData TO Andrew
C) EXEC sp_addlogin 'Andrew' D) EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'
 
Answer & Explanation Answer: A) EXEC sp_defaultdb 'Andrew','FinanceData'

Explanation:

Error 208 produces the message 'Invalid object name' and occurs when an object that does not exist in the current database is referenced. If the object exists in another database, we must use the USE statement to explicitly switch the context to the correct database or we must qualify the object name with the database name. A third option is to use the sp_defaultdb stored procedure. This stored procedure is used to change the default database for a login. When a client connects with SQL Server, the default database defined for its login becomes the current database without an explicit USE statement. The default database can be defined when the login is added with
sp_addlogin. When executing sp_addlogin the master database is the default database if a database is not specified. In this scenario a SQL Server 2000 login and a user account has been created for Andrew and he has been given database access and the required permissions.

Report Error

View Answer Report Error Discuss

0 2306
Q:

What is the default optimization setting for the Server service on Windows 2000 Server computers?

A) Minimize memory used B) Balance
C) Maximize data throughput for file sharing D) Maximize data throughput for network applications
 
Answer & Explanation Answer: C) Maximize data throughput for file sharing

Explanation:

The Maximize data throughput for file sharing setting is the default setting , and is appropriate for Windows 2000 Server computers that are functioning primarily  as file servers. The Maximize data throughput for network applicatons setting is the preffered setting for domain controllers.

Report Error

View Answer Report Error Discuss

0 2265
Q:

What is the name of the service included with the Windows Server operating system that manages a centralized database containing user account and security information ?

A) Windows Directory B) Active Directory
C) Directory Plus D) None of the above
 
Answer & Explanation Answer: B) Active Directory

Explanation:

Active Directory (AD) is a centralized database that is included with the Windows Server operating system. Active Directory is used to store information about a network, such as user accounts, computers, printers, and security policies.

Report Error

View Answer Report Error Discuss

6 2255
Q:

You have a computer that runs Windows 7.


A printer is installed on the computer.


You remove the Everyone group from the access control list (ACL) for the printer, and then you share the printer. You need to ensure that members of the Sales group can modify all the print jobs that they submit.


You must prevent Sales group members from modifying the print jobs of other users.
What should you do?

A) From the printer's properties, assign the Print permission to the Sales group. B) From the printer's properties, assign the Manage Documents permission to the Sales group.
C) From the local Group Policy, assign the Increase scheduling priority user right to the Sales group. D) From the local Group Policy, assign the Take ownership of files or other objects user right to the Sales group.
 
Answer & Explanation Answer: A) From the printer's properties, assign the Print permission to the Sales group.

Explanation:
Report Error

View Answer Report Error Discuss

2 2216
Q:

When will the configure DNS Server Wizard not permit you to configure a Windows 2000 DNS server as a root server?

A) When Active Directory is installed on the DNS server B) When the DNS server has a dynamic IP address
C) When the DNS server is connected to the Internet D) When another server is configured to use the DNS server as a forwarder
 
Answer & Explanation Answer: C) When the DNS server is connected to the Internet

Explanation:

When a Windows 2000 DNS server is connected to the Internet, the Configure DNS Server Wizard does not permit you to configure this server as a root server.

Report Error

View Answer Report Error Discuss

0 2198
Q:

You are the administrator of eight SQL Server 2000 computers. You configure alerts on each server so that various problem conditions will be reported if they occur.You create 20 operators on one of the servers. You configure these operators by using the e-mail and pager contact information for the employees in your department. You configure the alerts on the server to send e-mail messages and pager messages to the appropriate operators.You need to configure the same 20 operators on the other seven servers. You want to do this with a minimum amount of administrative time.What should you do?

A) Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers. B) Detach the msdb database from the first server. Copy the database to the other seven servers. Attach the database on all eight servers.
C) Use snapshot replication to replicate the msdb database from the first server to the other seven servers. D) Use SQL ServerEnterprise Manager on a single client computer to create the operators on each server.
 
Answer & Explanation Answer: A) Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers.

Explanation:

Transact-SQL scripts can be used to create defined operators or alerts. Scripting all the
predefined operators and alerts and copying them to the servers if the same group of operators is responsible for responding to the same alerts on other servers can save time.

Report Error

View Answer Report Error Discuss

0 2167
Q:

You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1 GB of RAM.Your network consists of 500 client computers that are running Microsoft Windows Millennium Edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages.You use System Monitor to monitor processor performance and RAM utilization. You discover that the % Total Time and % User Time counters average 90 percent and the % Privileged Time counter averages 20 percent. The Available Mbytes counter averages 800 MB. You need to improve server performance for user logons. What should you do?

A) Increase the physical RAM on the computer to 2 GB. B) Increase the virtual RAM on the computer to 4 GB.
C) Configure SQL Server to use only processors 0, 1, and 2. D) Configure SQL Server to use only processors 1, 2, and 3.
 
Answer & Explanation Answer: D) Configure SQL Server to use only processors 1, 2, and 3.

Explanation:

The system monitor clearly indicates that the processors are overloaded. We need to decide which processors we should use for SQL Server. Processor 0 is the default CPU for the I/O subsystem. Network Interface Cards (NIC) are assigned to the remaining CPUs, starting from the highest-numbered CPU. The NIC would get processor 3.
SQL Server would be using all four processors by default.

The Windows NT/2000/XP operating system use processor 0. In order to avoid the logon
problems we should not let SQL Server to use this processor. Instead SQL Server should be configured to use processor 1, 2, and 3.

Note 1: The Affinity mask is used to exclude a processor on a multiprocessor computer from processing SQL Server 2000 threads. Default is equal distribution of SQL Server 2000 processes across all processors.

Note 2: Monitoring the Processor and System object counters provides information about the CPU utilization and helps in determining whether or not a bottleneck exists. The %Total Processor Time is used on multiple CPU Severs to gauge the average activity of the processors and shows the percentage of elapsed time that a processor is busy executing a nonidle thread. Values around 100 percent on a Server computer that processes many client requests indicate that processes are queuing up, waiting for processor time, and causing a bottleneck. Such a sustained high level of processor usage is unacceptable for a server.

Report Error

View Answer Report Error Discuss

0 2122