Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 111:

  You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

  Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.

  You are in charge of a SQL Server 2008 Reporting Services (SSRS) instance. Accidentally, you find that 1000 reports are deployed on the SSRS instance by a developer, so your manager asks you to find a solution to prevent these reports

  from deploying on the SSRS instance so that it can be restored to its initial status.

  What should you do to make the instance return to its initial status?

  A. You should restore the Report Server database to make the instance return to its initial status
  B. You should restore the Report Server Temporary database to make the instance return to its initial status
  C. You should restore the master database to make the instance return to its initial status
  D. You should restore the MSDB database to make the instance return to its initial status
  A. You should restore the Report Server database to make the instance return to its initial status

• Question 112:

  You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company. com.

  In the Report Builder tool, the users should need to create their SSRS reports. The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables?

  You should design the report model for users, and allow access to only the 20 tables which they require for reporting. Which is the correct answer?

  A. You should develop DataSet using the Web Service to Schema(s) option.
  B. You should develop DataTable using the Web Service to Schema(s) option.
  C. You should develop a data source view and select only the required tables and views.
  D. You should set the data source view in the setting file.
  C. You should develop a data source view and select only the required tables and views.

  ---

  Data source view (DSV) Abstracts the underlying database schema. Although a DSV might seem redundant, it can be very useful by letting you augment the schema. For example, you can add calculated columns to a DSV when security policies prevent you from changing the database schema.

• Question 113:

  You are designing a SQL Server 2008 Integration Services (SSIS) package. The package will be used to extract data from a SQL Server 2008 database and load data to a Microsoft Office Excel workbook.

  You need to ensure that the package creates a new worksheet in an existing Excel workbook during execution.

  Which control flow component should you use to create the worksheet?

  A. File System Task
  B. Execute SQL Task
  C. Data Flow Task along with the OLE DB source
  D. Bulk Insert Task
  C. Data Flow Task along with the OLE DB source

  ---

  Data flow tasks within SSIS can be used to move data from a source to destination and at the same time use certain transformation tasks to clean and modify the data while it is transferred. By adding a data flow task to the package control flow the package can be made to perform data extraction, transformation and load (ETL) operations.

  A: File System Task is used to perform operations on files and folders, such as create, move, delete, and also to set the attributes for files and folders.

  B: The Execute SQL Task can be used to execute any TSQL code

  D: The Bulk Insert Task can be used to insert data from a text file or a flat file into a SQL Server Table

• Question 114:

  You maintain a SQL Server 2008 Analysis Services (SSAS) database.

  You plan to refresh data in a partition every two hours.

  You need to implement the incremental processing strategy.

  Which XML for Analysis (XMLA) command should you use?

  A. ProcessAdd
  B. ProcessData
  C. ProcessFull
  D. ProcessIndex
  A. ProcessAdd

• Question 115:

  You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.

  Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.

  Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You use SQL Server 2008 Reporting Services (SSRS) to create a solution. There is a dimension named Number and a time dimension named

  Day.

  A column named PresentBalance is contained in a fact table. PresentBalance contains the current account balance.

  A measure named NumberBalance has to be created from the PresentBalance column. The NumberBalance is used to display the closing account balance for a time period. So what action should you perform?

  A. The AggregationFunction property of NumberBalance should be set to FirstNonEmpty
  B. The AggregationFunction property of NumberBalance should be set to Sum
  C. The AggregationFunction property of NumberBalance should be set to ByAccount
  D. The AggregationFunction property of NumberBalance should be set to LastNonEmpty
  D. The AggregationFunction property of NumberBalance should be set to LastNonEmpty

  ---

  EXAM TIP Development and Enterprise editions of SSAS provide several functions--such as LastChild, LastNonEmpty, and AverageOfChildren--that help you handle semiadditive measures. for example, LastNonEmpty will let you get the closing inventory balance for a given time period that is not empty. Although you can use custom MDX expressions to aggregate semiadditive measures, you will get better performance if you use these standard functions. for the complete list of standard aggregation functions, see the topic "Confi guring Measure Properties" in SQL Server 2008 Books online (see References).

• Question 116:

  You are developing a SQL Server 2008 Analysis Services (SSAS) method which owns a date dimension called DateTester along with a rule called CalendarTester for Company.com.

  The CalendarTester rule owns levels for the Year, Quarter, Month, and Date properties. You should make sure that you could develop a called setTester that connects with the first eight months of the year 2008.

  Which is the correct answer?

  A. You should use the expression below: [ Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[August 2008])
  B. You should use the expression below: [ yr-day].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[ August 2008])
  C. You should use the expression below: [yr-day]. [Month],8, [DimTime].[ yr-day].[Month].[ August 2008])
  D. You should use the expression below: [ yr-day].[Year],8, [DimTime].[ yr-day].[Month].[ August 2008])
  A. You should use the expression below: [ Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[August 2008])

• Question 117:

  You are running a SQL Server 2008 Analysis Services (SSAS) solution which contains data mining extensions (DMX) to search a data mining model for Company.com.

  In order to search a Clerk Walker data mining model in a Decision Tree data mining structure, the codes are listed below:

  11 SELECT

  12 [Decision Tree].[Clerk Walker] AS Buyer

  13 FROM

  14 [Decision Tree]

  16 (SELECT 28 AS [Age],

  17 '2-5 Miles' AS [Commute Distance],

  18 '1' AS [House Owner Flag],

  19 1 AS [Number Cars Owned],

  20 2 AS [Total Children]) AS t

  In the data mining structure, you should make sure that the input columns map to the columns.

  Which is the correct answer?

  A. You should utilize NATURAL PREDICTION JOIN
  B. You should utilize LEFT JOIN
  C. You should utilize OUTER JOIN
  D. You should utilize RIGHT JOIN
  A. You should utilize NATURAL PREDICTION JOIN

• Question 118:

  You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There are some components in the method

  A dimension called TestTime which includes a property called Year A measure group called TestProduct that connects with the TestTime dimension

  You should make sure that the designed on TestProduct contain the Year property.

  Which is the correct answer?

  A. You should configure the AttributeHierarchyDisEnabled attribute.
  B. You should configure the IsNotAggregatable attribute.
  C. You should configure the AggregationUsage attribute.
  D. You should configure the Usage attribute.
  C. You should configure the AggregationUsage attribute.

• Question 119:

  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.)

  Hot Area:

  

  

• Question 120:

  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.
  B. Configure the package to use the EncryptSensitiveWithPassword package protection level.