Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 101:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing SQL Profiler, you decide to troubleshoot search function. You should make sure that it will cost a lot of time to query.

  Which is the correct answer?

  A. You should utilize store procedure.
  B. You should utilize Query Subcube
  C. You should utilize a Dynamic Management View (DMV)
  D. You should utilize Transactions Log.
  B. You should utilize Query Subcube

  ---

  The server raises the Query Begin event when it receives an MDX query and the Query End event when it has finished executing the query. The Query Subcube event shows which attributes the server used to satisfy the query. When configuring the trace, you can check the Query Subcube Verbose event to see these attributes in a human-readable format

• Question 102:

  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 CIO, you are using Business Intelligence Development Studio to edit a

  SQL Server 2008 Integration Services (SSIS) package.

  A custom data flow component is used by the package which runs successfully. You try to add another instance of the custom data flow component to the package, but you find that the data flow component does not appear in the toolbox or

  in the Choose Toolbox Items dialog box.

  You have to solve this problem. So what should you do to successfully add the custom data flow component to the toolbox?

  A. You should use the REGSVR32 utility to register the assembly by using
  B. You should copy the assembly to the appropriate folder
  C. The assembly should be added to the Global Assembly Cache
  D. You should use the Assembly Registration utility (REGASM.EXE) to register the assembly
  B. You should copy the assembly to the appropriate folder

• Question 103:

  You develop a series of SQL Server 2008 Integration Services (SSIS) packages. There are dependencies among the packages. You need to configure the packages. Which configuration type should you use?

  A. Parent package variable
  B. Registry entry
  C. Environment variable
  D. XML configuration file
  D. XML configuration file

• Question 104:

  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 a developer of a SQL Server 2008 Reporting Services (SSRS) for the company.

  You use SSRS to create a report with a table contained. Besides, the table contains alternate columns.

  Now you get an order from your company CIO, according to his requirement, you have to make sure the alternate columns have a light blue background.

  So of the following code segments, which one would be used for each text box?

  A. =iif(CountColumns() / 2, " lightblue ", "White") would be used for each text box.
  B. =iif(CountColumns() Mod 2, " lightblue ", "White") would be used for each text box
  C. =iif(ColumnNumber(Nothing) / 2, " lightblue ", "White") would be used for each text box
  D. =iif(ColumnNumber(Nothing) Mod 2, " lightblue ", "White") would be used for each text box.
  D. =iif(ColumnNumber(Nothing) Mod 2, " lightblue ", "White") would be used for each text box.

  ---

  IIf(expr, truepart, falsepart)

  All three parameters are required:

  expr is the expression that is to be evaluated.

  truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr returns false. The MOD function can be used to divide numbers in Excel. Unlike regular

  division, however, the MOD function only gives you the remainder as an answer.

  The syntax for the MOD function is:

  = MOD ( Number , Divisor )

• Question 105:

  You are developing a SQL Server 2008 Integration Services (SSIS) package for Company.com. There is a development server called TestSQL in your package.

  For the development server and the production server, you could not move the information between them.

  When you publish the package to the TestSQL server.

  You get the error message below:The package could not link to the TestSQL server. You should make sure that you could alter the package to refer to the TestSQL server when being implemented.

  Which is the correct answer?

  A. You should change the attributes of the package to utilize the DontSaveSensitive package protection level.
  B. Before altering the connection string by hand you should change the deployment manifest file in Microsoft Notepad.
  C. You should choose the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then alter the connection string.
  D. You change the attribute of the package to utilize store procedure.
  C. You should choose the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then alter the connection string.

  ---

  Creating Package Connection Managers A package connection manager, sometimes simply called a package connection, is independent of project data sources. However, package connections can reference a project data source. A package connection lets the different components in SSIS communicate with an object (such as a database, file, or server) outside the package. You can use package connections as source adapters, FTP or e-mail servers, or flat files.

• Question 106:

  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, and you are in charge of a SQL Server 2008 Analysis Services (SSAS) database. A Duplicate Key error occurs when you process the Analysis Services

  database.

  As the technical support, you have to solve this problem. In order to make the error condition be reported and continue processing, the ErrorConfiguration property has to be modified.

  So which object should be modified?

  A. The measure group should be modified
  B. The dimension should be modified
  C. The cube should be modified.
  D. The partition should be modified
  B. The dimension should be modified

• Question 107:

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

  The report contains a table.

  You need to ensure that alternate rows in the table have a pale green background.

  Which code segment should you use for each text box?

  A. =iif(RowNumber(Nothing) / 2, "PaleGreen", "White")
  B. =iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
  C. =iif(CountRows() / 2, "PaleGreen", "White")
  D. =iif(CountRows() Mod 2, "PaleGreen", "White")
  B. =iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")

• Question 108:

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

  Data from a SQL Server 2005 Analysis Services database will be displayed by the report.

  According to the requirement of the company CIO, you must make sure that member properties and extended properties are displayed by the report.

  So what should you do?

  A. The SQL Server Analysis Services data source should be used.
  B. The SQL Server data source should be used
  C. The OLE DB for SQL Server data source should be used.
  D. The OLE DB for the Analysis Services 8.0 data source should be used
  A. The SQL Server Analysis Services data source should be used.

• Question 109:

  You maintain an instance of SQL Server 2008 Reporting Services (SSRS). The instance contains several reports.

  You deploy a report project on the instance by using the Business Intelligence Development Studio (BIDS). You discover that the production data sources on the instance are replaced by the test data sources of the report project. You need to ensure that when the report project is deployed in future, the existing reports are unaffected.

  What should you do?

  A. Configure the OverwriteDataSources property.
  B. Configure the TargetServerURL property.
  C. Configure the TargetDataSourceFolder property.
  D. Configure the TargetReportFolder property.
  A. Configure the OverwriteDataSources property.

• Question 110:

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

  

  The Ownership column contains decimal values that represent percentage of ownership. The sum of all the values in the Ownership column for a single DimAccount member is 100%. You create the following measures:

  

  Ownership

  

  Amount

  You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the weighted value is calculated based on the Ownership measure.

  What should you do?

  A. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
  B. Set the FormatString property of the Amount measure to [Amount]*[Ownership].
  C. Set the MeasureExpression property of the Amount measure to [DimCustomer]. [Amount]*[Ownership].
  D. Set the FormatString property of the Amount measure to [DimCustomer]. [Amount]*[Ownership].
  A. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].