SQL / MySQL
What SQL statement is used to extract data from a database?
Can you have more than 2 active relationship between 2 tables?
NO
What SQL statement is used to edit a view or stored procedure?
ALTER
Give atleast 3 example of Power BI Visualizations
Pie Chart, Bar Chart, Donut Chart, Stacked Bar Chart... etc
What SQL statement is used to return only different values? (SELECT Unique, SELECT Distinct or SELECT Different)
Distinct
What is the difference between SUM and SUMX?
The sum function (Sum()) takes the data columns and aggregates them totally but the SumX function (SumX()) lets you filter the data which you are adding.
How can you return all the records from a table named sorted alphabetically?
ORDER BY
Give atleast 3 example of Power BI Common Data Sources
Excel, ODBC, csv, OData, Web, Sharepoint...
The OR operator displays a record if ANY conditions listed are true.
Give 3 example of DAX Time Intelligence
DATEADD, MTD, YTD, DATEDIFF
The AND operator displays a record if ALL of the conditions listed are true.
What is the schema commonly used in Power BI?
Star Schema
How can you return the number of records in the table?
SELECT COUNT(*)
What is the difference between filters and slicers?
Using Normal filters users were not allowed to interact with dashboards or reports, but using slicers we can interact with dashboards and reports.
Give atleast 3 types of Join
INT, VARCHAR, DATE, DATETIME, TEXT
Difference between VIEW and STORED PROCEDURE
A view is faster as it displays data from the tables referenced whereas a store procedure executes sql statements.
What are the 2 types of data pulling in Power BI?
Direct Queries and Import Queries
Select a WHERE statement you'll only get values starting with P
WHERE Column LIKE 'P%'
Give atleast 2 common indexes used in MySQL and SQL
WHERE, ORDER BY, GROUP BY, MIN, MAX...