GreatExam guarantees your Microsoft 70-448 exam 100% success with our unique official 70-448 exam questions resources! GreatExam’s 70-448 braindumps are developed by experiences IT Certifications Professionals working in today’s prospering companies and data centers! GreatExam 70-448 exam dumps are checked by our experts team every day to ensure you have the latest updated exam dumps!
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
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
QUESTION 16
You create a SQL Server 2008 Analysis Server (SSAS) solution.
Your solution contains a measure group named FactMeasures with a single partition.
You need to ensure that the following requirements are met:
– Queries that use FactMeasures always refer to the latest version of the source detail data.
– All aggregations that are part of FactMeasures are stored in a multidimensional format.
Which storage mode should you set the ProactiveCaching property of the partition to?
A. Real-time hybrid online analytical processing (HOLAP)
B. Real-time relational online analytical processing (ROLAP)
C. Automatic multidimensional online analytical processing (MOLAP)
D. Scheduled multidimensional online analytical processing (MOLAP)
Answer: A
QUESTION 17
You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your solution has a date dimension named Date along with a hierarchy named Calendar.
The Calendar hierarchy has levels for the Year, Quarter, Month, and Date attributes.
You need to create a named set that refers to the first seven months of the year 2007.
Which expression should you write for the named set?
A. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
B. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
C. ParallelPeriod([DimTime].[Yr-Qtr-Mth].[Year], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
D. ParallelPeriod ([DimTime].[Yr-Qtr-Mth].[Month], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
Answer: A
QUESTION 18
You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
)
You need to create a mining model that can be processed by using this mining structure.
You also need to ensure that the model uses the Microsoft Decision Trees algorithm.
Which DMX statement should you use?
A. SELECT * INTO [Decision Tree]
USING [Hicrosoft_Decision_Trees]
FROM [Bike Buyer]
B. CREATE MINING MODEL [Decision Tree] (
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
) USING Microsoft_Decision_Trees
C. ALTER MINING STRUCTURE [Bike Buyer]
ADD MINING MODEL [Decision Tree] (
[Customer Key] ,
[Age],
[Bike Buyer] PREDICT,
[Commute Distance],
[Yearly Income]
) USING Microsoft_Decision_Trees
WITH DRILLTHROUGH
INSERT INTO [Decision Tree]
(
[Customer Key], [Age],
[Bike Buyer], [Commute Distance],
[Yearly Income]
)
OPENQUERY ([Bike Buyer],
‘Select [Customer Key], [Age],
[Bike Buyer] , [Commute Distance],[Yearly Income]’ )
Answer: C
QUESTION 19
You develop a SQL Server 2008 Analysis Services (SSAS) database.
Your database includes several measure groups.
A measure group named Sales Data requires frequent updates than other measure groups.
You need to ensure that the Sales Data measure group will automatically process on a schedule
managed by SSAS.
What should you do?
A. Modify the ProactiveCaching property.
B. Modify the ProcessingPriority property.
C. Modify the ProcessingMode property.
D. Modify the DataAggregation property.
Answer: A
QUESTION 20
You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your solution has the following components:
– A hierarchy named Date in a time dimension named DimTime
– A measure named SalesAmount
You add the following code segment to the calculation script of the cube. (Line numbers are included for reference only.)
01 . . .
02 Freeze([Measures].[SalesAmount],
03 [DimTime].[Date].[Quarter].[Q1 2007]);
04 . . .
You need to increase the value of the SalesAmount measure by 50% for each month in the first quarter of 2007.
You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?
A. Add the following code segment at line 04.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1 2007]);
This=[DimTime].[Date].currentmember * 1.5;
End Scope;
B. Add the following code segment at line 01.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1 2007]);
This=[DimTime].[Date].currentmember * 1.5;
End Scope;
C. Add the following code segment at line 04.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter].
[Q1 2007][DimTime].[Date].[Month]));
This=[DimTime].[Date].currentmember * 1.5;
End Scope;
D. Add the following code segment at line 01.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter].
[Q1 2007][DimTime].[Date].[Month]));
This=[DimTime].[Date].currentmember * 1.5;
End Scope;
Answer: C
By utilizing GreatExam high quality Microsoft 70-448 exam dumps products, you can surely pass 70-448 certification exam 100%! GreatExam also offers 100% money back guarantee to individuals in case they fail to pass Microsoft 70-448 in one attempt.