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 reference computer that runs Windows 7.

You plan to deploy an image of the computer.

You create an answer file named answer.xml.

You need to ensure that the installation applies the answer file after you deploy the image. Which command should you run before you capture the image?

A) Imagex.exe /append answer.xml /check B) Imagex.exe /mount answer.xml /verify
C) Sysprep.exe /reboot /audit /unattend:answer.xml D) Sysprep.exe /generalize /oobe /unattend:answer.xml
 
Answer & Explanation Answer: D) Sysprep.exe /generalize /oobe /unattend:answer.xml

Explanation:
Report Error

View Answer Report Error Discuss

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

4 3380
Q:

You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.


- A BULK INSERT job imports data at 10:00 P.M
- Indexes are rebuilt at 10:15 P.M
- Data integrity checks are performed at 10:30 P.M
- A differential backup is performed at 10:45 P.M
- A DBCC SHRINKDATABASE job runs at 11:00 P.M.


You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file  'inventory_data'."You need to ensure that the final job runs without errors.

What should you do?

A) Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually. B) Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
C) Increase the time between the differential backup and the DBCC SHRINKDATABASE job. D) Increase the time between the data integrity checks and the differential backup.
 
Answer & Explanation Answer: C) Increase the time between the differential backup and the DBCC SHRINKDATABASE job.

Explanation:

The DBCC SHRINKDATABSE cannot be executed until the previous job step, the differential backup, has been completed. We should increase the time between these two job steps, or even better configure the last job step to run only after the differential backup has been completed.

 

Note: The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis but shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement.

Report Error

View Answer Report Error Discuss

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

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

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

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

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

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

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

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

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

0 3121
Q:

You are preparing to install Windows 2000 on a computer, and you want this computer to be able to dual  boot between Windows 2000 and Windows 98. Which file system should you use?

A) FAT B) NTFS
C) HPFS D) You can use either FAT or NTFS
 
Answer & Explanation Answer: A) FAT

Explanation:

If you want your computer to dual boot between Windows 2000 and windows 98, you should choose the FAT or FAT 32 file system, because Windows 98 does not support NTFS or HPFS, and Windows 2000 does not support HPFS.

Report Error

View Answer Report Error Discuss

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

0 3117
Q:

Your network consists of one Active Directory domain. You have two computers named Computer1 and Computer2 that run Windows 7. Both computers are members of the domain.


From Computer1, you can recover all Encrypting File System (EFS) encrypted files for users in the domain.


You need to ensure that you can recover all EFS encrypted files from Computer2. What should you do?

A) On Computer1, back up %systemroot%\DigitalLocker. On Computer2, restore %systemroot%\DigitalLocker. B) On Computer1, export the data recovery agent certificate. On Computer2, import the data recovery agent certificate.
C) On Computer1, run Secedit.exe and specify the /export parameter. On Computer2, run Secedit.exe and specify the /import parameter. D) On Computer1, run Cipher.exe and specify the /removeuser parameter. On Computer2, run Cipher.exe and specify the /adduser parameter.
 
Answer & Explanation Answer: B) On Computer1, export the data recovery agent certificate. On Computer2, import the data recovery agent certificate.

Explanation:
Report Error

View Answer Report Error Discuss

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

5 3088