nerdexam
Microsoft

70-460 · Question #19

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands: - High Yield…

The correct answer is E. Use an expression for the Style property of the vineyard text box. See the full explanation below for the reasoning.

Question

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:

  • High Yield
  • Medium Yield
  • Low Yield

You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield. You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values. What should you do?

Options

  • AUse an expression for the TextDecoration property of the vineyard text box.
  • BUse an expression for the Color property of the vineyard text box.
  • CAdd an indicator to the table.
  • DUse an expression for the Font property of the vineyard text box.
  • EUse an expression for the Style property of the vineyard text box.

How the community answered

(44 responses)
  • A
    14% (6)
  • B
    5% (2)
  • C
    2% (1)
  • D
    2% (1)
  • E
    77% (34)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice