What should you do from Query Editor?

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?
A . Configure the Data Type
B . Round the column.
C . Split the column by characters.
D . Split the column by delimiter.

View Answer

Answer: A