Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 181:

  You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. You should create the report basing on the multidimensional data from a Microsoft SQL Server 2005 Analysis Services (SSAS) cube.

  In order to create a Matrix report by using the [Change Count] measure in the Details field

  You should utilize the Report Wizard

  Which is the correct answer?

  A. You should use the expression of SELECT EMPTY { [Measures].[Change Number] } ON ROWS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON COLUMNS
  B. You should use the expression of SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON ROWS
  C. You should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Number] } ON ROWS
  D. You should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON COLUMNS
  B. You should use the expression of SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON ROWS

• Question 182:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.)

  

  You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension. What should you do?

  A. Create a regular relationship between DimCustomer and FactTransaction.
  B. Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
  C. Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
  D. Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.
  C. Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.

• Question 183:

  You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. Assembly should be created in order to run real-time lookup and currency conversion. The assembly has a static class named daily which lives in the namespace HomeCalc. there is a method called DMO which need two arguments, Cuurnt and HomeCalc

  When the report is operating, you should reference the ToEUR method in an expression to convert USD to USO.

  Which is the correct answer?

  A. You should use the expression of =Code. HomeCalc. Daily. USO (Fields! Cuurnt.Value," DMO ")
  B. You should use the expression of =Code! HomeCalc. Daily. USO (Fields! Cuurnt.Value," DMO")
  C. You should use the expression of = HomeCalc. Daily.USO (Fields! Cuurnt.Value,"USD")
  D. You should use the expression of = HomeCalc! Daily.USO (Fields! Cuurnt.Value,"USD")
  C. You should use the expression of = HomeCalc. Daily.USO (Fields! Cuurnt.Value,"USD")

  ---

  A little bit different wording

  You work as a database administrator at CertKiller.com. You are in the process of creating a SQL Server Reporting Services (SSRS) report for CertKiller.com.

• Question 184:

  You build and deploy a SQL Server 2008 Integration Services (SSIS) package.

  During package development, the XML configuration is not specified.

  You need to apply the configuration file to the deployed package stored in file system.

  Which parameter should you set in the dtexec command line utility?

  A. /conf
  B. /Check F
  C. /L
  D. /set
  A. /conf

• Question 185:

  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 you are in charge of a SQL Server 2008 Analysis Services (SSRS) instance for the company.

  According to your plan, a Dynamic Management View (DMV) will be used to troubleshoot query performance.

  Now you get an order from your manager, according to his requirements, query sessions that execute a query for more than 30,000 ms should be identified.

  So of the following DMV, which one would be used?

  A. Discover_Sessions would be used
  B. Discover_Commands would be used
  C. Discover_Connections would be used
  D. Discover_Traces would be used
  E. Discover_Wizard would be used
  B. Discover_Commands would be used

• Question 186:

  You are keeping a SQL Server 2008 Reporting Services (SSRS) sample for Company.com. The report which searches the information source at random includes search variables that permits users to filter the contents of the report.

  You are setting the report to be displayed from a report execution snapshot.

  You should make sure that users could go on filtering the report through utilizing parameters.

  Which is the correct answer?

  A. You should increase a fixed value to the whole parameters.
  B. You should change the datasets to through utilizing the Table Insert.
  C. Before utilizing the parameters to filter the datasets you should delete the filters from the dataset searches.
  D. You should utilize the stored procedures to filter the datasets of the report.
  C. Before utilizing the parameters to filter the datasets you should delete the filters from the dataset searches.

• Question 187:

  You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions (DMX) to query a data mining model. You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree data mining structure. (Line numbers are included for reference only.)

  

  You need to ensure that the input columns automatically map to the columns in the data mining structure. Which code fragment should you insert at line 05?

  A. NATURAL PREDICTION JOIN
  B. PREDICTION JOIN
  C. INNER JOIN
  D. OPENQUERY
  A. NATURAL PREDICTION JOIN

• Question 188:

  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.

  According to the requirement of the company, you're deploying a SQL Server 2008 Integration Services (SSIS) package.

  The XML configuration is not specified when deploying the package. You have to apply the configuration to the deployed package. What action should you do?

  A. The Deployment utility should be used
  B. The SETX command line utility should be used
  C. The DTEXEC command line utility should be used
  D. The DTUTIL command line utility should be used
  C. The DTEXEC command line utility should be used

  ---

  Using DTExecUI to Configure Package Execution

  The command-line executable file DTExec is a fully featured utility with broad parameterization capabilities. You can generate the command line manually by applying the command parameters to meet the execution circumstance, but to save

  time and avoid errors, you can use the command-line builder utility named DTExecUI.

  DTExecUI is a visual tool that naturally groups the command parameter options. The server on which you run DTExecUI must have SSIS installed. To open DTExecUI, type DTExecUI either from a command prompt or by choosing Start and

  then Run to open the Run dialog box. You can open the tool from the Run dialog box or from the command prompt without specifying the path.

  To use DTExecUI, follow these steps:

  1.

  Open the Execute Package Utility by executing DTExecUI either by choosing Start and then Run, and entering DTE xecUI in the Run dialog box, or through a command prompt.

  2.

  On the General property page, select the package for execution so that you can modify a property on the other pages. In the Package Source drop-down list, select File System, SSIS Package Store, or SQL Server, depending on where your package is located.

  3.

  After identifying the package location, select the specific package for execution. If your package is stored in SQL Server or the SSIS Package Store, you need to specify the connection details to the SQL Server 2008 server by providing the server name. SQL Server also requires you to either provide a user name and password or specify Windows Authentication. All location choices require that you specify the package in the Package box by clicking the ellipsis button to the right of the Package box.

  4.

  Next you need to specify how the package should be executed by configuring other package execution properties. Selecting the various property pages on the left from Configurations down through Verification will let you override settings such as connections, logging, and outputs. Table 4-3 describes the execution configuration options. Manual package deployment You can move your SSIS packages to a destination folder by copying them manually, by using a source-control tool that handles file deployment, or by creating a script or an application that handles the deployment. If you store your package in SQL Server, you can either use the DTUtil command-line utility that comes with SSIS to deploy your packages to SQL Server or manually import them through SSMS.

• Question 189:

  You are creating a SQL Server 2008 Reporting Services (SSRS) report which includes a table for Company. com.

  You should make sure that you permit users to open a new report when they click on a field in a table through utilizing a technology. Which is the correct answer?

  A. You should utilize the technology of Tablix Content Region
  B. You should utilize the technology of report
  C. You should utilize the technology of Drillthrough action
  D. You should utilize the technology of Sorting
  C. You should utilize the technology of Drillthrough action

• Question 190:

  You create a report by using SQL Server 2008 Reporting Services (SSRS).

  You plan to deploy the report on a report server. The report will be delivered on a regular basis to a dynamic list of subscribers.

  You need to create a new subscription on the report server.

  What should you do?

  A. Select the report you created, and then click the New Subscription button.
  B. Select the My Subscriptions page, and then click the New Data-driven Subscription button.
  C. Select the report you created. Click the Subscriptions tab, and then click the New Data-driven Subscription button.
  D. Select the report you created. Click the Subscriptions tab, and then click the New Subscription button.
  C. Select the report you created. Click the Subscriptions tab, and then click the New Data-driven Subscription button.