Sawaal

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.

Popular Latest Rated
Q:

You have a portable computer named Computer1 that runs Windows 7.
You have a file server named Server1 that runs Windows Server 2008. Server1 contains a shared folder named Share1.


You need to configure Computer1 to meet the following requirements:
Ensure that cached files from Share1 are encrypted.
Ensure that files located in Share1 are available when Server1 is disconnected from the network.


What should you do?

A) On Server1, encrypt the files in Share1. On Computer1, make Share1 available offline. B) On Server1, configure BitLocker Drive Encryption. On Computer1, make Share1 available offline.
C) On Computer1, make Share1 available offline and enable encryption of offline files. D) On Computer1, copy the files from Share1 to the Documents library and configure BitLocker Drive Encryption.
 
Answer & Explanation Answer: C) On Computer1, make Share1 available offline and enable encryption of offline files.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSA-Microsoft Certified Solutions Associate - Microsoft Certification

2 3060
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

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 3048
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

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 3043
Q:

When you run Sysprep on a Windows 2000 computer, what happens to the user-specific information on the computer?

A) It is preserved in usset.inf B) It is saved and automatically reinstalled
C) It is removed D) It is not altered
 
Answer & Explanation Answer: C) It is removed

Explanation:

The user-specific settings are removed by Sysprep.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 3021
Q:

You have installed a Windows Server 2003 DNS server, but because of security reasons, you have to install this behind a firewall. What port on the firewall must be opened so that users can access the server?

A) IP and UDP port 42 B) UDP and TCP port 53
C) TCP 53 but not UDP D) PPTP and UDP 21
 
Answer & Explanation Answer: B) UDP and TCP port 53

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 3012
Q:

You are preparing to install Certificate Services for the first time on your Windows 2000 network. You plan to install Certificate Services on a Windows 2000 Server computer that is a member of the domain. You want the certification authority (CA) to be able to use Active Directory. Which CA type should you select when you install Certificate Services? 

A) Enterprise root CA B) Enterprise subordinate CA
C) Stand-alone root CA D) Stand-alone subordinate CA
 
Answer & Explanation Answer: A) Enterprise root CA

Explanation:

Select Enterprise root CA if you're installing the first certificate server in the forest. This type of CA requires the use of Active Directory.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 2902
Q:

You are archiving a Security Log for later analysis in a spreadsheet. Which file type should you assign to the log when you save it?

A) .evt B) ,txt
C) .csv D) .exe
 
Answer & Explanation Answer: C) .csv

Explanation:

Saving the Security Log as a comma - delimited file is probably the best choice if you want to analyze the data later in a spreadsheet.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 2898
Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert - Microsoft Certification

0 2825