Microsoft
70-779 · Question #70
You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal: - 40 - 1 - 999…
The correct answer is A. Configure the Data Type. See the full explanation below for the reasoning.
Question
You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal:
- 40
- 1
- 999
- 7658
- 883432
You need to ensure that when you load the data to the model, LineTotal is set as currency. What should you do from Query Editor?
Options
- AConfigure the Data Type
- BRound the column.
- CSplit the column by characters.
- DSplit the column by delimiter.
How the community answered
(38 responses)- A74% (28)
- B8% (3)
- C16% (6)
- D3% (1)
Community Discussion
No community discussion yet for this question.