Microsoft인증 Dynamics-POS-2009 078-702시험은 등록하였는데 시험준비는 아직이라구요? Micros oft인증 Dynamics-POS-2009 078-702시험일이 다가오고 있는데 공부를 하지 않아 두려워 하고 계시는 분들은 이 글을 보는 순간 시험패스에 자신을 가지게 될것입니다. 시험준비 시간이 적다고 하여 패스할수 없는건 아닙니다.

 

 

 

NO.1 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.2 Which of the following is a global variable?
A. TimetoExecute
B. Constants
C. UserName
D. ReportName WCalibriTahomaZ
Answer: D

NO.3 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.4 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.5 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

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