Questions And Answers PDF
Microsoft 70-448 TS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance
Version: DEMO
http://www.TestWarrior.com/70-448-practice-exam.html
FOR 70-448 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/70-448-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question 1. You design a SQL Server 2008 Integraton Services (SSIS) package. The package extracts data from fat fies and ioads this data to a SQL Server 2008 database. The package contains two Booiean variabies named @IsWeekday and @IsHoiiday. When the package is executed on week days, the @IsWeekday variabie is set to True. When the package is executed on hoiidays, the @IsHoiiday variabie is set to true. You need to impiement the foiiowing business iogic in the controi fow of the package: When the @IsWeekday variabie is set to True, the Perform Weekday Processing Data Fiow task is executed. When the @IsWeekday variabie is set to Faise, the Perform Weekend Processing Data Fiow task is executed. When the @IsHoiiday variabie is set to True, the Perform Hoiiday Processing Data Fiow task is executed. Which controi fow iogic shouid you impiement? A.
B.
TestWarrior.com
2
Questions And Answers PDF
C.
D.
TestWarrior.com
3
Questions And Answers PDF
Aoswern A Question 2. You are deveioping a SQL Server 2008 Integraton Services (SSIS) data fow that ioads data to a SQL Server 2008 database. You need to ensure that the data fow updates the existng records in the SQL Server database by using data from the rows in your data fow. Which data fow component shouid you use? A. SQL Server Destnaton B. OLE DB Destnaton C. OLE DB Command Transformaton D. Data Conversion Transformaton
Aoswern C Question 3. You design a SQL Server 2008 Integraton Services (SSIS) package that contains severai data fows. You need to monitor the data that passes through each path in the data fow by using the Business Inteiiigence Deveiopment Studio. You aiso need to ensure that data fow iogic is retained. What shouid you do? A. Use the Data Viewer tooi. B. Use the Data Profiing task. C. Use the Audit transformaton. D. Use breakpoints in the Script component.
TestWarrior.com
4
Questions And Answers PDF
Aoswern A Question 4. You are deveioping a SQL Server 2008 Integraton Services (SSIS) data fow that extracts data from two sources. Each source database is iocated on a diferent server. Each source is based on a SELECT statement that uses an ORDER BY ciause. The data fow is as shown in the foiiowing diagram. When the paths from the two sources are connected to a Merge Join component, the foiiowing error message is dispiayed: "Data Fiow Task: The input is not sorted. The 'input "Merge Join Lef Input" (80)' must be sorted." You need to ensure that data from each query is inciuded in each row in the data fow. You want to achieve this goai by using minimum amount of executon tme. What shouid you do?
A. Add a Sort transformaton for each data fow. B. Add an OLE DB Command transformaton for each data fow. C. Update the sortng propertes in each source component. D. Repiace the Merge Join transformaton with a Union Aii transformaton.
Aoswern C Question 5. You are designing a SQL Server 2008 Integraton Services (SSIS) package. The package inciudes a Data Fiow task that copies severai miiiion rows. The data fow requires a match against a reference tabie that contains 10,000 rows. Each row in the reference tabie wiii be used during the data fow. You need to ensure that the data fow executes in the minimum amount of tme. Which data fow component shouid you seiect? A. a Fuzzy Lookup transformaton B. a Lookup transformaton aiong with the Fuii cache opton C. a Lookup transformaton aiong with the No cache opton D. a Lookup transformaton aiong with the Partai cache opton
TestWarrior.com
5
Questions And Answers PDF
Aoswern B Question 6. You design a SQL Server 2008 Integraton Services (SSIS) data fow that inserts data from a source query to a destnaton tabie. You need to insert oniy those rows that do not aiready exist in the destnaton tabie. What are two possibie ways to achieve this goai? (Each correct answer presents a compiete soiuton. Choose two.) A. Use the Merge transformaton. B. Use the Lookup transformaton. C. Use the Union Aii transformaton. D. Use the Merge Join transformaton. E. Use the Fuzzy Lookup transformaton. E. Use the Fuzzy Grouping transformaton.
Aoswern BD Question 7. You modify a SQL Server 2008 Integraton Services (SSIS) package. The package extracts data from a text fie and ioads this data to a SQL Server 2008 tabie as shown in the foiiowing two exhibits. You need to update the package to extract data from muitpie text fies of the same directory. Which three actons shouid you perform? (Each correct answer presents part of the soiuton. Choose three.)
A. Add a variabie to the package. B. Add a variabie to the data fow task. C. Add a Foreach Loop container to the package. D. Add a For Loop container to the package. E. Add an expression to the Fiat Fiie Source component.
TestWarrior.com
6
Questions And Answers PDF
E. Add an expression to the Fiat Fiie connecton manager.
Aoswern ACF Question 8. You impiement a SQL Server 2008 Integraton Services (SSIS) package. The package contains the foiiowing components: A Foreach Loop container for the Coiiecton property as shown in the foiiowing exhibit. (Ciick the Exhibit buton.) A Foreach Loop container for the Variabie Mappings property as shown in the foiiowing exhibit. (Ciick the Exhibit buton.) A String variabie named FiieName. A String variabie named DirectoryPath. You need to update the package so that the DirectoryPath variabie returns the directory path for the fie path stored in the FiieName variabie. Which two actons shouid you perform? (Each correct answer presents part of the soiuton. Choose two.) A. Set the RaiseChangedEvent property of the User::FiieName variabie to True. B. Set the EvaiuateAsExpression property of the User::DirectoryPath variabie to True. C. Add a Script task to the OnPostExecute event handier of the Foreach Loop container. D. Set the Expression property of the User::DirectoryPath variabie to the foiiowing expression. SUBSTRING( @[User::FiieName], 1, LEN( @[User::FiieName] ) FINDSTRING( REVERSE( @[User::FiieName] ), "\\", 1 )) E. Set the Expression property of the User::FiieName variabie to the foiiowing expression. SUBSTRING( @[User::FiieName], 1, LEN( @[User::FiieName] ) FINDSTRING( REVERSE( @[User::FiieName] ), "\\", 1 ))
Aoswern BD Question 9. You impiement a SQL Server 2008 Integraton Services (SSIS) package. The package contains the foiiowing components: A data fow task contained in a For Loop container A Fiat Fiie destnaton component that uses a Fiat Fiie connecton manager An OnError event handier When an error occurs in the package, you pian to write diagnostc informaton from an expression that inciudes the version of the package to a text fie. You need to ensure that the required informaton is writen to the text fie. What shouid you do?
TestWarrior.com
7
Questions And Answers PDF
A. Use the VersionGUID variabie. B. Use the ExecutonGUID variabie. C. Use the SourceID variabie. D. Use the TaskID variabie.
Aoswern A Question 10. You deveiop a SQL Server 2008 Integraton Services (SSIS) package. The structure of the package is as shown in the foiiowing exhibit. You need to defne a variabie that contains sensitve informaton that is oniy avaiiabie to the Sequence Container, the Data Fiow Task, and the Execute SQL Task. What shouid you do? A. Create the variabie at the package scope. B. Create the variabie at the Data Fiow Task scope. C. Create the variabie at the Execute SQL Task scope. D. Create the variabie at the Sequence Container scope.
Aoswern D
TestWarrior.com
8
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 70-448 Exam Questions With Answers.
http://www.TestWarrior.com/70-448-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/70-448-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
9