nerdexam
Microsoft

70-460 · Question #21

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database…

The correct answer is A. SQL Server spatial query. See the full explanation below for the reasoning.

Question

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database. The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.) You need to ensure that the report displays only a user selected map region. Which source of spatial data should you use for the map?

Exhibit

70-460 question #21 exhibit

Options

  • ASQL Server spatial query
  • BESRI shape file
  • CMap gallery
  • DBing Maps layer

How the community answered

(29 responses)
  • A
    83% (24)
  • B
    3% (1)
  • C
    10% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice