exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 96 discussion

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

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
✑ Date[Month] in the mmyyyy format
✑ Date[Date_ID] in the ddmmyyyy format
✑ Date[Date_name] in the mm/dd/yyyy format
✑ Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?

  • A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
  • B. Create a calculated column that uses the COUNTA(Order_ID) DAX formula.
  • C. Create a calculated column that uses the SUM(Order_ID) DAX formula.
  • D. Create a calculated measure that uses the SUM(Order_ID) DAX formula.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
CDL
4 years, 6 months ago
With Aggregator function, it's a measure. A is correct.
upvoted 4 times
...
Vi1125
4 years, 7 months ago
The number of orders = a measure output
upvoted 1 times
...
r8d1
4 years, 10 months ago
is the only option that is a measure, and a COUNT (not sum).
upvoted 1 times
...
Eric777
4 years, 11 months ago
I saw the same thing. The Order_ID field is typed as an integer. I would have used the Count function, not CountA. Did we miss something?
upvoted 1 times
...
coupet
5 years ago
The COUNTA function counts the number of cells in a column that are not empty. COUNTA(<column>) https://docs.microsoft.com/en-us/dax/counta-function-dax
upvoted 4 times
Kpn123
4 years, 5 months ago
COUNT counts how many cells in a range contain numeric data (numbers). COUNTA counts how many populated cells in a range (i.e. not blank). CountA can be applied both the numeric and string column.. So Answer is A
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