Using M Language

M Language stands for...

• Data Merging

• Data Mash-Up

• Data Modelling

What is the value of z?

• 5

• 2

• 10

• 7

What is the purpose of the instruction

Table.SelectRows(#"RenamedCols", each [Age] <> "NA")?

• To keep all the rows where Age is equal to NA

• To count the number of rows where Age is equal to NA

• To count the number of rows where Age is NOT equal to NA

• To keep all the rows where Age is NOT equal to NA

The value of t is 12

• True

• False

Which one is better?

• DAX

• M language

• M language is more appropriate for data preprocessing, DAX for data analytics

• M language is more appropriate for data analytics, DAX for data preprocessing

Which of the following applies to the M language on the left?

• The M formula is correct

• You cannot use the ">" operator

• yes and no should be "yes" and "no"

• "else" should be "otherwise"