Pass4Test의 Microsoft 078-702 (Designing and Managing a Microsoft Business Intelligence Solu tion) 시험대비 덤프는 가격이 착한데 비하면 품질이 너무 좋은 시험전 공부자료입니다. 시험문제적중율이 높아 패스율이 100%에 이르고 있습니다.다른 IT자격증에 관심이 있는 분들은 온라인서비스에 문의하여 덤프유무와 적중율등을 확인할수 있습니다. Microsoft 078-702 (Designing and Managing a Microsoft Business Intelligence Solution) 덤프로 어려운 시험을 정복하여 IT업계 정상에 오릅시다.

 

 

 

 

 

NO.1 A total count of active statuses needs to be displayed that would look at the status column
and determine which row to add based on the Active status flag.
What is the correct expression?
A. =IIF (Fields!Status.Value="Active",Sum(Fields!Status.Value),"")
B. =Sum (IIF(Fields!Status.Value = "Active", 1, 0))
C. =IF (Fields!Status.Value="Active",Sum(Fields!Status.Value),"")
D. =Sum (IF(Fields!Status.Value = "Active", 1, 0)) WCalibriTahomaZ
Answer: B

NO.2 Which scorecard templates design is based on values defined by users in the KPI wizard?
A. Analysis Services
B. Blank Scorecard
C. SharePoint List
D. Fixed Value WCalibriTahomaZ
Answer: D

NO.3 Several actions were created on the cube using different target types.
What action would be supported by the analytic grid?
A. Cube
B. Level
C. Hierarchy
D. Cell WCalibriTahomaZ
Answer: D

NO.4 Which of the following is true about publishing SSRS reports to a SharePoint library? Choose
the 2 that apply.
A. The report can be published using either Report Designer or SharePoint site actions.
B. Files are validated before being published.
C. The name extension changes when a shared data source file is published to a SharePoint site.
D. Subreports can reside in a different folder than the main report on a SharePoint site.
WCalibriTahomaZ
Answer: BC

NO.5 A user was added to the Report Builder role. Which of the following tasks would the user not
have access to?
A. Consume reports
B. Manage individual subscriptions
C. Manage reports
D. View folders WCalibriTahomaZ
Answer: C

NO.6 Which of the following is true about actions in SSRS? Choose the 2 that apply.
A. Parameters cannot be passed when the action is used to go from one report to another.
B. Expression can be used to open a dynamically-created URL.
C. Bookmark action allows users to go to another area of the report.
D. Actions cannot be conditionally executed. WCalibriTahomaZ
Answer: BC

NO.7 Which of the following is true about parameters in SSRS? Choose the 2 that apply.
A. Report parameter can be used as an input parameter for the stored procedure.
B. Parameters cannot be passed from one query to another to populate another report parameter.
C. Parameters can be used as dataset filters.
D. Parameters collection cannot be accessed through expressions. WCalibriTahomaZ
Answer: A,C

NO.8 Which of the following is a global variable?
A. TimetoExecute
B. Constants
C. UserName
D. ReportName WCalibriTahomaZ
Answer: D

NO.9 Which of the following is true about data regions in SSRS? Choose the 2 that apply.
A. Multiple data regions from the same report dataset can be linked if identical expressions and
scopes for the appropriate filter expressions, sort expressions and group expressions are used.
B. Data region can aggregate data from multiple datasets.
C. One data region can be nested inside another one.
D. Subtotals cannot be created in a matrix data region WCalibriTahomaZ
Answer: A,C