Tag Archives: mcitp online exams

MCITP, mcitp certification, MCITP Training, MCSE, MCSE Certification, MCSE Training, MCTS, MCTS Certification, MCTS Training, Microsoft, Tech

Microsoft 70-454 Q & A / Study Guide

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 

 

QUESTION 1
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to develop database strategies.
You are in the process of developing a strategy that has three tables named Certkingdom1, Certkingdom2, and
Certkingdom3. The Certkingdom1 and Certkingdom2 have the integer and varchar data type column types configured
respectively. Certkingdom3 has both the integer and varchar data types configured as column types.
You have configured rowlevel compression on Certkingdom1, and page-level compression on Certkingdom2 and Certkingdom3.
Which of the following describes the reason for this configuration?

A. It allows for the reduction of disk space usage, while modifying the data types in the tables of the database
B. It allows for the reduction of disk space usage without modifying the data types in the tables of the database
C. It allows for the increase of disk space usage, while modifying the data types in the tables of the database
D. It allows for the increase of disk space usage, while modifying the data types in the tables of the database

Answer: B

Explanation:

QUESTION 2
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a database strategy that includes a table which hosts
data imported from an outside source. This data includes a field named TransactionTime that
should be configured to make use of hh:mm:ss[.n] format.
You have been informed that the data type selected for the TransactionTime field must allow for
storage to be kept to a minimum.
You, therefore, make use of the time(1) data type.
Which of the following is TRUE with regards to the time data type?

A. The default fractional precision is 7 (100ns).
B. The default fractional precision is 3 (100ns).
C. The time produced by the time data type is not time zone aware and is based on a 24-hour clock.
D. The time produced by the time data type is time zone aware and is based on a 12-hour clock.

Answer: A,D

Explanation:

QUESTION 3
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that has two tables named CertkingdomVendor and
CertkingdomItem. You have configured a foreign key constraint between the CertkingdomVendor and CertkingdomItem
tables on the CertkingdomVendorID column.
You have configured the CertkingdomVendor table to display a 0 value for the CertkingdomVendorID when a
vendor is removed. You also want make sure that the CertkingdomVendorID value in the CertkingdomItem table is
set to 0 when a vendor is removed.
You then create a default constraint on the CertkingdomVendorID column in the CertkingdomItem table, which is
used to set the value to 0.
Which of the following actions should you take NEXT?

A. You should consider setting the ON DELETE property of the foreign key constraint to Null.
B. You should consider setting the ON DELETE property of the foreign key constraint to Default.
C. You should consider setting the ON DELETE property of the foreign key constraint to Cascade.
D. You should consider setting the ON DELETE property of the foreign key constraint to No Action.

Answer: B

Explanation:

QUESTION 4
You are employed as a database developer at Certkingdom.com. You make use of a SQL Server 2008
instance to develop database strategies.
You are in the process of designing a database strategy that makes use of the Integration
Services and Microsoft Sync Framework SQL Server components.
Which of the following is TRUE with regards to the use of these components?

A. Microsoft Sync Framework allows for collaboration and offline access for applications, services, and devices.
B. Microsoft Sync Framework prevents collaboration and offline access for applications, services, and devices.
C. Integration Services allows for the merging of data from Heterogeneous Data Stores.
D. Integration Services prevents the merging of data from Heterogeneous Data Stores.

Answer: A,C

Explanation:

QUESTION 5
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that helps Certkingdom.com’s administration manager.
You have created three entities named User, UserTask, and UserAssignment. You have
configured the User entity to make use of the UserID attribute, the UserTask entity to make use of
the UserTaskID attribute, and the UserAssignment entity to make use of the UserAssignmentID attribute.
You have been informed that the strategy must allow for users to be assigned multiple tasks. You
also need to ensure that a task is deleted when it has been completed, and that the assignment
linked to that task is also deleted. Furthermore, a NULL value has to replace the user reference to
the user assignment as soon as a user becomes unavailable to finish a task.
Which combination of the following actions should you take? (Choose all that apply.)

A. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserAssignment entity.
B. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserTask and User entities respectively.
C. You should consider referencing the UserTask and User entities respectively.
D. You should consider referencing the UserAssignment and User entities respectively.
E. You should consider specifying the On Delete property as NULL.
F. You should consider specifying the On Delete property as Default.

Answer: A,C,E

Explanation:

 

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

MCITP, mcitp certification, MCITP Training, MCSE, MCSE Certification, MCSE Training, MCTS, MCTS Certification, MCTS Training, Tech

Microsoft 70-236 Q & A / Study Guide

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 

QUESTION 1
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 infrastructure.
The network contains a mailbox named TestResources. At present all users are able to diarize
appointments for TestResources. A new company policy states that only Kara Lang and Mia
Hamm are permitted to diarize appointments for TestResources.
What actions must you take to comply with the Certkingdom.com policy?

A. You should run the following cmdlet:
Set- MailboxCalendarSettings – Identity”TestResources” – MonthCalendar calendar = new
MonthCalendar(); KaraLang , MiaHamm.
B. You should run the following cmdlet:
Set-MailboxCalendarSettings – Identity ” TestResources” – BookInPolicy KaraLang , MiaHamm –
AllBookInPolicy $false cmdlet.
C. You should run the following cmdlet:
Set – MonthCalendar calendar = new MonthCalendar(); “host.KaraLang , MiaHamm = calendar ”
this.Content = host;.
D. You should run the following cmdlet:
Set – MonthCalendar calendar = new MonthCalendar();
HwndSource source = HwndSource.FromHwnd(calendar.Handle);
this.Content = calendar;Delegates KaraLang , MiaHamm.

Answer: B

Explanation:

QUESTION 2
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. Certkingdom.com has headquarters in London and branch offices in Paris and
Berlin. The marketing department is located at the Paris office. The personnel in Paris connect to
the network through the Internet and use Outlook Anywhere on their laptops. To ensure
productivity management wants you to make sure that the marketing personnel have access to the
companies’ mailboxes.
What actions must you take?

A. You should utilize the Test- MAPIConnectivity and the Test- WebServicesConnectivity cmdlet.
B. You should utilize Get- Recipient – Filter cmdlet.
C. You should utilize Show-MailboxStatistics cmdlet.
D. You should utilize List-Mailbox cmdlet.

Answer: A

Explanation:

QUESTION 3
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. The Certkingdom.com network has an Exchange Server 2007 environment.
The Edge Transport Server role is installed on a server named Certkingdom-EX01. Due to this server
failure, you have decided to install a new Microsoft Windows Server 2003 server named CertkingdomEX03
on the network with the reinstallation of the Edge Transport Server role. However, the
address rewrites that was functional on Certkingdom-EX01 did not in operation on Certkingdom-EX03. This
functionality is needed.
What actions must you take?

A. You should use the ImportEdgeConfig.ps1 on Certkingdom-EX03.
B. You should use the iiscnfg/enable: application name check version.
C. You should use the Transaction Logs for sp_configure configuration.
D. You should use create a new Send connector on Certkingdom-EX03.

Answer: A

Explanation:

QUESTION 4
You work as the Exchange administrator at Certkingdom.com. Certkingdom.com has headquarters in London and
a branch office in Paris. The Exchange Server 2007 server in the London office is named CertkingdomEX07
and the Exchange Server 2003 server in the London office is named Certkingdom-EX08. You need
to transfer the mailbox from Certkingdom-EX07 to Certkingdom-EX08.
What actions must you take?

A. You should include the IgnoreRuleLimitErrors parameter when using the Move-Mailbox cmdlet.
B. You should use the System configuration data collector.
C. You should create a mapping schema definition.
D. You should enable the Windows Remote Management (WinRM).

Answer: A

Explanation:

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 

QUESTION 5
You work as the Exchange administrator at Certkingdom.com. Certkingdom.com has its headquarters in Chicago
and a branch office in Dallas. You are implementing a new Exchange Server 2007 Organization.
The Exchange Server 2007 environment of Certkingdom.com has the following server installed:
• An Edge Transport server named Certkingdom-EX01
• A Hub Transport server named Certkingdom-EX02.
During the course of the day you have received instruction from the CIO to have e-mail routing
configured on Certkingdom-EX01 and Certkingdom-EX02. In your solution you need to ensure that Certkingdom-EX01 is
able to transmit e-mail messages to and from the Internet. You should also ensure that Internet email
is sent to Certkingdom-EX01 via Certkingdom-EX02.
What actions must you take?

A. You should use the Microsoft System Center Configuration Manager (SCCM).
B. You should export a new Edge Subscription file to Certkingdom-EX01 and Import the Edge Subscription
file to Certkingdom-EX02.
C. You should use the Microsoft System Center Operations Manager (SCOM).
D. You should use the Microsoft Exchange Internet Message Access Protocol, Version 4 (IMAP4).

Answer: B

Explanation:

QUESTION 6
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
You were compelled to restore the directory objects and settings from a backup. However, after
the restoration a number of employees reported that they are unable to access their mailboxes
that were assigned to them before the backup was made. The employees need to access their
mailboxes.
What actions must you take?

A. You should use the Get-Mailbox cmdlet.
B. You should use the Get-MailboxInformation cmdlet.
C. You should use the Connect-Mailbox cmdlet.
D. You should use the Show-Information cmdlet.

Answer: C

Explanation:

QUESTION 7
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
During routine maintenance of the Exchange server you discover that the storage limits are all
different in the mailboxes.
What actions must you take to ensure that the storage limits to be the same?

A. You should use the Get-MailboxStatistics cmdlet and forward it to the Get-Mailbox cmdlet.
B. You should use the Show-MailboxStatistics cmdlet and forward it to the Select-Object cmdlet.
C. You should use the Get-MailboxInformation cmdlet and forward it to the Select-Object cmdlet.
D. You should create an Exchange Management Shell script and forward the Get-Mailbox
Database cmdlet output to the Set-Mailbox Database cmdlet.

Answer: D

Explanation:

QUESTION 8
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. The Certkingdom.com network contains a stand-alone server named CertkingdomSR09.
Your boss, CertKingdom, wants to know which Exchange Server 2007 server role can Certkingdom-SR09
support.
What would you reply?

A. It can support the Terminal Service Session Broker (TS Session Broker) role.
B. It can support the Edge Transport server role.
C. It can support the PDC emulator role.
D. It can support the Exchange Recipient Administrators role.

Answer: B

Explanation:

QUESTION 9
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 infrastructure that has two Client Access Servers with load balancing.
The employees on the intranet has 24/7 access to data when utilizing Outlook Anywhere. During
the course of the day you have received instruction from the CIO to ensure that the employees
who connect to the Exchange infrastructure via the IUnernet also have access to data 24/7.
What actions must you take?

A. You should enable the Microsoft Exchange Information Store.
B. You should enable the Microsoft Exchange Search Service.
C. You should set the external URL on every Client Access Server.
D. You should enable the Microsoft Exchange File Distribution service.

Answer: C

Explanation:

QUESTION 10
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
You have received several complaints from employees in various departments stating that e-mail
messages are ending up in their Junk E-mail folder even though the sender’s e-mail address is on
their Safe Senders List. You need to ensure that the employees’ Safe Senders Lists are used.
What actions must you take?

A. You should modify the SMTP Send connectors.
B. You should utilize the Get-Mailbox cmdlet.
C. You should utilize the Show-Information cmdlet.
D. You should utilize the Update-SafeList cmdlet on each mailbox.

Answer: D

Explanation:

MCITP, mcitp certification, MCITP Training, MCSE, MCSE Certification, MCSE Training, MCTS, MCTS Certification, MCTS Training, Microsoft, Tech

Free Microsoft 70-291 Q & A / Study Guide – part III

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 

 

 

QUESTION 704:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com consists of a file server named Certkingdom -SR40 that runs Windows
Server 2003. Certkingdom.com also contains crucial third-party applications, which
must be accessed by all the finance users of the main office and the branch offices.
You have received instruction to create a procedures document for Certkingdom.com
administrators. You need to define the recommended settings for each system
service that can be enables on a Windows Server2003 system. In a case of
emergency the service should be automatically restarted, if it fails more than three
times. You also setup the service to send a message to your computer if the service
failed. In the Property dialog box of a service has a number of Services consoles.
What could the services be?

A. The number of hours after which the fail account should be reset to zero.
B. Whether or not the Recovery attempt should be recorded in the System event log.
C. The number of minutes to wait before the service is restarted.
D. Whether or not the complete memory dump should be saved when the computer is
restarted.

Answer: C

Explaination: The Recovery tab of the Properties dialog box has the option to the
number of minutes to wait before the service is restarted.
Incorrect Answers:
A, B, D: You cannot configure the number of hours after which the fail account should
be reset to zero; or the whether or not the complete memory dump should be saved when
the computer is restarted, or whether or not the Recovery attempt should be recorded in
the System event log.

QUESTION 705:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com consists of a Marketing department. This department handles all the
financing and sales deeds. A Certkingdom.com user named Mia Hammis a member of
the Marketing department. Mia Hamm works on a client computer named
Certkingdom -SR30. One morning Mia Hamm complains that her hard disk has
failed. During the maintenance you then replace the hard disk and perform an
Automatic System Recovery (ASR) from a backup of her client computer.
Mia Hamm informs you that she still cannot connect to the domain. However, she is
able to connect to the domain from a coworker’s client computer. You receive an
instruction from the CIO to make sure that Mia Hammis able to connect to the
domain with Certkingdom -SR30 in order for her to do her duties.
What should you do?

A. Your first step should be to remove Certkingdom -SR30 from the domain.
Thereafter Certkingdom -SR30 can be rejoined to the domain.
B. To ensure that the user can log on to the domain the user account needs to be added to
the Administrators group on Certkingdom -SR30.
C. You should reset the computer account of Mia Hamm in Active Directory and
Computers to ensure that she will be able to log on to the domain.
D. Your best option would be to add the user account of Mia Hamm to the Power Users
group on Certkingdom -SR30.

Answer: A

Explaination: It is most probably the case that her password has expired. You need
to join the domain with Certkingdom -SR30. Doing this will allow the domain to
authenticate the computer. The password on the domain is regenerated
automatically when the computer rejoins the domain.
Incorrect Answers:
B, D: Mia Hamm does not belong either to the Administrators group or the Power Users
group. You cannot even access the computer with your user account as the administrator.
C: This method will not work properly. You should not reset computer accounts in the
Active Directory and Computers.

QUESTION 706:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com consists of two departments, named Research and Development. Half
of the client computers are in the Research department and the other half are in the
Development department. The Research department is a priority for Certkingdom.com
The client computers in the Research department run critical third-party
applications.
Certkingdom.com contains a server named Certkingdom -SR12 which hosts shared
folders named TestResDev for the Research department and Development
department. The users in the Research department and Development department
save their projects in Certkingdom -SR12 in TestResDev. The users are also allowed
to change the files or to undo the changes. To safeguard the files you implement
Shadow Copies support. Some of the users in both department complains that they
cannot access pervious version of there files. You need to ensure that the previous
versions are available to the users.
What should you do?

A. On all the client computers, enable Shadow Copies.
B. On all the client computers, install the Previous Versions client software.
C. On Certkingdom -SR12 configure disk quotas for all users.
D. On all the client computers, enable disk quotas.

Answer: B

Explaination: Shadow Copies provides periodic snapshots of shared folders on
specific volumes on hard disks.
Incorrect Answers:
A: You cannot do this, because the server side of this feature is not supported by the
client computers.
C, D: Disk quotas are used to limit the amount of disk space. This this not needed in this
scenario.

QUESTION 707:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com contains a Finance department. This department handles all the
marketing and sales deeds. It was requested of you to periodically perform
Automatic System Recovery (ASR) backups of all the servers in Certkingdom.com A
Certkingdom.com user named Andy Reid is a member of the Finance department.
Andy Reid works on a client computer named Certkingdom -SR10 which is
configured as a Certification Authority (CA). Certkingdom -SR10 contains two hard
drives, one hard drive named drive C consists of the operating system, and the other
hard drive named D consist of the CA database. The drive D of Certkingdom -SR10
failed and the CA database was lost.
During the maintenance you replaced the hard drive. You now need to replace the
lost data with the minimum of administrative effort. You receive an instruction
from the CIO to make sure that Certkingdom -SR10 continues to operate as a CA.
What should you do on Certkingdom -SR10?

A. To ensure that Certkingdom -SR10 continues to operate you need to boot from the
Windows Server 2003 installation CD.
Thereafter you can restore the ASR restore.
B. Your best option is to restart Certkingdom -SR10 in Directory Services Restore Mode.
Thereafter you can execute a non-authoritative restore of the CA database.
C. Your first step should be to restart Certkingdom -SR10 in Directory Services Restore
Mode.
Then you can execute an authoritative restore of the CA database.
D. Your best option would be to restore System State from the most recent ASR backup.

Answer: D

Explaination: This is a collection of files (System State) that contains the information
that is needed to rebuild an identical copy of the computer.
Incorrect Answers:
A: It is no need to ASR because the drive C which contains the operating system is not
damage.
B, C: You cannot start Certkingdom -SR10 in Directory Services Restore Mode, because it is
not a domain controller.

QUESTION 708:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all user
workstations run Windows XP Professional.
Certkingdom.com contains a Research department. The Research department is a
priority for Certkingdom.com The user workstations in the Research department run
critical third-party applications. The Research department is planning to open a
new technical line. The manager will use this line to alter any changes of the
complete product of the Research department. This will lead to frequent changes of
the related documents. The manager also needs the previous versions of the
products if it was changed.
Certkingdom.com contains a server named Certkingdom -SR21. Certkingdom -SR21
consists of three disks which host lots of shared folders. You are planning to host the
documentation of the technical lines share folder on this server. You receive an
instruction from the CIO to ensure that your answer does not entail the
maintenance the earlier versions of any other data only the documentation of the
new technical line.
What should you do?

A. To comply with the requirements of the CIO you need to allow shadow copies on the
user workstations.
B. Periodical backups need to be executed in order to comply with the requirements.
C. Your best option would be to create a share folder on a new volume on
Certkingdom -SR21 as well as enabling shadow copies.
D. The Previous Versions software needs to be deployed on Certkingdom -SR21 in order
to comply with the instruction of the CIO.

Answer: C

Explaination: Shadow Copies provides periodic snapshots of shared folders on
specific volumes on hard disks.
Incorrect Answers:
A: The user workstations run Windows XP Professional, shadow copies is new and
resides in Windows Server 2003.
B: You should perform periodic backups of all documentation. However these backup
would not be available immediately.
D: The Previous Versions software should be deployed on the user workstations not the
server.

QUESTION 709:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com contains a server named Certkingdom -SR44 which runs Exchange
2003. Certkingdom -SR44 also consists of proprietary financing applications. All the
Certkingdom.com users access their mail from this server. Certkingdom -SR44 is
configured with a 2.6 MHz CPU, 512 MB of RAM and two 74.5 GB hard disks.
Certkingdom -SR44 is connected to a LAN at 100 Mbps with a network adapter.
Certkingdom -SR44 supports 4,000 user mailboxes. Certkingdom -SR44 is continuously
used as users access their mail. A Certkingdom.com manager named Andy Booth
complains that his users struggle to open large e-mail messages, due to the slow
response of the server. You make use of System Monitor to view the results.


You receive an instruction from the CIO to identify the reason for the new response.
Which component should you identify?

A. A possible reason for the slow response time is the Network Adapter
B. The Processor is the possible cause for the slow response time.
C. The component causing the slow response is the Hard disk
D. The slow response time of the server is caused by the Memory.

Answer: D

Explaination: The memory reports an average of only 20 MB available. The value
should remain 5 % of the total system memory.
Incorrect Answers:
A, B: These counters do not indicate a cause of a bottleneck.
C: The hard disks are very busy. It should remain below 50 %. You should first check the
memory before you identify the hard disk as the source of the bottleneck.

QUESTION 710:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com has its headquarters in Chicago and a branch office in Miami.
Certkingdom.com contains a server named Certkingdom -SR33 which is configured as a
router. A new Certkingdom.com security policy restricts the use of streaming audio to
some of the users. Certkingdom.com consists of a Sales department in the branch office.
The managers in the branch office complain about the slow network response.
During an investigation you find that some users are controlling the available
bandwidth. You need to find out if the users are violating the Certkingdom.com security
policy. You also need to find out which users did receive those packets.
Which utility should you use?

A. You should make use of the Network Monitor utility to identify the users who violates
the security policy.
B. The IP Security Monitor should be used to identify the users who violaste the security
policy.
C. In order for you to determine which users violates the policy you need to make use of
the Replication Monitor utility.
D. You should consider making use of the System Monitor utility to determine which
users are at default.

Answer: A

Explaination: To capture network traffic, the System Monitor is used. You can filter
it so that it can meet the criteria that you are looking for.
Incorrect Answers:
B: The IP Security Monitor is used to monitor IPSec information. You cannot use it to
monitor network traffic.
C: This is used to monitor Active Directory replication.
D: The System Monitor is used to gather information about the CPU, Memory etc.

QUESTION 711:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com The
Certkingdom.com network contains ten Windows Server 2003 computers and 1,100
Windows 2000 Professional computers. Three of the Windows Server 2003
computers in configured as domain controllers.
Certkingdom.com has a Finance department in Chicago and a Marketing department in
Dallas. These departments are connected to the Internet. The users in these
departments use the network often to send and download important files and
Internet e-mail. The Certkingdom.com users also access the Internet to get the latest
information on the product. A new Certkingdom.com security policy requires that
network administrators should use their domain user account to log on. Whenever
the administrators need an administrative privilege, they should use the runas
command. The runas command will launch an application that will allow
permission to execute the required task.
One morning an administrator named Rory Allen complains that the name
resolution has failed on the network. During an investigation you try to run Rory
Allen administrative user account, RMAdmin1 and issue the following command:
runas/user:rmadmin1 replmon. When you use this command the following error
message was displayed:
RUNAS ERROR: Unable to run – replmon
1058: The service cannot be started, either because it is disabled or there are no
enabled devices associated with it. You receive an instruction from the CIO to
identify the service that stops the Replication Monitor from starting.
Which of the following services could it be?

A. Due to DNS Client failure you are unable to start Replication Monitor.
B. The Secondary Logon is the likely cause of you being unable to start Replication
Monitor.
C. The DNS Server is the cause of Replication Monitor not starting.
D. Net Logon is a possible cause of the Replication Monitor not starting.

Answer: B

Explaination: The Secondary Logon permits a user to make use of the runas
command.
Incorrect Answers:
A: The DNS Client allows you to locate Active Directory domain controllers. It also
resolves DNS names locally.
C: The DNS Server service is responsible name resolution queries from DNS clients.
D: This service is responsible for authentication remote users and services.

QUESTION 712:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com
Certkingdom.com consists of a few servers that run Windows Server 2003 and Windows
2000 Server. Some the client computers run Windows 2000 Professional, and the
others run Windows XP Professional.
Certkingdom.com contains 15 Domain controllers, 25 Windows Server 2003 servers, 15
Windows 2000 Server computers, 150 Windows XP Professional client computers
and 300 Windows 2000 Professional client computers. The Certkingdom.com domain
also contains 600 user accounts and 15 administrative accounts. The user and
computer accounts reside in an OU which is linked to a GPO as shown in the
following table:


Certkingdom.com’s user accounts resides in an OU named Certkingdom OU. This OU needs
an application named TKD_Tools which is in a Windows package named
TKD_Tools.msi. The hard disk space for TKD_Tools is 50MB. A Certkingdom.com policy
states that the TKD_Tools.msi should not be installed on a client computer that runs
Windows XP Professional or a server that runs Windows Server 2003 which has less
than 500 MB of hard disk space. Only users that are non administrative are allow to
install this TKD_Tools application. You have received an instruction from the CIO to
configure the domain to effectively install the application. You need to accomplish
this without the unnecessary installation of this application.
What should you do?

A. Your first step should be to add TKD_Tools.msi to the Computer
Configuration\Software Settings node of the MemberServers GPO.
Thereafter you will be able to create a WMI filter that will restrict the application of the
MemberServers GPO to computers with 500 MB and more hard disk space.
B. You can accomplish this by adding TKD_Tools.msi to the Computer
Configuration\Software Settings node of the WinClients GPO.
The subsequent step would be to create a WMI filter that will restrict the application of
the WinClients GPO to computers with 500 MB and more hard disk space.
C. This can bew accomplished by adding TKD_Tools.msi to the Computer
Configuration\Software Settings node of the AdminPolicy GPO.
Thereafter you can create a WMI filter that restricts the application of the
DomainControllers GPO to computers with 500 MB and more hard disk space.
D. Your best option would be to add TKD_Tools.msi to the Computer
Configuration\Software Settings node of the UserPolicy GPO.
Thereafter you can create a WMI filter that restricts the application of the UserPolicy
GPO to computers with 500 MB and more hard disk space.

Answer: D

Explaination: This is the more likely answer, because only the non-administrative
users can have this application installed. That’s way you should add the
TKD_Tools.msi to the UserPolicy GPO.
Incorrect Answers:
A: The MemberServers GPO will only apply to the Windows Server 2003 and Windows
2000 Server computers.
B: The WinClients GPO will only apply to the Windows 2000 Professional and the
Windows XP Professional client computers.
C: The AdminPolicy is users who are administrators. The scenario does not want the
administrator to have this application.

QUESTION 713:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
A Certkingdom.com client named Rory Allen installs a high-speed color printer named
Certkingdom -PR01 on a print server named Certkingdom -SR24 by using a built-in
Windows XP Professional driver. Rory Allen works in the Graphics department. He
shares the printer so that the other users can print to the new printer.
During the day the users of the Graphics department complain that they cannot
print from Certkingdom -PR01. You then make sure that Certkingdom -SR24 is
working properly and the printer is switched on. During the investigation you access
the shared folders on Certkingdom -SR24. However, it seems that Certkingdom -PR01
is unable to connect. You have to make sure that the users in the graphics
department can access Certkingdom -PR01 for there printing jobs.
What should you do?

A. Your best choice would be to configure Certkingdom -PR01 to be available.
B. You should consider restarting the Print Spooler on Certkingdom -SR24 to ensure that
the users can print.
C. To ensure that the users can print to Certkingdom -PR01 you have to update the driver.
D. This can be accomplished by uincreasing the priority of Certkingdom -PR01.

Answer: B

Explaination: The function of the Print Spooler is to manage the print queues on a
server. In this case it seems that the Print Spooler has stalled. That’s way you have
to restart the Print Spooler service.
Incorrect Answers:
A: Even if this were available, you cannot access it because you cannot connect to the
Print Spooler.
C: There is no need to update the driver, because the printer was working before.
D: To increase the priority of Certkingdom -PR01, you need to access the Property sheet.
At the moment it seems impossible, because the Print Spooler is not working.

QUESTION 714:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows 2000 Server and all client
computers run Windows XP Professional.
Certkingdom.com contains two departments, named Research and Marketing. Half of
the client computers are in the Research department and the other half are in the
Marketing department. The client computers in the Research department run
critical third-party applications.
Andy Reid is the manager of the Research department. He complains about the
poor performance of certain critical third-party applications on his client computer
named Certkingdom -WS211. You have been instructed to collect the performance
information that can be used to determine and analyze the technical problems on
the network.
Which tool can you use?

A. You should make use of Network Monitor in order to determine and analyze the
technical errors.
B. The technical errors can be determined and analysed by making use of System
Monitor.
C. You will be able to make use of Task Manager to collect the performance information.
D. You should consider making use of a counter log to determine and analyse the
technical errors.

Answer: D

Explaination: You should create a performance baseline and monitor the values of
the counters. The performance data should be recorded in a counter log.
Incorrect Answers:
A: This tool is used to parse network traffic.
B: The System Monitor can work, however it only presents current performance ion real time.
C: This is used to view information about the processors that are running on the system.

QUESTION 715:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows 2000 Server and all client
computers run Windows XP Professional.
Certkingdom.com contains two departments, named Research and Marketing. Half of
the client computers are in the Research department and the other half are in the
Marketing department. Due to the success of the two departments, Certkingdom.com
has decided to implement an e-commerce Web site, which will be used as a public
Web site for customers and a private Web site for the users.
Certkingdom.com then opens a new office for this new Web site. This office contains a
Windows Server 2003 server named Certkingdom -SR42. You intend to run a
third-party Web management application. You receive an instruction to make sure
that the suitable services are allowed on this server.
What should you do? (Select two)

A. You should consider enabling the World Wide Web Publishing Service.
B. Your best option would be to allow the DNS Server service.
C. To support the Web site you need enable the IIS Admin Service.
D. To make sure that the suitable services are allowed you need to permit the https: SSL
service.

Answer: A, D

Explaination: The https: SSL will provide the private part of the Web site and the
World Wide Web Publishing Service will provide for the public portion.
Incorrect Answers:
B: This option will offer name resolution. This will not ensure that the Web site is
available.
C: This is only needed if you use an IIS to manage the Web site. However you have a
third-party Web management application.

QUESTION 716:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com
Certkingdom.com contains 15 Windows Server 2003, 5 domain controllers and 2000
client computers which runs Windows XP Professional.
Certkingdom.com contains a Marketing department and a Finance department. A
Certkingdom.com server runs mission critical in-house applications which is used by the
users. The client computers and the domain controllers’ clock are incorrect. You
need the time to be correct other wise the Kerberos fails and you will find Kerberos
errors in the event log. You reset the clock of the client computer, but after a while
you find that the clock is again wrong. You receive an instruction from management
to make sure that the clock of the client computers displays the correct time.
What should you do?

A. To ensure that the clock displays the correct time you need to adjust the clock on the
infrastructure master.
B. To ensure that the correct time is displayed you need to select Automatically
synchronize with Internet time server on the Internet Time tab.
C. You can ensure the correct time by installing an exact time resource tool on the
network.
D. Your best option should be to adjust the clock on the PDC emulator.

Answer: D

Explaination: You should adjust the PDC emulator, because all the computers will
synchronize there clock.
Incorrect Answers:
A, B, C: In this scenario you should adjust the clock with the PDC emulator, for
authentication in an Active Directory environment.

QUESTION 717:

You work as the network administrator at Certkingdom.com The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com All
servers on the Certkingdom.com network run Windows Server 2003 and all client
computers run Windows XP Professional.
Certkingdom.com contains two departments named Research and Development. Half of
the client computers are in the Research department and the other half are in the
Development department. The client computers in the Research department run
critical third-party applications.
Certkingdom.com contains a file server named Certkingdom -SR14. Shadow copies area
enabled on the volume named BillVol. During routine monitoring you discover
that BillVol has almost reached its capacity. You take action and add another disk
to the server and create a volume named TestVol. You now need to configure
shadow copies for BillVol to use the space in TestVol.
What should you do?

A. Your best choice would be to specify TestVol as the additional location on the
BillVol properties.
B. This can be accomplished by moving the shadow copies from BillVol to TestVol on
the Certkingdom -SR14.
C. You should consider sharing TestVol.
Thereafter you will be allowed to enable shadow copies on TestVol.
D. You should consider deleting the shadow copies of BillVol and specifying TestVol
as the location of shadow copies.

Answer: D

Explaination: This is the correct answer. You are unable to change the location of
the shadow copies unless you delete Vol1 of the exiting shadow copies.
Incorrect Answers:
A: You cannot share the shadow copies between BillVol and TestVol. You also cannot
move or copy files on BillVol.
B: You have to delete the shadow copies on BillVol. You cannot move the shadow
copies from BillVol to TestVol.
C: This will result in previous copies on BillVol to be periodically created. The exiting
copies on BillVol would not be affected.

 

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

MCITP, mcitp certification, MCITP Training, MCTS, MCTS Certification, Tech

Free 70-669 Exam Q & A / Study Guide

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 

 

 

QUESTION 1
You work as a desktop technician at Certkingdom.com. The Certkingdom.com network consists of an Active
Directory Domain Services domain named Certkingdom.com. All servers on the network run Windows
Server 2008. The client computers run a mix of Windows XP Professional and Windows 7 Enterprise.
The company is planning to roll out Windows 7 Enterprise throughout the network. Users that
require legacy applications will be able to run them in Windows XP Mode virtual machines on their computers.
You are conducting some testing with Windows XP Mode virtual machines (VMs). You have two
Windows XP Mode VMs on your Windows 7 client computer.
You want to configure the networking options for the two VMs so that they have network
connectivity to each other but not to your host computer or the rest of the Certkingdom.com network.
How should you configure the VMs?

A. You should navigate to the Networking node in the VM Settings and configure the network
adapter to use the Internal Network option.
B. You should navigate to the Networking node in the VM Settings and configure the network
adapter to use the Shared Networking (NAT) option.
C. You should navigate to the Networking node in the VM Settings and configure the network
adapter to use the Bridge Mode option.
D. You should configure the Bridge Connections option in the Network Adapter properties in
Windows XP on each VM.

Answer: A

Explanation:

QUESTION 2
You work as a desktop technician at Certkingdom.com. The Certkingdom.com network consists of an Active
Directory Domain Services domain named Certkingdom.com. All servers on the network run Windows
Server 2008 R2 and all client computers run Windows 7 Enterprise.
The network includes a Windows Server 2008 R2 server named ABC-Deploy1. ABC-Deploy1 runs
the IIS Server role and is part of the company’s Microsoft Enterprise Desktop Virtualization (MEDV) environment.
Your Windows 7 client computer is named ABC-Tech1. The MED-V Management console is
installed on ABC-Tech1.
You are configuring the Microsoft Enterprise Desktop Virtualization (MED-V) environment to
deploy MED-V virtual machines to several client computers.
You have configured a MED-V image with the required applications. You run Sysprep on the
image and upload it to ABC-Deploy1.
Which two of the following steps will ensure that computer names following a specified naming
convention are generated when the VMs are first run after the deployment? Choose two.

A. In the Workspace settings, navigate to the VM Setup tab and configure the computer name pattern.
B. In the Workspace settings, navigate to the Deployment tab and configure the computer name pattern.
C. Add a Script Action to rename the computer.
D. Run the Setup Manager Wizard and configure the computer name pattern.
E. Add the computer names to Sysprep.inf.

Answer: A,C

Explanation:

QUESTION 3
You work as a desktop technician at Certkingdom.com. The Certkingdom.com network consists of an Active
Directory Domain Services domain named Certkingdom.com. All servers on the network run Windows
Server 2008 R2 and all client computers run Windows 7 Enterprise.
You are in the process of configuring a Microsoft Enterprise Desktop Virtualization (MED-V) environment.
You need to configure a central image repository for client computers to download images from.
You install a Windows Server 2008 R2 member server named ABC-Deploy1. You create a folder
named MEDVImages on ABC-Deploy1.
What should you do next on ABC-Deploy1?

A. You should share the MEDVImages folder.
B. You should install the IIS Server role and configure a virtual directory to point to the MEDVImages folder.
C. You should install the FTP Server component of IIS and configure an FTP site to point to the MEDVImages folder.
D. You should install an SSL Certificate.

Answer: B

Explanation:

QUESTION 4
You work as a network administrator at Certkingdom.com. The Certkingdom.com network consists of an Active
Directory Domain Services domain named Certkingdom.com. All servers on the network run Windows
Server 2008 R2 and all client computers run Windows 7 Enterprise.
Certkingdom.com runs a Microsoft Enterprise Desktop Virtualization (MED-V) environment. A Windows
Server 2008 R2 member server named ABC-Deploy1 is configured to run Microsoft Enterprise
Desktop Virtualization (MED-V) Server and hosts the central MED-V image repository.
You notice that the disk space on ABC-Deploy1 is running low due to the MEDVImages folder
taking up a large amount of disk space.
You open the MED-V Management Console and note that there are several versions of the MEDV
Workspace virtual machines (VMs).
How can you minimize the disk space used by the MEDVImages folder?

A. By deselecting the “Workspace is persistent” option.
B. By configuring the image update settings to keep a limited number of images.
C. By configuring the image update settings to select the “Clients should use the Download
manager when downloading the images” option.
D. By manually deleting old image files.

Answer: B

Explanation:

QUESTION 5
You work as a network administrator at Certkingdom.com. The Certkingdom.com network consists of an Active
Directory Domain Services domain named Certkingdom.com. All servers on the network run Windows
Server 2008. The client computers run a mix of Windows XP Professional and Windows 7 Enterprise.
You are in the process of migrating the Windows XP Professional client computers to Windows 7 Enterprise.
You need to design a solution to resolve application compatibility issues. You are planning a
desktop virtualization solution that will run legacy applications on virtual machines (VMs) running
Windows XP Professional.
You want to deploy Windows Virtual PC 2007 and a virtual machine image to the client computers
when they are migrated to Windows 7 Enterprise.
How can you create a single installation package that includes both Windows Virtual PC 2007 and
a virtual machine image?

A. By using the Packaging Wizard from Microsoft Enterprise Desktop Virtualization (MED-V).
B. By using Package Manager (pkrmgr.exe) from the Windows Automated Installation Kit (WAIK) tools.
C. By using a template created using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2.
D. By using Windows System Image Manager from the Windows Automated Installation Kit (WAIK) tools.

Answer: A

Explanation:

 

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

Uncategorized

Different Microsoft Certifications for Programmers and Developers

Leave a comment

If a business does not have the right IT team, then they may soon have some serious problems, that is why the Microsoft Certifications are so important to potential employers. The new generation of Microsoft certifications provides a simpler and more targeted framework for IT managers to validate core technical skills, professional skills, advanced skills, and architectural skills. It also provides professionals in the IT industry with a more relevant, flexible, and cost-effective way to showcase their skills.Technology: Prove core technical skills on Microsoft technologiesThe new Technology certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in the broad range of specialized technologies. Microsoft Technology Specialists are consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology.Microsoft Certified Technology Specialist (MCTS) CertificationsProfessional: Professional skills and a proven ability to perform on the jobProfessional Series credentials validate a comprehensive set of skills required to be successful on the job. These skills include design, project management, operations management, and planning, and they are contextual to the job role. By validating a more comprehensive set of skills, these credentials give candidates and their hiring managers a reliable indicator of on-the-job performance.Microsoft Certified IT Professional (MCITP Training) Certification Microsoft Certified Professional Developer (MCPD) Certification The new Microsoft Certifications exams for .Net are the result of the Microsoft .Net Platform update to .Net Framework version 2.0. Microsoft has changed the way it certifies IT specialists, and most of the new certifications require the candidate to pass 2 Exams for MCTS instead of 1 Exam for MCP or 3 Exams for MCAD.Net (version 1.1) or 5 Exams for MCSD.Net (version 1.1), except for some like, SQL server 2005, and the BizTalk Server 2006 which only require one exam. The Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies. An MCTS is consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology.In the new Microsoft Certification program for .Net, there are specialty certifications for Windows based Application Development (MCTS- .Net Framework Windows Applications), Distributed Application Development (MCTS -. Net Framework Distributed Applications), and Web based Application Development (MCTS – .Net Framework Web Applications). After achieving MCTS Certification, if you would like to acquire more thorough knowledge and higher Certification, then you can also go for MCPD (Microsoft Certified Professional Developer) Certification for .Net, which requires the candidate to pass one more Exam on the Windows/Distributed/Web platform. After achieving MCTS-SQL Server 2005, you can either opt for MCITP Certification (Microsoft Certified IT Professional) as a Database Developer or Database Administrator. Each of these certifications (Developer/Administrator) requires the candidate to pass 2 more Exams.So, to a degree Microsoft is making it a bit more difficult to get certified, but this can be beneficial to you. First because what you will study to become certified will make you an expert in your field. And secondly, because Microsoft has determined, that IT hiring managers have a difficult time trying to figure out which computer certification best qualifies an IT professional. This new type of certification will help identify the right candidates for a specific are of development-e.g Windows, Distributed, or Web. The new type of certification can help you prove your job skills and prove your qualifications making it easier for hiring managers to make the right choice, based on qualification and not on personal likes and dislikes.

For more information on Microsoft .Net Certification Courses or ASP.Net Certification or MCITP Certification Courses, please visit the site or write.

MCITP, mcitp certification, MCITP Training

Get to know about Microsoft MCITP Certification

Leave a comment

Get to know about Microsoft MCITP Certification

The MCITP Certification or ‘Microsoft Certified Information Technology Professional’ certification is one of the leading technical certifications from Microsoft. This certification provides a more focused and convenient onlineframework for the IT professionals to showcase their technical expertise in any of their chosen field out of the twelve concentrations. This certification basically verifies a candidate’s understanding and the skill set he possess which are needed for jobs like Database admin or Enterprise messaging admin. One should be able to design, build and optimize the technologies in which he has got the specialization to be able to clear an MCITP certification. Professionals with MCITP credentials are fully capable of taking the necessary technical decisions in order to make successful technology execution projects.

Getting an MCITP certification implies and validates the fact that you are equipped with required knowledge and relevant experience in utilizing the products and solutions of Microsoft. This certification is an indispensable tool in your profile to give you an edge in today’s constantly changing IT marketplace. Moreover, it will provide you an opportunity to get connected with a huge global network of Microsoft certified professionals and also help in further fine tuning your skills in the domain in which you have the specialization. With an MCITP certification you can easily set yourself apart and highlight your subject of expertise which would make sure that you get the best of the job opportunities.

Few of the most popular concentrations out of the 12 concentration of this certification are Server Administrator, Business Intelligence Developer, Database Developer, Database Administrator, Enterprise Administrator, enterprise Project Management with Microsoft Office Project Server 2007 etc. One has enough options to choose from and become a specialist in any of those fields.

The preparation guides for MCITP certification and mcitp training are readily available nowadays and there are many good providers of the course materials. In addition to the study guides one should also keep in mind that training programs are equally important for this certification. So make sure you enroll yourself into one of those programs which are conducted by certified instructors of the industry who are experts in their respective fields.

Uncategorized

Mcitp Online Training Tips

Leave a comment

Mcitp Online Training Tips

The MCITP (Microsoft Certified IT Professional) is a worldwide recognized certification for the technical expertise and skills set for performing specialized functions in IT infrastructure and Microsoft computing platforms. The skills sets include administration, development, design and support for Microsoft server, database, infrastructure, technology and so on. As Microsoft servers and operatincomputer_girls-297x212g systems are widely employed around the world, there is a sizeable demand for their qualified technical professionals. There are various MCITP certifications for different IT groupings, such as Server, Database, Enterprise and Business Intelligence.

The MCITPs are named according to the groupings they are certified such as MCITP Database Developer, Database Administrator, Business Intelligence Developer, Consumer Support Technician, Enterprise Support Technician, Enterprise Administrator, Server Administrator and others. MCITP training courses are mapped according to the examinations in the different categories. Each certification requires the candidate to sit for a specified number of exams. MCSAs (Microsoft Certified System Administrators) and MCSEs (Microsoft Certified System Engineers) with Windows servers of earlier versions, are provided options of upgrading their certifications. MCITPs enjoy benefits such as access to MCP tools, online stores and worldwide career opportunities.

MCITP certification training is offered by many IT training centers in various packages. The MCITP training packages come with course ware; some training centers offer free practice tests and exam vouchers. MCITP training boot camps provide intensive training targeted at experienced students, aiming to prepare them fully for exams. The usual Windows server 2008 MCITP server administrator training takes 28 days and the Windows server 2008 MCITP enterprise administrator training package is a 45-day training. However in MCITP training boot camps, the courses are compressed to 8-12 and 21 days respectively. As such, boot camps are not recommended for newbies and those without working experience.

MCITP training methodology depends on the preference and schedules of the students. Many IT schools offer classroom courses led by certified instructors with hands-on lab training. There are also self study kits with MCITP training videos and online courses. These are often supported by workshops and tutorials, in which the students have access to hands-on training and discussion forums. Most certification courses also come with exam preparatory sessions which provide students with practice tests and tips on studying for exams.

Uncategorized

Microsoft Certified IT Professional: Database Administrator (MCITP DBA)

3 Comments

Microsoft Certified IT Professional: Database Administrator (MCITP DBA)

Demonstrate your ability to design, implement, and manage the pict-mcpd-brianadministration of Microsoft SQL Server 2000 databases successfully. The Microsoft Certified Database Administrator (MCDBA) credential shows customers and employers you can effectively lead their database administration programs, and provides you with the option to upgrade your credential to support Microsoft SQL Server 2005 as business needs dictate.

Overview

MCDBA candidate profile
The Microsoft Certified Database Administrator (MCDBA) credential is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server. This credential validates a unique set of skills that are required to succeed in a variety of job roles, such as database administrator, database analyst, and database developer. Candidates should have at least one year of experience working with Microsoft SQL Server.

* View MCDBA requirements

For individuals who administer, develop, or analyze Microsoft SQL Server 2005 or SQL Server 2008 databases, we offer Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional MCITP certification paths that reflect current job roles.

* Explore the MCTS certifications

* Learn about the MCITP Training credential

Additionally, a Microsoft Certified Master (MCM) certification is available for senior-level IT professionals who seek in-depth and comprehensive training on implementing database solutions by using Microsoft SQL Server 2008.

* Check out the MCM program

Why get certified?
Earning a Microsoft Certification validates your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today’s rapidly changing IT marketplace, Microsoft Certifications help you utilize evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

Whether you are new to technology, changing jobs, or a seasoned IT professional, becoming certified demonstrates to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

Certifications

To earn the Microsoft Certified Database Administrator (MCDBA) credential, you must pass four exams (in any order):

* One Microsoft SQL Server Administration exam
* One SQL Server Design exam
* One Microsoft Windows 2000 Server or Windows Server 2003 exam
* One elective exam

Note Many of the exams in this certification track are retired. If a required exam is retired and you have not yet passed that exam, you cannot complete the certification track. You must fulfill all listed requirements to earn the certification. If you passed a required exam before it retired, it can be applied toward certification. The credential will not expire.

Exams on SQL Server Administration: Choose one

Exam number
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-228

Administering Microsoft SQL Server 7.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification. This exam cannot be used to fulfill this requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.

Exam 70-028

Exams on SQL Server Design: Choose one

Exam number

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-229

Designing and Implementing Databases with Microsoft SQL Server 7.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification. This exam cannot be used to fulfill the SQL Server Design requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.

Exam 70-029

Exams on Windows 2000 Server or Windows Server 2003: Choose one

Exam number

Managing and Maintaining a Windows Server 2003 Environment

Exam 70-290

Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure

Exam 70-291

Installing, Configuring, and Administering Microsoft Windows 2000 Server

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-215

Elective exams: Choose one

Exam number

Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-216

Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Exam 70-293

TS: Microsoft .NET Framework 2.0 – Web-Based Client Development

Note Candidates who are MCAD-certified may substitute Exam 70-551 to satisfy this requirement. Candidates who are MCSD-certified may substitute Exam 70-553 to satisfy this requirement.

Exam 70-528

TS: Microsoft .NET Framework 2.0 – Windows-Based Client Development

Note Candidates who are MCAD-certified may substitute Exam 70-552 to satisfy this requirement. Candidates who are MCSD-certified may substitute Exam 70-553 to satisfy this requirement.

Exam 70-526

TS: Microsoft .NET Framework 2.0 – Distributed Application Development

Note Candidates who are MCSD-certified may substitute Exam 70-554 to satisfy this requirement.

Exam 70-529

Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-305

Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-306

Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-310

Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-315

Developing and Implementing Windows-Based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-316

Developing XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET Framework

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-320

Designing and Implementing Distributed Applications with Microsoft Visual C++ 6.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-015

Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification. This exam cannot be used to fulfill the elective requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.

Exam 70-019

Designing and Implementing Distributed Applications with Microsoft Visual FoxPro 6.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-155

Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-175

Upgrade Paths
Upgrade from MCDBA to MCTS on SQL Server 2005

As a Microsoft Certified Database Administrator (MCDBA), you have the option of upgrading your credential to reflect your Microsoft SQL Server 2005 expertise by earning a Microsoft Certified Technology Specialist (MCTS) credential.

Current certification

Certification goal

Required exam

MCDBA

MCTS on SQL Server 2005

Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance
Upgrade to MCITP Database Administrator

Once you have earned the MCTS credential by following the upgrade path described above, you have completed the prerequisite for the MCITP Database Administrator credential.

Current certification

Certification goal

Required exam

MCDBA

and

MCTS on SQL Server 2005

MCITP: Database Administrator

Exam 70-447: Upgrade: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005