This page was exported from New Real Practice Test With VCE And PDF For Free Download [ http://www.actualtest.info ]
Export date: Thu Mar 28 15:28:43 2024 / +0000 GMT

(New Updated) Real Microsoft 70-448 Exam Dumps With New Added Questions For Free Download (1-15)


P.s.: These 70-448 Exam Questions Were Updated After 2014/11/1 With The Change Of New Microsoft Exam. 100 Percent Vaild And 100 Percent Pass Ensure. Visit Our PassLeader Website And Get All Valid Exam Questions With PDF And VCE. 100 Percent Guaranteed Pass or 100 Percent Money Back Guarantee!

Vendor: Microsoft
Exam Code: 70-448
Exam Name: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

QUESTION 1
You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment. The package extracts data from a remote server and inserts it in the PROD database on the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server. You need to ensure that only users that belong to an appropriate database role can modify and execute the deployed package. You also need to ensure that these users cannot access other packages that are deployed to the server. What should you do?

A.    Assign the users to the db_ssisoperator role.
B.    Assign the users to the db_ssisltduser role.
C.    Assign the users to a custom database role in the PROD database.
D.    Assign the users to a custom database role in the MSDB database.

Answer: D

QUESTION 2
You develop a package by using SQL Server 2008 Integration Services (SSIS). You use a local instance of SSIS to develop and test the package. The package uses an XML configuration file that contains a connection string. The connection string includes a user name and a password to connect to the source data. You deploy the package to the production server. You discover that validation errors occur when the package is being executed. You need to ensure that the package executes successfully in the production environment. What should you do?

A.    Configure the package to use the DontSaveSensitive package protection level.
B.    Configure the package to use the EncryptSensitiveWithPassword package protection level.
C.    Configure the package to use the EncryptAllWithUserKey package protection level.
D.    Remove the user name and the password from the connection string before you deploy the package.

Answer: B

QUESTION 3
You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You have a complex package that takes a long time to run. You need to ensure that if the package executes during a failover, the package can be resumed at the point of failure. What should you do?

A.    Cluster the SSIS service.
Add the SSIS service to its own cluster resource group.
B.    Cluster the SSIS service.
Add the SSIS service to the SQL Server cluster resource group.
C.    Implement checkpoints within your package.
Restart the package whenever a failover occurs.
D.    Implement transactions within your package.
Restart the package whenever a failover occurs.

Answer: C

QUESTION 4
You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do?

A.    Configure the FTP tasks to support transactions.
B.    Configure the Execute SQL tasks to support transactions.
C.    Move all the FTP tasks to a sequence container.
D.    Configure the package to use a checkpoint.

Answer: D

QUESTION 5
You develop a SQL Server 2008 Reporting Services (SSRS) report. The report uses the "User!UserID" expression in a text box within the report header. You need to ensure that data-driven subscriptions successfully execute for this report. What should you do?

A.    Remove the expression from the report header.
B.    Configure the report to use no credentials.
C.    Configure the report to use stored credentials.
D.    Modify the expression in the report header as "User!UserName."

Answer: C

QUESTION 6
You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance. The report contains query parameters that allow users to filter the contents of the report. The report queries the data source randomly. You configure the report to be rendered from a report execution snapshot. You need to ensure that users can continue to use parameters to filter the report. What should you do?

A.    Add a default value to all parameters.
B.    Modify the datasets to use the Table query type.
C.    Remove the filters from the dataset queries.
Use the parameters to filter the datasets.
D.    Move the queries to the stored procedures.
Use the stored procedures to populate and filter the datasets of the report.

Answer: C

QUESTION 7
You are managing the security in SQL Server 2008 Reporting Services (SSRS). You assign a new user to a role. You need to grant the permissions to the user to publish reports and manage content only in a private folder. What should you do?

A.    Assign the user to the Publisher role.
B.    Assign the user to the My Reports role.
C.    Assign the user to the Content Manager and the Browser roles.
D.    Assign the user to the Content Manager and the Report Builder roles.

Answer: B


http://www.passleader.com/70-448.html

QUESTION 8
You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a parameter named @SalesTax8ateID. You set the value of the @SafesTaxRateID parameter in the report by selecting a specific region. You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID parameter. What should you do?

A.    Clear the Prompt value.
B.    Set the Hidden property.
C.    Set the Internal property.
D.    Remove the default values.

Answer: C

QUESTION 9
You develop a SQL Server 2008 Reporting Services (SSRS) project. The report will display data from a SQL Server 2005 Analysis Services database. You need to ensure that the report displays member properties and extended properties. What should you do?

A.    Use the SQL Server data source.
B.    Use the SQL Server Analysis Services data source.
C.    Use the OLE DB for SQL Server data source.
D.    Use the OLE DB for the Analysis Services 8.0 data source.

Answer: B

QUESTION 10
You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS). The report contains a table. You need to implement a technology that allows users to open a new report when they click on a field in a table. Which SSRS technology should you use?

A.    Subreport
B.    Tablix Data Region
C.    Drillthrough action
D.    Interactive Sorting

Answer: C

QUESTION 11
You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a report header and a report footer. The report preview shows that the report is rendered correctly. You discover that when the report is rendered as a PDF file, even-numbered pages are rendered blank. You need to modify the report to prevent the rendering of blank pages. What should you do?

A.    Reduce the overall width of the report.
B.    Reduce the page size of the report.
C.    Reduce the height of the report footer.
D.    Reduce the height of the report header.

Answer: A

QUESTION 12
You maintain a SQL Server 2008 Integration Services (SSIS) instance. The instance stores packages in a SQL Server 2008 instance. You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in a shared directory. What should you do?

A.    Execute the dtutil command.
B.    Execute the dtexec command.
C.    Execute the dtexecui command.
D.    Execute the dtswizard command.

Answer: A

QUESTION 13
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. The package is deployed to a production server. You need to configure the protection level of the package to ensure that only the user who deployed the package can execute it. Which protection level should you use?

A.    EncryptAllWithPassword
B.    EncryptSensitiveWithPassword
C.    DontSaveSensitive
D.    EncryptAllWithUserKey

Answer: D

QUESTION 14
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. You deploy the package to the file system in the production environment. The users report that the connection strings contained in the package are blank. The package fails to execute. You need to change the protection level of the package to ensure that users can view and execute the package. Which protection level should you use?

A.    DontSaveSensitive
B.    EncryptAllWithUserKey
C.    EncryptAllWithPassword
D.    ServerStorage

Answer: C

QUESTION 15
You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

A.    Set the AggregationFunction property of AccountBalance to Sum.
B.    Set the AggregationFunction property of AccountBalance to ByAccount.
C.    Set the AggregationFunction property of AccountBalance to LastNonEmpty.
D.    Set the AggregationFunction property of AccountBalance to FirstNonEmpty.

Answer: C


Thank You for Choosing PassLeader's Products, We PassLeader Guarantee:
1) More than 99,900 Satisfied Customers Worldwide.
2) Average 99.9% Success Rate.
3) Free Update to match latest and real exam scenarios.
4) Instant Download Access! No Setup required.
5) Questions & Answers are downloadable in PDF format and VCE test engine format.
6) Multi-Platform capabilities - Windows, Laptop, Mac, Android, iPhone, iPod, iPad.
7) 100% Guaranteed Success or 100% Money Back Guarantee.
8) Fast, helpful support 24x7.

http://www.passleader.com/70-448.html

Post date: 2014-11-11 07:20:25
Post date GMT: 2014-11-11 07:20:25
Post modified date: 2014-11-11 07:20:25
Post modified date GMT: 2014-11-11 07:20:25
Powered by [ Universal Post Manager ] plugin. HTML saving format developed by gVectors Team www.gVectors.com