UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 : 70-447 certified
Testking Product 70-447 Description：
Exam Number/Code: 70-447
Exam Name: UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
VUE Code: 70-447
Vendor: microsoft
Exam Language(s): English70-447 CSE
microsoft Sales Expert
On This Page
Exam news
Audience profile
Credit toward certification
Preparation tools and resources
Skills measured
Exam news
Are you upgrading from MCDBA certification?
• Visit the MCDBA to MCITP upgrade page for information
Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 became available in February 2006. This is a Microsoft Certified IT Professional (MCITP) Upgrade Exam for those who have obtained the MCDBA certification.
• This upgrade exam is available at 40 percent off retail price
Top of page
Audience profile
Candidates for this exam are professional database administrators who optimize and maintain database solutions. They have three or more years dedicated to database work, which may include two or more of the following phases in the product life cycle: design, development, deployment, optimization, maintenance, or support. The typical work environment is an enterprise or a medium-sized organization. Candidates should be experienced in using Microsoft SQL Server 2005. Candidates for this exam should be experts in the following areas:
• Defining high-availability solutions
• Automating administrative tasks
• Defining security solutions
• Monitoring and troubleshooting the database server
• Designing and executing deployments
• Defining the infrastructure (such as storage, hardware, and number of servers or instances)
Top of page
Credit toward certification
When you pass Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005, as well as obtain the prerequisite MCTS: SQL Server 2005, you complete the requirements for the following certification:
• Microsoft Certified IT Professional: Database Administrator
Top of page
Preparation tools and resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the “Skills measured” section.
Classroom training Microsoft E-Learning Microsoft Press books Practice tests
Course 2786: Designing a Microsoft SQL Server 2005 Infrastructure (two days)
Course 2787: Designing Security for Microsoft SQL Server 2005 (two days)
Course 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days)
Course 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (one day)
Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days)
Collection 2786: Designing a Microsoft SQL Server 2005 Infrastructure (14-hour series)
Collection 2787: Designing Security for Microsoft SQL Server 2005 (12-hour series)
Collection 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (16-hour series)
Collection 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (four-hour series)
Collection 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (12-hour series)
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 (ISBN: 9780735621732)
MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005 (ISBN: 9780735622548)
Inside Microsoft SQL Server 2005: The Storage Engine (ISBN: 9780735621053)
Inside Microsoft SQL Server 2005: T-SQL Querying (ISBN: 9780735623132)
Inside Microsoft SQL Server 2005: T-SQL Programming (ISBN: 9780735621978)
Inside Microsoft SQL Server 2005: Query Tuning and Optimization (ISBN: 9780735621961)
Microsoft SQL Server 2005 Analysis Services Step by Step (ISBN: 9780735621992)
Programming Microsoft SQL Server 2005 (ISBN: 9780735619234)
Microsoft SQL Server 2005 Administrator’s Pocket Consultant (ISBN: 9780735621077)
Microsoft SQL Server 2005 Administrator’s Companion (ISBN: 9780735621985)
MeasureUp
(Measureup.com)
Self Test Software
(Selftestsoftware.com)
Microsoft online resources
• Learning Plan: Get started with a step-by-step study guide that is based on recommended resources for this exam.
• SQL Server 2005 – Learning Portal: Find special offers and information on training and certification.
• Product information: Visit the SQL Server 2005 Web site for detailed product information.
• Microsoft Learning Community: Join newsgroups and visit community forums to connect with peers for suggestions on training resources and advice on your certification path and studies.
• TechNet: Designed for IT professionals, this site features how-to instructions, best practices, downloads, technical resources, newsgroups, and chats.
• MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats.
Top of page
Skills measured
This certification exam measures your ability to optimize and maintain a database administration solution and to design a database server infrastructure by using SQL Server 2005. Before taking the exam, you should be proficient in the job skills listed in the following table. The table shows the official Microsoft Learning products that may help you reach competency in the skills that are tested in the exam.
KEY: = The course provides a general introductory overview of this task. You will need to supplement the course with additional work. = The course includes some material to prepare you for this task. You will need to supplement the course with additional work. = The course includes material to prepare you for this task.
Skills measured by Exam 70-447 Course 2786 Course 2787 Course 2788 Course 2789 Course 2790
Section 1
Designing a Database Server Infrastructure
Design for capacity requirements.
• Analyze storage requirements.
• Analyze network requirements.
• Analyze CPU requirements.
• Analyze the current configuration.
• Analyze memory requirements.
• Forecast and incorporate anticipated growth requirements into the capacity requirements.
Specify software versions and hardware configurations.
• Choose a version and edition of the operating system.
• Choose a version of SQL Server 2005.
• Choose a CPU type.
• Choose memory options.
• Choose a type of storage.
Design physical storage.
• Design transaction log storage.
• Design backup file storage.
• Decide where to install the operating system.
• Decide where to place SQL Server service executables.
• Specify the number and placement of files to create for each database.
Design instances.
• Decide how many databases to create.
• Decide on the placement of system databases for each instance.
• Decide on the physical storage for the tempdb database for each instance.
• Decide on the number of instances.
• Decide on the naming of instances.
• Decide how many physical servers are needed for instances.
• Establish service requirements.
• Specify instance configurations.
Design a database consolidation strategy.
• Gather information to analyze the dispersed environment.
• Identify potential consolidation problems.
• Create a specification to consolidate SQL Server databases.
• Design a database migration plan for the consolidated environment.
• Test existing applications against the consolidated environment.
Designing Security for a Database Server Solution
Analyze business requirements.
• Gather business and regulatory requirements.
• Decide how requirements will impact choices at various security levels.
• Evaluate costs and benefits of security choices.
• Decide on appropriate security recommendations.
• Inform business decision-makers about security recommendations and their impact.
• Incorporate feedback from business decision-makers into a design.
Integrate database security with enterprise-level authentication systems.
• Decide which authentication system to use.
• Design Active Directory organizational units (OUs) to implement server-level security policies.
• Ascertain the impact of authentication on a high-availability solution.
• Establish the consumption of enterprise authentication.
• Ascertain the impact of enterprise authentication on service up-time requirements.
Develop Microsoft Windows server-level security policies.
• Develop a password policy.
• Develop an encryption policy.
• Specify server accounts and server account rights.
• Specify the interaction of the database server with antivirus software.
• Specify the set of running services, and disable unused services.
• Specify the interaction of the database server with server-level firewalls.
• Specify a physically secure environment for the database server.
Modify the security design based on the impact of network security policies.
Analyze the risk of attacks to the server environment and specify mitigations.
Design SQL Server service-level security.
• Specify logins.
• Select SQL Server server roles for logins.
• Specify a SQL Server service authentication mode.
• Design a secure HTTP endpoint strategy.
• Design a secure job role strategy for the SQL Server Agent Service.
• Specify a policy for .NET assemblies.
Design database-level security.
• Specify database users.
• Design schema containers for database objects.
• Specify database roles.
• Define encryption policies.
• Design DDL triggers.
Design object-level security.
• Design a permissions strategy.
• Analyze existing permissions.
• Design an execution context.
• Design column-level encryption.
• Design security for CLR objects in the database.
Designing a Physical Database
Modify an existing database design based on performance and business requirements.
• Ensure that a database is normalized.
• Allow selected denormalization for performance purposes.
• Ensure that the database is documented and diagrammed.
Design tables.
• Decide if partitioning is appropriate.
• Specify primary and foreign keys.
• Specify column data types and constraints.
• Decide whether to persist computed columns.
• Specify physical location of tables, including file groups and a partitioning scheme.
Design file groups.
• Design file groups for performance.
• Design file groups for recoverability.
• Design file groups for partitioning.
Design index usage.
• Design indexes for faster data access.
• Design indexes to improve data modification.
• Specify physical placement of indexes.
Create database change-control procedures.
• Establish where to store database source code.
• Isolate development and test environments from the production environment.
• Define procedures for moving from development to test.
• Define procedures for promoting from test to production.
• Define procedures for rolling back a deployment.
• Document the database change control procedures.
Designing a Database Solution for High Availability
Select high-availability technologies based on business requirements.
• Analyze availability requirements.
• Analyze potential availability barriers.
• Analyze environmental issues.
• Analyze potential problems related to processes and staff.
• Identify potential single points of failure.
• Decide how quickly the database solution must fail over.
• Choose automatic or manual failback.
• Analyze costs versus benefits of various solutions.
• Combine high-availability technologies to improve availability.
Develop a strategy for migration to a highly available environment.
• Analyze the current environment.
• Ascertain migration options.
• Choose a migration option.
Design a highly available database storage solution.
• Design the RAID solutions for your environment.
• Design a SAN solution.
Design a database-clustering solution.
• Design a Microsoft Cluster Service (MSCS) implementation.
• Design the cluster configuration of the SQL Server service.
Design database mirroring.
• Design server roles for database mirroring.
• Design the initialization of database mirroring.
• Design a test strategy for planned and unplanned role changes.
Design a high-availability solution that is based on replication.
• Specify an appropriate replication solution.
• Choose servers for peer-to-peer replication.
• Establish a strategy for resolving data conflicts.
• Design an application failover strategy.
• Design a strategy to reconnect client applications.
Design log shipping.
• Specify the primary server and secondary server.
• Switch server roles.
• Design an application failover strategy.
• Design a strategy to reconnect client applications.
Designing a Data Recovery Solution for a Database
Specify data recovery technologies based on business requirements.
• Analyze how much data the organization can afford to lose.
• Analyze alternative techniques to save redundant copies of critical business data.
• Analyze how long the database system or database can be unavailable.
Design backup strategies.
• Specify the number and location of devices to be used for backup.
• Specify what data to back up.
• Specify the frequency of backup.
• Choose a backup technique.
• Specify the type of backup.
• Choose a recovery model.
Create a disaster recovery plan.
• Document the sequence of possible events.
• Create a disaster decision tree that includes restore strategies.
• Establish recovery success criteria.
• Validate restore strategies.
Designing a Strategy for Data Archiving
Select archiving techniques based on business requirements.
• Gather requirements that affect archiving.
• Ascertain data-movement requirements for archiving.
Design the format of archival data.
Plan for data archival and access.
• Specify the destination for archival data.
• Specify the frequency of archiving.
• Decide if replication is appropriate.
• Establish how to access archived data.
Design the topology of replication for archiving data.
• Specify the publications and articles to be published.
• Specify the distributor of the publication.
• Specify the subscriber of the publication.
Design the type of replication for archiving data.
Section 2
Optimizing the Performance of Database Servers and Databases
Troubleshoot physical server performance.
Troubleshoot instance performance.
Troubleshoot database performance.
Troubleshoot and maintain query performance.
• Identify poorly performing queries.
• Analyze a query plan to detect inefficiencies in query logic.
• Maintain and optimize indexes.
• Enforce appropriate stored procedure logging and output.
Troubleshoot concurrency issues.
Optimizing and Implementing a Data Recovery Plan for a Database
Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
Plan for fault-tolerance.
Recover from a failure of SQL Server 2005.
Recover from a database disaster.
• Plan a strategy.
• Restore a database.
• Configure logins.
• Recover lost data.
• Maintain server and database scripts for recoverability.
Salvage good data from a damaged database by using restoration techniques.
Designing a Strategy to Monitor and Maintain a Database Solution
Define and implement monitoring standards for a physical server.
• Establish the thresholds for performance.
• Establish the baselines for performance.
• Define which types of information to monitor on the physical server.
• Define traces.
• Set alerts.
• Set notifications.
Choose the appropriate information to monitor.
Create and implement a maintenance strategy for database servers.
• Create a job dependency diagram.
• Manage the maintenance of database servers.
Design a database maintenance plan.
Design a strategy to manage Reporting Services.
Designing a Database Data Management Strategy
Design and manage SQL Server Integration Services (SSIS) packages.
• Construct complex SSIS packages.
• Design security for accessing packages.
• Restart failed packages.
• Troubleshoot or debug packages.
• Deploy and move packages.
• Schedule package execution.
• Move packages to different servers.
Enforce data quality according to business requirements.
• Establish the business requirements for quality.
• Create queries to inspect the data.
• Use checksum.
• Clean the data.
Design data integrity.
• Reconcile data conflicts.
• Make implicit constraints explicit.
• Assign data types to control characteristics of data stored in a column.
Design a strategy to manage data across linked servers.
• Set up and manage linked servers.
Design a strategy to manage replication.
• Design alerts.
• Design a maintenance plan to monitor health, latency, and failures.
• Verify replication.
• Design a plan to resolve replication conflicts.
• Design a plan to modify agent profiles.
• Tune replication configuration.
Optimize a database control strategy to meet business requirements.
• Verify that database change-control procedures are being followed.
• Identify all database objects related to a particular deployment.
Designing a Strategy to Manage and Maintain Database Security
Perform a security audit of the existing security infrastructure based on the security plan.
• Analyze the physical server security.
• Compare the existing security infrastructure to business and regulatory requirements.
• Identify variations from the security design.
Maintain a server-level security strategy.
• Design a strategy to audit Windows account permissions.
• Design a strategy to audit SQL Server service access.
• Maintain a strategy to assign the appropriate minimum level of privileges.
• Maintain an encryption strategy that meets business requirements.
• Design a strategy to apply service packs and security updates.
• Configure the surface area.
Maintain a user-level security strategy.
• Verify the existence and enforcement of account policies.
• Verify SQL Server login authentication.
• Verify permissions on SQL Server roles and accounts.
Prepare for and respond to threats and attacks.
• Prepare for and respond to SQL Server injection attacks.
• Prepare for and respond to denial-of-service attacks that are specific to SQL Server.
• Prepare for and respond to virus and worm attacks that are specific to SQL Server.
• Prepare for and respond to internal attacks that are specific to SQL Server.
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams may include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
Free Sample 70-447 Printable PDF Download:
Testking offers free demo for 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005). You can check out the interface, question quality and usability of our 70-447 Simulation exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Testking microsoft 70-447 Braindumps Introduction: Ultimate resource for 70-447 Bible:
Acquiring new microsoft certifications are becoming a huge task in the field of I.T. These certifications are not easy to attain as they require professionalism and a complete dedication towards the study. More over these exams are now continuously updating and accepting this challenge is itself a task.
This microsoft 70-447 braindumps exam is an important part of microsoft certificationsns and at UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 testking 70-447 txt braindumps we have the resources to prepare you for this. The 5 exam is essential and core part of microsoft certificationsns and once you clear the exam you will be able to solve the real time problems yourself.
70-447 Study Guide
Testking publishes 70-447 online Guide in order to response the customers demand. With many online resources for preparing for the 70-447 exam, you will notice when you read the below information that testking is your premier source for your 70-447 exam. With our 70-447 practice tests with explanations, no other vendor will be able to compare to testking for quality 70-447 study guides.
70-447 Preparation Labs
1:No matter in which part of the world you are, our microsoft 70-447 study notes lab are equally helpful to you for a microsoft 70-447 Preparation Experience like never before. Besides a lot of accurate information and explanations, you will get the knowledge of actual microsoft 70-447 Exam Objectives as well. Whether you are a professional or an amateur, you will be able to succeed in your coming 70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 Exam on your first attempt by using our microsoft 70-447 Preparation Lab. Select Preparation Labs for your microsoft 70-447 Tutorial needs
2: Technology itself is boring, but actual application is of fun. The discovery-and-solving process of problems will often bring us unexpected pleasure. A group of experts gathered by Testking, after in-depth study and analysis of exam 70-447, has built a set of labs for exam 70-447 which include all labs you may encounter in exam 70-447 documents and some common troubleshootings application, as well as steps to solve problems. We hope this will be helpful for those customers who are currently preparing for exam 70-447.
T’K'S 70-447 Questions Answers
70-447 Interactive Testing Engine Included!
Test Simulation:435 Q&As
Last Update : 2009-04-03
Price : $87.99 $9.99
Testking Exams 70-447 Practice Test with Full Explanations Includes:
1:Comprehensive Practice Test Questions with Full Explanations:
2:Detailed Explanations of all the questions
3:Practice 70-447 Test Questions accompanied by exhibits
4:Verified Answers Researched by Industry Experts
5:Drag and Drop questions as experienced in the Actual Exams
6:Best Test Questions with Explanations updated on regular basis
7:Free Testking Practice Test Questions with 70-447 Explanations are backed by our 100% MONEY BACK GUARANTEE.
8:Like actual certification exams, our Practice Tests with Explanations are in multiple-choice (MCQs)
9:Testking is the best microsoft 70-447 Certification Prep Braindumps
Some features about Testking 70-447:
Quality and Value for the 70-447 Exam
microsoft 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) will provide you with exam questions and verified answers that reflect the actual exam. Furthermore, we are constantly updating our exam 70-447. Each candidate who decides to take the 70-447 exam can receive the most reliable and up-to-date study materials here.
100% Guarantee to Pass Your 70-447 Exam
If you do not pass the 70-447 exam on your first attempt using our PassGuide testing engine, we will give you a FULL REFUND of your purchasing fee. Free Testking target is Pass 70-447 For Sure.
70-447 Downloadable, Interactive Testing engines
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Testking Exam Preparation Material provides you everything you will need to take a certification examination. Details are researched and produced by Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books,Study notes,Online Course . but logic is the key. Testking Product will help you not only pass in the first try, but also save your valuable time.
Commitment to Your Success:
At Testking.la we are committed to you ongoing success. Free Testking exams and questions are constantly being updated and compared to industry standards.
You are not about to purchase a disposable product. 70-447 practice exam updates are supplied free of charge. Regardless of how soon you decide to take the actual 70-447 examination certification, you will be able to walk into the testing room as confident as the Certification Administrator.
we can take advantage of the TestKing 70-447 Value Pack and save time and money while developing your skills to pass your exam. This value pack will provide all the training materials you need to build your learning foundation and ensure your success on the exam, for one low price.
PassGuide microsoft 70-447 dumps
Pass4sure 70-447
Testking 70-447
Actualtest 70-447
Search Help For Free PassGuide 70-447 Testking dumps
70-447 real exams
70-447 rapidshare 4shared sadikhov upload links
70-447 cbt testout Train Signal PrepLogic microsoftKits audio and video
| Testking Free Downloads |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Testking ’s value Pack |
986 |
1 days ago | Download |
Popularity: 10% [?]
Dwonload Free Latest Testking Certification Dumps
- Free Testking 70-443
- Free Testking 70-444
- Free Testking 70-442
- Free Testking 70-441
- Free Testking 70-298
- Free Testking 70-446
- Free Testking 70-453
- Free Testking 70-297
- Free Testking 70-290
- Free Testking 70-221
- Free Testking Microsoft certification
- Free Testking 70-450
- Free Testking 70-455
- Free Testking 70-226
- Free Testking 70-451
One Response to “70-447”