exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 58 discussion

Actual exam question from Microsoft's 70-761
Question #: 58
Topic #: 1
[All 70-761 Questions]

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You create a table by running the following Transact-SQL statement:

You are developing a report that aggregates customer data only for the year 2014. The report requires that the data be denormalized.
You need to return the data for the report.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

E.

F.

G.

H.

Show Suggested Answer Hide Answer
Suggested Answer: G

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DEBRA
Highly Voted 5 years, 3 months ago
Answer is D
upvoted 11 times
...
Vermonster
Most Recent 4 years, 4 months ago
Answer is E (looks like D but 5th answer) - SELECT FROM WHERE GROUP BY - creates aggregated data that is denormalized because it is aggregated
upvoted 1 times
Vermonster
4 years, 4 months ago
D (PIVOT) would work if YEAR(DateCreated) IN [2014] but year isn't specified. It is a valid PIVOT construct though because of the SELECT * FROM (SELECT....) AS
upvoted 1 times
...
...
Andy7622
4 years, 4 months ago
G doesn't have aggregated data
upvoted 1 times
...
ASQL
4 years, 6 months ago
G is the correct answer
upvoted 1 times
Andy7622
4 years, 5 months ago
What is your point?
upvoted 1 times
...
...
stijn5454
4 years, 10 months ago
G does not give you aggregated data (i.e. no SUM, AVG, etc. included). Answer D does give you aggregated, denormalized data. However, I agree that answer D also has flaws so none of the answers seem correct.
upvoted 3 times
...
Anette
4 years, 11 months ago
Why not H?
upvoted 1 times
Anette
4 years, 11 months ago
sorry, it is required data (means valid to and from) not date created. Probably its G
upvoted 1 times
...
...
AshleyLiang
5 years, 8 months ago
As denormalized data is required I'm not sure if G contains that while D is not a valid pivot query.
upvoted 4 times
M4x
5 years, 8 months ago
I suppose that in this question Denormalize mean no ValidFrom, ValidTo column on result
upvoted 2 times
...
Andy7622
4 years, 5 months ago
D also specifies DateCreated, that is not mentioned in the requirements
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago