|Exam Name||:||TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance|
|Questions and Answers||:||332 Q & A|
|Updated On||:||May 22, 2017|
|PDF Download Mirror||:||70-448 Brain Dump|
|Get Full Version||:||Pass4sure 70-448 Full Version|
You develop a SQL Server 2008 Integration Services (SSIS) package. You need to modify the package to log event data from a text file to the SQL Server database. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Modify the Flat File Destination.
Modify the log provider.
Move the package file to the new path.
Modify the Connection Manager.
B: The SQL Server log provider, which writes log entries to the sysssislog table in a SQL Server database.
D: A package typically includes at least one connection manager. A connection manager is a link between a package and a data source that defines the connection string for accessing the data that the tasks, transformations, and event handlers in the package use. Integration Services includes connection types for data sources such as text and XML files, relational databases, and Analysis Services databases and projects.
Note: A log is a collection of information about the package that is collected when the package runs. For example, a log can provide the start and finish time for a package run. A log
provider defines the destination type and the format that the package and its containers and
tasks can use to log run-time information.
The logs are associated with a package, but the tasks and containers in the package can log information to any package log. Integration Services includes a variety of built-in log providers for logging. For example, Integration Services includes log providers for SQL Server and text files.
You can also create custom log providers and use them for logging. Incorrect:
Not A: The destination is a SQL Server database, not a text file. References: Integration Services (SSIS) Packages
You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server method. The servers reside in geographies with a high risk of natural disaster. You need to implement a disaster recovery plan to back up the SSIS packages for availability. What should you back up?
The model database
The package folder
The master database
The MSDB database
You maintain a SQL Server 2008 Integration Services (SSIS) instance. You develop a package that creates the temporary table *employee_stgl and then loads the data from an Excel source data flow task into *employee_stgl by using conditional transformation splits. The package then loads the data into a destination table. When you try to open the package, you get an error that reads, "Invalid object name
You need to resolve this error message.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Set RetainSameConnection to True.
Set RetainSameConnection to False.
Set DelayValidation to True.
Set DelayValidation to False.
A: ConnectionManagerOleDbClass.RetainSameConnection Property Gets or sets a Boolean
that indicates whether the connection manager retains the same connection. C: DtsContainer.DelayValidation Property
Gets or sets a Boolean that indicates whether validation of the task is delayed until run time. The default value is false.
Note: Validating the package before it runs is a way of finding some errors before execution starts. However, it processes the package to find errors, and if no errors are found, the package runs.
Because this goes through the package two times, validating a package increases the amount of processing for the package, so should be used only when necessary.
You maintain a SQL Server 2008 Integration Services (SSIS) instance. You use the Execute SQL task to create a table in a Control Flow. Following the Execute SQL task is a Data Flow task in which an OLE DB source component uses this table. The package fails during runtime. You need to delay the validation of a task in the Control Flow and the OLE DB source in the data flow. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Set the DelayValidation property for the Control Flow task to True.
Set the ValidateExternalMetaData property for the OLE DB source to False.
Set the ValidateExternalMetaData property for the OLE DB source to True.
Set the DelayValidation property for the Control Flow task to False.
The DelayValidation property is available only in executables (e.g., Control Flow tasks, the package itself). The property isn't available in data flow components. If you want to change
the behavior of a specific data flow component, you must set its ValidateExternalMetadata property to False.
You design a report by using SQL Server 2008 Reporting Services (SSRS). The report contains a dataset that has 25 million rows of data. The report is rendered by using the HTML rendering extension. You need to ensure that users can view the report without delay during rendering. What should you do?
Set the PageHeight property to 0.
Set the InteractiveHeight property to 100.
Set the InteractiveHeight property to 0.
Set the PageHeight property to 100.
You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance. You need to collect information to determine if performance issues are related to hardware limitations or latch wait contention. Which three counters should you use? (To answer, select the three appropriate counters in the answer area.)
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You need to configure the analysis services query log for the SSAS instance. Which tool should you use?
SQL Server Error and Usage Reporting
SQL Server Business Intelligence Development Studio
SQL Server Management Studio
SQL Server Configuration Manager
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You have a cube that contains an unprocessed dimension. When a user attempts to process the cube, the dimension data is not refreshed. You need to allow the user to refresh the dimension data only. Which permissions should you grant the user?
Read-only on the dimension
Read/write permissions on the cube
Process on the dimension
Read and process on the cube
You manage a SQL Server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table for analysis. This warehouse also includes a Student Dimension which contains attributes related to each student. The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can be identified and tracked. However, test scores located in the Scores fact table should not be updated as part of this incremental processing strategy. You need to implement this functionality. Which option should you use?
Your organization has five departments. You are developing a SQL Server 2008 Integration Services (SSIS) project to calculate salary increases and bonuses under each particular manager. You need to develop a master package that meets the following requirements:
It must give each department a different ID.
These department IDs must pass on to each individual dependency package inside the master package.
Each dependency package should have individual security settings to accept department ID as a variable from its master package.
Which configuration method should you choose from the SSIS configuration options?
Parent package variable
XML configuration file
You are working as an ETL developer for a payroll company. You configure a SQL Server 2008 Integration Services (SSIS) package to use checkpoints. The SSIS package truncates the dbo.Employee_Attendance table, loads the new employees in the dbo.Employee table, and
then loads dbo.Employee_Attendance for a particular month. The package fails at the Derived Column transformation within the data flow task. You need to determine where the package execution will begin after you correct the errors and run the package again. Where does the package execution begin? (To answer, select the appropriate task in the control flow.)
You are developing a SQL Server 2008 Integration Services (SSIS) package. The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package execute within a single transaction. What should you do?
In the ForEach Loop container, configure the TransactionOption property to NotSupported.
In the package, configure the TransactionOption property to Required.
In the Data Flow task, configure the TransactionOption property to Required.
In the package, configure the TransactionOption property to NotSupported.
You maintain a SQL Server Integration Services (SSIS) instance that uses Windows
Authentication. You need to determine if there is a package named DailyLoad in the MSDB database on the local instance of SQL Server. Which dtutil command syntax should you use?
dtutil /SQL DailyLoad /EXISTS
dtutil /SQL DailyLoad /USERNAME xyz /USERPASSWORD xxxxxx /EXISTS
dtutil /DTS DailyLoad.dtsx /MOVE SQL;destPackage
dtutil /File W:/DailyLoad.dtsx /EXISTS
You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a folder named Human Resources Reports. All groups can view and modify reports in any folder. You need to ensure that only the Human Resources group can view and modify reports in the Human Resources Reports folder. What should you do? (Each correct answer presents part of the solution. Choose two.)
Remove all groups from the Human Resources Reports folder.
Assign the Human Resources group to the root folder.
Add the Human Resources group to the Human Resources Reports folder and assign the Content Manager role.
Create a Human Resources role and assign it to the Human Resources Reports folder.
A: Need to remove access to all users.
C: With the Content Manager role the Human Resources group can view and modify the folder.