Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Question - 75 Maximum mark : - 142

Home
All Exams
Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Online Mock Tests
Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) sample. The SSIS sample includes a number of data flows. You want to use Business Intelligence Development Studio to control the data that passes through each path in the data flow. However, you need to ensure that the data flow logic is not affected. What should you do?

You should use the Data Viewer tool. ✘ You should use the Process Control tool. ✘ You should use the Web service. ✘ You should use the Fuzzy Grouping tool. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You want to specify the XML configuration for the package. What should you do?

You should use the Publish utility. ✘ You should use the default command line utility. ✘ You should use the subscriptions tab. ✘ You should use the DTEXEC command line utility. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. The SSIS instance contains a Data Flow task. You need to ensure that the package logs errors to a Word document. What should you do? (Choose all that apply)

You should use the SSRS log provider for the doc file. You should use a Flat File Destination component. You should use a text File Destination component. You should consider adding an Error output to the Data Flow component. You should consider adding an Error output to the source component.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 server instance. Abc.com makes use of The SSIS instance to run several SQL Server 2008 Integration Services (SSIS) packages. To ensure Abc.com's productivity, you need to ensure that the database server runs normally. What should you do?

You should consider configuring the package protection level to EncryptPartWithPassword. ✘ You should consider configuring package protection level to SaveSensitive. ✘ You should consider configuring package protection level to EncryptSensitiveWithLoginName. ✘ You should consider configuring the BlockedSignatureStates registry entries to Block unsafe, untrustedsigns as well as unsigned instances. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. The SSIS instance uses a default connection manager to connect to a component. You develop an XML configuration file to provide the required authentication information for your report. However, you receive an error message stating that you are unable to log in successfully to the package. You need to ensure that the package is able to run normally. What should you do?

You should consider modifying the XML configuration file. ✘ You should consider using direct XML settings. ✘ You should consider executing the package as the component on the same server. ✘ You should consider using a .REG file that contains all log entries. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. Abc.com network contains a development database server named ABC-DB06 and a production database server named TESCKLING-DB01. You are creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You include ABC-DB06 in the SSIS package. You publish the package to ABCDB06 but discover that you are not able to move the data between ABC-DB06 and ABC-DB01. You receive the following error message: The package could not link to ABC-DB06. You need to modify the package to reference the ABC-DB06 when it is implemented. What should you do?

You need to change the features of the package in order to use the DontSaveSensitive package protection level. ✘ You need to change the features of the package in order to use the store procedure. ✘ You need to select the Connection Manager check box on the Connection Managers tab of the ExecutePackage utility and then change the connection string. ✘ You need to add to the expression on the Flat File Connection manager prior to modifying the connectionstring. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance. The SSIS instance includes a component that contains a string variable named FileName and a string variable named FilePath. The illustration below displays the Foreach Loop container for the Collection property: The Foreach Loop container for the Variable Mappings property for Abc.com is listed below: You need to ensure that the FilePath variable gets the directory path for the file path reserved in the FileName variable when you update the package. How can this be achieved? (Choose all that apply.)

You should consider setting the EvaluateAsExpression feature of the User::FilePath parameter to False. You should consider setting the EvaluateAsExpression feature of the User::FilePath parameter to True. You should consider adding a Script job to the OnPostExecute event handler of the Foreach Loopcontainer. You should consider setting the Expression property of the User::FilePath parameter to the followingexpression. SUBSTRING(@[User::FileName], 1, LEN(@[User::FileName]) FINDSTRING(REVERSE(@ [User::FileName]), "\\", 1)) You should consider setting the Expression property of the User::FilePath parameter to the followingexpression. SUBSTRING(@[User::FileName], 10 LEN(@[User::FileName]) FINDSTRING(REVERSE(@ [User::FileName]), "\\", 0))

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You make use of local development environment in order to check the package. You then publish the package to the file system on a production server named ABC-DB02. However, Abc.com users inform you that they are unable to access the package. You need to ensure that Abc.com users are able to access and run the package. What should you do?

You should use the SaveSensitive option. ✘ You should use the ServerStorage option. ✘ You should use the EncryptAllWithPassword option. ✘ You should use the EncryptPartWithUserKey option. ✔ You should use the EncryptSensitiveWithLoginName option. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package references packages in a SQL Server 2008 sample. You want to publish the SSIS package to another SSIS sample which reserves its packages in a common directory. What should you do?

You should consider running the dtutil command for the package. ✘ You should consider running the taskrun.exe command for the package. ✘ You should consider running the dtexeall command for the package. ✘ You should consider running the default command for the package. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package gets data from a FTP server by using numerous FTP tasks. The package also manages data using various Execute SQL tasks. You need to make sure that the package is set to restart after the package downloaded the files. What should you do?

You should consider configuring the HTTP tasks to hold transactions Log. ✘ You should consider configuring the a store procedure to hold transactions Log. ✘ You should consider transferring the half HTTP job to a sequence container. ✘ You should consider configuring the package to use a checkpoint. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner