Microsoft
70-433 · Question #125
70-433 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
You have a table named Products. The table contains a column named Color. You need to write a Transact-SQL statement that calculates the percentage of products of each product color. Which Transact-SQL statement should you use?
Options
- ASELECT Color
- BSELECT Color
- CSELECT Color, (COUNT() * 1.0)/ COUNT() OVER() AS PercentColor
- DSELECT Color, COUNT() * 1.0) / COUNT() OVER(PARTITION BY Color)
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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.