Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Microsoft 70 452 Exam – Microsoft SQL Server 2008 (PDF)

VIEWS: 90 PAGES: 3

Microsoft 70-452 (PRO:MS SQL Server@ 2008, Designing a Business Intelligence) Certification Exam is of core importance both in your Professional life and Microsoft Certification Path. With Microsoft PRO:MS SQL Server@ 2008, Designing a Business Intelligence Certification you can get a good job easily in the market and get on your path for success.

More Info
  • pg 1
									 Exam Name:     PRO: MS SQL Server@ 2008, Designing a Business Intelligence
 Exam Type:     Microsoft
 Exam Code:     70-452                                   Total Questions:     38




               Premium Provider in IT Certification Training Tools




          Questions and Answers
                                  Exam Code
                                        70-452

                                  Exam Name
PRO:MS SQL Server@ 2008, Designing a Business Intelligence

                                 Certification
               Microsoft Certified Technology Specialist


                                Release Date
                                 November 2010




 Page 1 of 3                                              http://www.selfexamengine.com
 Exam Name:      PRO: MS SQL Server@ 2008, Designing a Business Intelligence
 Exam Type:      Microsoft
 Exam Code:      70-452                                   Total Questions:         38

Question: 1
You are the administrator of your company network. You use Server 2008 to develop a Business
Intelligence (BI) solution. And you want to deploy a new database that contains a cube to the
SQL Server 2008 Analysis Services (SSAS) instance. And the cube contains three Type 1 slowly
changing dimensions. The database is updated everyday by adding 4,800 rows of data every
hour. Now you have to make sure two things, one is the cube must contain up-to-date data at all
times, the other is, during cube processing, the users are able to access the cube. So what
should you do to achieve this two?

A. You should utilize the relational online analytical processing (ROLAP) cube storage model.
B. You should utilize the automatic multidimensional online analytical processing (MOLAP) cube
   storage model.
C. You should utilize the hybrid online analytical processing (HOLAP) cube storage model. Use
   the snapshot isolation level in the relational database that the cube is
D. You should utilize the hybrid online analytical processing (HOLAP) cube storage model. Use
   SQL Server 2008 Integration Services (SSIS) pipeline tasks to

Answer: A

Question: 2
You are the administrator of your company network. You use Server 2008 to develop a Business
Intelligence (BI) solution. You create 8 SQL Server 2008 Integration Services (SSIS) packages.
You intend to include package configuration for all the packages. The package configuration
has the following requirements: Indirect configuration is used.All configurations are stored in a
single location.Configuration variables are easily backed up and restored.The database
administrators will use change the configuration values by using SQL Server client tools.You
have to create package configurations for the packages to satisfy the configuration requirements.
So what should you do?

A. You should store all configuration information in a SQL Server table. Specify configuration
   database connectivity settings in the SQL Server table.
B. You should store all configuration information in a SQL Server table. Specify configuration
   database connectivity settings in an environment variable.
C. You should use XML configuration files for all packages. Store each XML configuration file in a
   common folder. Specify the XML configuration file location in an
D. You should use XML configuration files for all packages. Store each XML configuration file in a
   common folder. Specify the XML configuration file location in the

Answer: B

Question: 3
You are the administrator of your company network. You use Server 2008 to develop a Business
Intelligence (BI) solution. Now you??re in charge of designing SQL Server2008 Integration
Services (SSIS) projects. You intend to deploy the projects in the following manner: A parent
package on an instance that is named SSIS1.Three child packages individually on three
instances that are named SSIS2, SSIS3, and SSIS4. So what should you do to make sure that
the parent package can discover the execution state of the child packages?

A. You should configure the parent package to log its events to a SQL Server log provider.
B. You should configure the child packages to log their events to a SQL Server log provider.
C. You should configure the child packages to log their events to a SQL Server Profiler log
   provider.
D. You should configure the parent package to log its events to a SQL Server Profiler log
   provider.


 Page 2 of 3                                                  http://www.selfexamengine.com
 Exam Name:       PRO: MS SQL Server@ 2008, Designing a Business Intelligence
 Exam Type:       Microsoft
 Exam Code:       70-452                                   Total Questions:          38

Answer: B

Question: 4
You are the administrator of your company network. You use Server 2008 to develop a Business
Intelligence (BI) solution. Now you??re moving a database from Microsoft SQL Server 2000 to
SQL Server 2008. You want to identify the potential data quality problems before migration. You
intend to use SQL Server 2008 Integration Services (SSIS) to work out a solution which must
meet the following requirements: Requires minimum development efforts. Runs as a repetitive
process based on SSIS.Allows specification of flexible patterns to identify NULL and invalid
column values. So which SSIS task should you use?

A. You should use Script
B. You should use ActiveX Script
C. You should use Data Profiling
D. You should use Data Mining Query

Answer: C

Question: 5
You are the administrator of your company network. You use Server 2008 to develop a Business
Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the
Web site of your company. Information that you need for analysis is stored in the log files on the
Web server. You plan to work out a SQL Server 2008 Integration Services (SSIS) solution to load
the information from the log files into a database. You need to enumerate the log files that are
stored on the Web server.So which control flow element should you utilize?

A. You should utilize File System task
B. You should utilize Sequence container
C. You should utilize Data Profiling task
D. You should utilize Foreach Loop container

Answer: D




 Page 3 of 3                                                    http://www.selfexamengine.com

								
To top