Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 151:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services database. You should alter the ErrorConfiguration attribute in order to make processing run normally.

  Which is the correct answer?

  A. You should alter the Dynamic Management View (DMV)
  B. You should alter the Local Group
  C. You should alter the dimension
  D. You should alter the Transactions Log
  C. You should alter the dimension

• Question 152:

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

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

  Now you are in charge of a SQL Server 2008 Reporting Services (SSRS) instance. Currently the network security model of the instance under the domain has changed. Your manager requires you to make sure that only Kerberos

  authentication will be supported by the instance.

  In order to meet the requirements, what action should you perform?

  A. You should use Microsoft SQL Server Management Studio (SSMS) to edit the Server Settings.
  B. You should edit the Site Settings of the instance
  C. You should edit the RSReportServer.config file
  D. You should edit the rssrvpolicy.config file.
  E. You should use the Report Manager to edit the Site Settings of the instance
  C. You should edit the RSReportServer.config file

• Question 153:

  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."
  C. Configure the report to use stored credentials.

• Question 154:

  You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.

  You develop a package named Memberinformation.dtsx with Windows authentication.

  You deploy it to SQL Server. You need to validate Memberinformation.dtsx packages without package execution.

  Which command syntax should you use?

  A. dtexec /sq Memberinformation /verifyv {a400e860-38d5-11c5-11ce-ae62-08002b2b79ef}
  B. dtexec /sq Memberinformation /ser productionServer /va
  C. dtexec /f "Z:\Memberinxormation.dtsx" /conf "Z:\Memberiniormationconfig.cfg"
  D. dtexec /f "2:\Member^nformation.dtsx" /l "DTS.LogProviderTextFile;2:\loginformation.txt"
  C. dtexec /f "Z:\Memberinxormation.dtsx" /conf "Z:\Memberiniormationconfig.cfg"

• Question 155:

  You are creating a SQL Server 2008 Reporting Services (SSRS) report which would be contained in the application which is distributed to remote users who own no access to the server for Company.com.

  You should make sure that the application produces the report normally. Which is the correct answer?

  A. You should utilize the ReportViewer control together with the LocalReport property.
  B. You should utilize the LocalReport control.
  C. You should utilize the SQL Server 2008 Integration Services (SSIS).
  D. You should utilize the store procedure.
  A. You should utilize the ReportViewer control together with the LocalReport property.

• Question 156:

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

  The organization requires a drilldown report that color coordinates the values of students' test scores. All average scores 70% or higher should have a green background. All lower average scores should have a red background.

  You need to enable this functionality.

  Which expression should you use?

  A. =iif(Fields!TestScore.Value >=.70, Green, Red)
  B. =iif(Fields!TestScore.Value >=.70 THEN "Green" ELSE "Red")
  C. =iif(avg(FieldsSTestScore.Value)>=.70 THEN "Green" , "Red")
  D. =iif(avg(Fields!TestScore.Value)>=.70,"Green","Red")
  C. =iif(avg(FieldsSTestScore.Value)>=.70 THEN "Green" , "Red")

• Question 157:

  You install and configure a SQL Server 2008 Reporting Services (SSRS) instance on a server named ReportServer in the domain ABC.Com. SSRS is using a local database. You need to set SSRS to use a new domain user account named ReportUser. The password for ReportUser is Alphabet01.

  Which script should you run?

  A. rsconfig -c -m ReportServer -s ReportServer -d reportserver -a SQL -u abc.com\ReportUser -p Alphabet01
  B. rsconfig -c -s ReportServer -d reportserver -a Windows -u abc.com\Report03er -p Alphabet01
  C. rsconfig -c -s ReportServer -d reportServer -a Windows "abc.com\ReportUser Alphabet01"
  D. rsconfig -c -ra
  B. rsconfig -c -s ReportServer -d reportserver -a Windows -u abc.com\Report03er -p Alphabet01

• Question 158:

  You are changing a SQL Server 2008 Integration Services (SSIS) instance which get information from a doc file and loads this information to a SQL Server 2008 table for Company.com. The information is listed below:

  

  You should make sure that you could modify the instance to get data from many text files of the same directory.

  Which is the correct answer? (Select more than one)

  A. You should increase a parameter to the package.
  B. You should increase a parameter to the data flow task.
  C. You should increase a Foreach Loop container to the package.
  D. You should increase a While container to the package.
  E. You should increase some expressions to the Flat File Source component.
  F. You should increase an expression to the Flat File connection manager.
  A. You should increase a parameter to the package.
  C. You should increase a Foreach Loop container to the package.
  F. You should increase an expression to the Flat File connection manager.

• Question 159:

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

  You plan to update only the Products dimension while processing the cube by using an XML for Analysis (XMLA) script.

  You need to ensure that only the dimensions are updated.

  What should you do?

  A. Execute a processDefault command.
  B. Execute a processlndex command.
  C. Execute a processUpdate command.
  D. Execute a processStructure command.
  C. Execute a processUpdate command.

• Question 160:

  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.

  To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution with a measure group contained.

  The measure group named Meatruth has a single partition. Now you are asked to not only make sure you have all aggregations that are part of the measure group stored in a multidimensional format, but also make sure the queries that use the measure group always refer to the newest edition of the source detail data. So what action should you perform to achieve that goal?

  A. You should set the ProactiveCaching property of the partition to scheduled multidimensional online analytical processing (MOLAP).
  B. You should set the ProactiveCaching property of the partition to real-time multidimensional online analytical processing (MOLAP)
  C. You should set the ProactiveCaching property of the partition to real-time hybrid online analytical processing (HOLAP).
  D. You should set the ProactiveCaching property of the partition to real-time relational online analytical processing (ROLAP)
  E. You should set the ProactiveCaching property of the partition to automatic multidimensional online analytical processing (MOLAP).
  C. You should set the ProactiveCaching property of the partition to real-time hybrid online analytical processing (HOLAP).

  ---

  HYBRID OLAP As its name suggests, HOLAP is a hybrid between MOLAP and ROLAP. In HOLAP, the cube data remains in the relational store, but the aggregations are stored on the SSAS server. HOLAP is the most effi cient mode in terms of disk space because detail-level data is not duplicated, as it is with MOLAP, and HOLAP requires less space to store aggregations than ROLAP does.

  EXAM TIP Choose the HOLAP storage mode if you want to store cube aggregations on the SSAS server but keep the fact data in the source database. ----------------------------------------------------------------------------------------------------------------- In terms of query performance, HOLAP scores in the middle. If the query can be satisfi ed entirely by existing aggregations, HOLAP performs as well as MOLAP. But if it cannot be satisfied, the query is sent to the relational database, and performance suffers. In terms of processing times, HOLAP cubes might be processed faster than either MOLAP or ROLAP cubes because data is read only once to create aggregations. However, because SSAS has an efficient storage architecture, in real life MOLAP and HOLAP should give you comparable processing times, so it is best to consider HOLAP only for large historical partitions that are queried infrequently.