Microsoft
70-448 · Question #205
70-448 Question #205: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Question
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?
Options
- 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")
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.