Power BI and SQL

Power BI and SQL

Professional Development

7 Qs

quiz-placeholder

Similar activities

Data Analysis Expressions

Data Analysis Expressions

Professional Development

10 Qs

BAnDS Tournament Round 3

BAnDS Tournament Round 3

University - Professional Development

10 Qs

SQL basics

SQL basics

Professional Development

12 Qs

QUIS GDC Surabaya

QUIS GDC Surabaya

Professional Development

11 Qs

SQL Sentencias

SQL Sentencias

Professional Development

8 Qs

Review

Review

Professional Development

10 Qs

Famous Spouses

Famous Spouses

7th Grade - Professional Development

10 Qs

Power BI Quiz

Power BI Quiz

Professional Development

10 Qs

Power BI and SQL

Power BI and SQL

Assessment

Quiz

Other

Professional Development

Medium

Created by

Eduardo Edralin

Used 49+ times

FREE Resource

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

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

DISTINCT

SELECT

WHERE

ORDER BY

2.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

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

COUNT

SUM

AVERAGE

DISTINCT

3.

MULTIPLE SELECT QUESTION

10 sec • 1 pt

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

peach apple

peach apple pie

apple pie

starapple

banapple

4.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

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

TABLE

WHERE

FROM

SELECT

5.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

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

SUM

IF

VLOOKUP

COUNT

6.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

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

*

+

-

/

7.

OPEN ENDED QUESTION

1 min • 1 pt

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)

Evaluate responses using AI:

OFF