Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Microsoft 70-455 Exam - Cheat-Test.com

Free 70-455 Sample Questions:

1. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site. When performing the analysis, you can get the information you need in the log files on the web server. In order to use the information, you want to load the information into a database by designing a SQL Server 2008 Integration Services (SSIS) solution. You have to enumerate the log files that are stored on the Web server. So which control flow element should you use?
A. You should use File System task
B. You should use Sequence container
C. You should use Data Profiling task
D. You should use Foreach Loop container
Answer: D

2. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. Now you design a SQL Server Integration Services (SSIS) solution. The solutions includes 20 packages. So what should you do to run the packages in a predefined order? (Each correct answer presents a complete solution. choose more than one)
A. You should use data flow paths.
B. You should use precedence constraints.
C. You should use the task host container.
D. You should use the Execute Package task.
E. You should use the system variables for the packages.
Answer: B, D

3. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. Now you design a SQL Server Integration Services (SSIS) solution. You intend to deploy the projects in the manner below:
A parent package on an instance which is named SSIS1.
Three child packages individually on three instances which are named SSIS2, SSIS3, SSIS4.
So what should you do 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 package to log their events to a SQL Server log provider.
C. You should configure the child package 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.
Answer: B


© 2014 Cheat-Test.com, All Rights Reserved