Pass4sure Microsoft MCITP 70-446 2.95
Preparation Guide for Exam 70-446
PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005
Audience profile
This exam is intended for IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2005 tools. The qualified candidate for this exam typically has the following experience.
• Experience working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
• At least one year of experience designing both relational and multidimensional database schemas
• Experience designing and building cubes to support business requirements
• One to two years of experience writing both relational and multidimensional queries
• Experience in applying data mining algorithms to business problem domains
• Experience designing and creating reports to support business requirements
• Experience aggregating data into a data warehouse from multiple sources in a heterogeneous data environment
• Experience in designing enterprise-level solutions for very large multidimensional databases
Credit toward certification
When you pass this exam, you earn credit toward the following certification:
• MCITP: Business Intelligence Developer
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 2794: Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Server 2005 (two days)
Course 2795: Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services (two days)
Course 2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services (three days)
Course 2797: Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services (two days)
There are no Microsoft E-Learning courses currently available.
Microsoft SQL Server 2005 Analysis Services Step by Step
Microsoft SQL Server 2005 Reporting Services Step by Step
Inside Microsoft SQL Server 2005: The Storage Engine
Inside Microsoft SQL Server 2005: T-SQL Querying
Inside Microsoft SQL Server 2005: Query Tuning and Optimization
Programming Microsoft SQL Server 2005
MeasureUp (Measureup.com)
Self Test Software (Selftestsoftware.com)
Microsoft online resources
• Learning Plan: Get started by creating a step-by-step study guide that is based on recommended resources for this exam.
• Microsoft SQL Server 2005 – Learning Portal: Find special offers and information on training and certification.
• Microsoft Learning Community: Join newsgroups and visit community forums to connect with your peers for suggestions on training resources and advice on your certification path and studies.
• TechNet: Designed for IT professionals, this site includes 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.
PRO:Design a Business Intellig Infrastr Usi MS SQL Serv 2005 : 70-446 Exam
Exam Number/Code: 70-446
Exam Name: PRO:Design a Business Intellig Infrastr Usi MS SQL Serv 2005
“PRO:Design a Business Intellig Infrastr Usi MS SQL Serv 2005″, also known as 70-446 exam, is a Microsoft certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 121 Q&As to your 70-446 Exam preparation. In the 70-446 exam resources, you will cover every field and category in MCITP helping to ready you for your successful Microsoft Certification.
QUESTION 1:
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows Server 2003 and all client
computers run Windows XP Professional.
A server named Certkiller -SR14 has Software Update Services (SUS) installed.
Client computers are configured to download security updates from
Certkiller -SR14. To ensure that Certkiller -SR14 can be rebuilt if it has a
failure, you have been tasked with ensuring that the configuration of
Certkiller -SR14 is backed up when your routine back ups are performed.
You need to ensure that all important SUS components are included in your backup
strategy. If a Certkiller -SR14 has a disk failure, you want to be able to
replace the failed disk, and restore the configuration of Certkiller -SR14 so that it
is the same as before the failure. You only want to include components in your SUS
server backup plan which is relevant to restoring your SUS server configuration
and SUS server content.
How should you go about backing up the configuration of Certkiller -SR14?
Choose two correct answers. Each correct answer presents only part of the complete
solution. Choose two answers.
Actualtest.org – The Power of Knowing
A. Open the IIS Manager.
Back up the IIS metabase.
B. Open the Windows Backup utility.
Back up the IIS metabase files, SUS content storage directory, and the Default Web site
content storage directory.
C. Open the Windows Backup utility.
Back up all system state data
D. Open the Windows Backup utility.
Back up the SUS content storage directory and all system state data.
Answer: A, B
Explanation: To completely rebuild your SUS server and restore its contents after a
failure, you need to first install Windows Server 2003 on the computer and then
assign the computer with the same name previously used ( Certkiller -SR14).
Because IIS is not installed when you install Windows Server 2003 on a computer,
you need to reinstall and enable IIS on Certkiller -SR14 before you install SUS on
Certkiller -SR14. Up to this point, there is no need to use a backup to perform
these tasks.
You now then need to restore the SUS server to its previous configuration. To do this,
you would need to use an available backup of the IIS metabase, SUS content storage
directory, and the Default Web site content storage directory; and then restore it on
Certkiller -SR14. Once restored on Certkiller -SR14, you would need to use the IIS
Manager to restore your previous IIS configuration using the restored IIS metabase files.
Incorrect Answers:
C: There is no need to back up all system state data. You only need to rebuild the server
using the same name, and same configuration.
D: While you should back up the SUS content storage directory, there is no need to back
up all system state data.
QUESTION 2:
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows Server 2003 and all client
computers run Windows XP Professional.
A server named Certkiller -SR34 has Software Update Services (SUS) installed.
The requirements as required by the network security administrator is to ensure
that the administrative password is NOT compromised when an administrator
connects to Certkiller -SR34’s SUSAdmin Web site remotely by using HTTP. You
want only SSL to be used to connect to the SUSAdmin Web site.
Despite the network security administrator creating a digital certificate and
enabling communication for SSL on port 443 of Certkiller -SR34, the
administrators are still able to connect to the SUSAdmin Web site by using HTTP.
You have received instruction from the CIO to ensure that communication to the
SUSAdmin Web site is always secure.
Actualtest.org – The Power of Knowing
How will you accomplish the task?
A. On all SUSAdmin Web site related directories require 128-Bit SSL.
B. Modify the default web site to require 128-Bit SSL.
C. Use the Request Security IPSec template to enable IPSec on Certkiller -SR34.
D. You should disable port 80 on the SUSAdmin Web site.
Answer: B
Explanation:
SSL works by using a combination of public and private keys. The Session or
Encryption key that is used to encrypt communication with the server and the client
is created according to the security certificate. The strength of the encryption
applied is measured by the length of the encryption key, or in bits. The encryption
strength selected would depend on the sensitivity or importance of the data.
Encryption strength can be 40-Bits or 128-Bits. Requiring 128-Bit SSL on all
directories related to the SUSAdmin Web site would ensure that communication to
the SUSAdmin Web site is always secure. Web page encryption is implemented
using the Secure Sockets Layer (SSL) protocol. This protocol uses TCP port 443. If
administrators can still connect to SUSAdmin through HTTP, then you should
change the setting of the default website to require 128-Bit SSL if you want only
SSL to be used to connect to SUSAdmin.
Incorrect Answers:
A: Requiring 128-bit SSL on all directories related to the USAdmin would be overkill in
this situation as all you need to do is to change the default Web site to require 128-bit
SSL.
C: Enabling IPSec in this situation would be irrelevant.
D: Disabling port 80 will not mean that the SUSAdmin site will stay secure. TCP port 80
handles World Wide Web (WWW) service.
Reference:
Deborah Littlejohn Shinder, Dr. Thomas W. Shinder, Laura E. Hunter & Will Schmied,
MCSA/MCSE: Exam 70-290: Managing and Maintaining a Windows Server 2003
Environment, Study Guide and DVD training system, Syngress Publishing, Rockland,
MA, 2003, p. 968
Tony Northrup and Orin Thomas, MCSA/MCSE Self-Paced Training Kit (Exam
70-299): Implementing and Administering Security in a Microsoft Windows Server 2003
Network, Chapter 11 – Deploying, Configuring, and Managing SSL Certificates
QUESTION 3:
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows Server 2003 and all client
computers run Windows XP Professional.
A server named Certkiller -SR12 has Software Update Services (SUS) installed.
Client computers on the network are configured to download security updates from
Actualtest.org – The Power of Knowing
Certkiller -SR12. While examining several client computers, you discover that no
updates have been installed for more than two weeks. You suspect that the client
computers have stopped downloading updates from Certkiller -SR12.
You examine the synchronization log on Certkiller -SR12 and find that several
update packages have been downloaded from Microsoft’s servers. They have
however not been installed on any client computers. You attempt to open the SUS
Administration Web page on Certkiller -SR12 but cannot do so.
You need to perform the configuration which will result in all client computers
downloading security updates from Certkiller -SR12.
How will you accomplish the task?
A. Configure Certkiller -SR12 to redirect clients to the Windows Update Web site so
that they can download updates directly from this Web site.
B. Examine the content in the approval log on Certkiller -SR12.
C. On Certkiller -SR12, restart the World Wide Web Publishing service.
D. On Certkiller -SR12, configure folder sharing for the folder that contains the SUS
Web site.
Answer: C
Explanation: The SUS server is reliant on IIS, and SUS administration takes the
form of a Web application. Because you cannot access the SUS Administration Web
page on Certkiller -SR12, the issue is probably that IIS is not running on
Certkiller -SR12. One of the requirements for installing SUS on a server is that
the server must be running IIS 5.0 (minimally), and must be connected to the
network. The SUS Web site on Certkiller -SR12 deals with requests from
Automatic Updates clients. To resolve your issue, restart the World Wide Web
Publishing service on Certkiller -SR12.
Incorrect Answers:
A: Because no client computers are able to access the SUS Web site on
Certkiller -SR12, it is impossible to redirect the client computers to the Windows
Update Web site.
B: The content in the approval log on Certkiller -SR12 will only show which updates
have been approved and which have not been approved.
D: There is no need to configure folder sharing for the folder that contains the SUS Web site
because Automatic Updates clients use the SUS Web site and HTTP to download updates
from Certkiller -SR12.
Pass4sure 70-446 2.95
Questions and Answers : 121 Q&As
Expected Date: October 24th , 2008
Price: $129.99 $89.99
Free Down: Pass4sure Microsoft 70-446 2.95
Free Down: Testking microsoft 70-446 2.95
password: www.msexams.net
| PassGuide certification braindumps |
| Type | Exam Bible | New Questions & Answers | Latest Updated | Download link |
 |
All PassGuide 's Exam Pack | 893 | 1 days ago | PassGuide Certification Brainudmps |
Dwonload Free Latest Pass4side Certifications Braindumps
- Free PassGuide Pass4sure Microsoft MB3-006 2.93
- Free PassGuide Pass4sure Microsoft MCITP 70-443 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-441 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-444 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-442 2.83
- Free PassGuide Pass4sure Microsoft MCITP Dumps
- Free PassGuide Pass4sure Microsoft MCITP 70-431 2.93
- Free PassGuide Pass4sure Microsoft MCITP 70-447 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-647 2.83
- Free PassGuide Pass4sure Microsoft MCITP Dumps
