Power BI and SQL

What is the SQL command to return the values from a table?

• DISTINCT

• SELECT

• WHERE

• ORDER BY

What is the SQL expression used to count the values in a table?

• COUNT

• SUM

• AVERAGE

• DISTINCT

Which of these values would be matched using the syntax LIKE "%apple" (Multiple Answers)

• peach apple

• peach apple pie

• apple pie

• starapple

• banapple

What expression is used to indicate the table where the values would be searched from?

• TABLE

• WHERE

• FROM

• SELECT

What DAX function can be used to return a value in a column if a condition is met?

• SUM

• IF

• VLOOKUP

• COUNT

What symbol would you use for multiplication in Power BI in a DAX formula? (also in SQL)

• *

• +

• -

• /

What topics do you need a review on to be able to make your dashboard and slides for your final project better? You can provide multiple topics. (No points)