Microsoft
70-457 · Question #30
You support a database structure shown in the exhibit. (Click the Exhibit button.) You need to write a query that displays the following details: - Total sales made by sales people, year, city, and…
The correct answer is C. Option C. The question about BlogEntry is wrong. We need to "append" the text, with the query proposal in the answer, we overwrite the whole string. The correct answer to this question is C.
Manage Data
Question
You support a database structure shown in the exhibit. (Click the Exhibit button.) You need to write a query that displays the following details:
- Total sales made by sales people, year, city, and country
- Sub totals only at the city level and country level
- A grand total of the sales amount
Which Transact-SQL query should you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(23 responses)- A9% (2)
- B17% (4)
- C70% (16)
- D4% (1)
Explanation
The question about BlogEntry is wrong. We need to "append" the text, with the query proposal in the answer, we overwrite the whole string. The correct answer to this question is C.
Topics
#GROUPING SETS#ROLLUP#aggregation#T-SQL
Community Discussion
No community discussion yet for this question.