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

0 3276
Q:

You are installing Windows 2000 on a computer that already has another operating system installed on it. You choose to install Windows 2000 in a different folder than the previously installed operating system. What will Windows 2000 do?

A) Abort the installation process B) Delete the previously installed operating system
C) Display an error message indicating that windows 2000 cannot be installed in a different folder D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system
 
Answer & Explanation Answer: D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system

Explanation:

When windows 2000 is installed in the same folder as the other operating system, Windows 2000 will delete the previously installed operating system. When Windows 2000 is installed in a different folder than the other operating system, it will automatically configure the computer to dual boot between Windows 2000 and the previously installed operating system.

Report Error

View Answer Report Error Discuss

0 3213
Q:

You create a System Policy file on a Windows 2000 Server computer to manage Windows NT 4.0 client computers  (and their users) on your Windows 2000 network. What filename should you assign to this System Policy file?

A) Config.pol B) Ntconfig.pol
C) Nt4config.pol D) Winntconfig.pol
 
Answer & Explanation Answer: B) Ntconfig.pol

Explanation:

A Windows NT 4.0 System Policy file should be named NTconfig.pol

Report Error

View Answer Report Error Discuss

0 3197
Q:

You have a computer named Computer1 that runs Windows 7. You need to ensure that Computer1 can connect to File Transfer Protocol (FTP) servers only while it is connected to a private network. What should you do?

A) From Windows Firewall with Advanced Security, create a new rule. B) From the local Group Policy, modify the application control policies.
C) From Windows Firewall, modify the Allowed Programs and Features list. D) From Network and Sharing Center, modify the Advanced Sharing settings.
 
Answer & Explanation Answer: A) From Windows Firewall with Advanced Security, create a new rule.

Explanation:
Report Error

View Answer Report Error Discuss

1 3131
Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. You use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers are included for reference only.)


01AdventureWorksEntities context = New AdventureWorksEntities
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;


You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source". Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?

A) context.MergeOption = MergeOption.AppendOnly; B) context.MergeOption = MergeOption.PreserveChanges;
C) context.MergeOption = MergeOption.OverwriteChanges; D) context.MergeOption = MergeOption.NoTracking;
 
Answer & Explanation Answer: B) context.MergeOption = MergeOption.PreserveChanges;

Explanation:
Report Error

View Answer Report Error Discuss

1 3106
Q:

As part of trouble shooting errors in a VPN connection, what logs must be checked?

A) IPSec logging B) Event viewer
C) VPNSec Log D) All of above
 
Answer & Explanation Answer: A) IPSec logging

Explanation:
Report Error

View Answer Report Error Discuss

0 3069
Q:

You create an ASP.NET application to provide corporate news and information to XYZ’s employees. The application is used by employees in New Zealand.


Default.aspx has a Web Form label control named currentDateLabel. The Page.Load event handler for Default.aspx included the following line of code:
currentDateLabel.Text = DateTime.Now.ToString(“D”)


You need to ensure that the data is displayed correctly for employees in New Zealand. What should you do?

A) In the Web.config file for the application, set the culture attribute of the globalization element to en-NZ. B) In the Web.config file for the application, set the uiCulture attribute of the globalization element to en-NZ.
C) In Visual Studio .NET, set the responseEncoding attribute in the page directive for Default.aspx to UTF-8. D) In Visual Studio .NET, save the Default.aspx page for both versions of the application by selecting Advanced Save Options from the File menu and selecting UTF-8.
 
Answer & Explanation Answer: A) In the Web.config file for the application, set the culture attribute of the globalization element to en-NZ.

Explanation:

The culture attribute of the globalization element specifies the default culture for processing incoming Web requests.

 

Incorrect Answers:

 

B: The uiculture attribute of the globalization specifies the default culture for processing locale dependent resource searches. It does not apply in this scenario.

 

C, D: The UTF8Encoding Class class encodes Unicode characters using UCS Transformation Format, 8-bit form (UTF-8). This encoding supports all Unicode character values and surrogates. However, it does not help in displaying data in New Zealand format.

Report Error

View Answer Report Error Discuss

0 3020
Q:

You are considering upgrading a Windows NT Workstation 4.0 computer on your network to Windows 2000 Professional. The computer has 12 applications installed in addition to the operating system. All the applications are compatible with Windows 2000. The end user would benefit from the additional features Windows 2000 provides. What action should you take? 

A) Upgrade the Windows NT Workstation 4.0 computer to Windows 2000 Server B) Upgrade the Windows NT Workstation 4.0 computer to Windows 2000 Professional
C) Perform a clean install of Windows 2000 Professional on the Windows NT Workstation 4.0 computer D) Don't upgrade the Windows NT Workstation 4.0 computer, but install the Directory Service Client on it instead
 
Answer & Explanation Answer: B) Upgrade the Windows NT Workstation 4.0 computer to Windows 2000 Professional

Explanation:

Upgrading the computer to Windows 2000 Professional is probably the best choice given that the current operating system is Windows NT Workstation 4.0 (which upgrades easily to Windows 2000 Professional) and the fact that the computer has 12 additional applications installed on it that would need to be reinstalled and reconfigured if a clean install was performed.

Report Error

View Answer Report Error Discuss

0 2939