nerdexam
Microsoft

70-448 · Question #161

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…

The correct answer is A. MSAS 2008: Proc Aggregations would be used to achieve this goal. performancecounters

Maintain a BI Solution

Question

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Analysis Services (SSRS) for the company. You are in charge of a SSAS database that is contained on a default instance. According to your plan, the Analysis Services performance information will be documented by the computer. In order to achieve this goal, information related to the temporary file usage should be collected at the time of processing the database. So of the following objects, which one object should be used?

Exhibit

70-448 question #161 exhibit

Options

  • AMSAS 2008: Proc Aggregations would be used to achieve this goal
  • BMSAS 2008: Storage Engine Query would be used to achieve this goal
  • CMSAS 2008: Memory would be used to achieve this goal
  • DMSAS 2008: Cache would be used to achieve this goal

How the community answered

(40 responses)
  • A
    78% (31)
  • B
    8% (3)
  • C
    13% (5)
  • D
    3% (1)

Explanation

performancecounters

Topics

#SSAS performance counters#Proc Aggregations#performance monitoring#processing

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice