NEW
Font size
WorksheetsEDTS End of program assessment
Total questions: 27
Worksheet time: 14mins
Which SQL command is used to create a new table?
UPDATE
SELECT
CREATE TABLE
INSERT
In SQL, which keyword is used to remove all rows from a table without deleting the table itself?
ALTER
DELETE
DROP
TRUNCATE
What does a PRIMARY KEY ensure in a table?
Foreign key relationship
Uniqueness of each row
Multiple identical values
Allows NULL values
What is the correct SQL code to select all columns from a table named students?
SELECT ALL FROM students;
SELECT * FROM students;
GET * FROM students;
SHOW ALL students;
Which JOIN returns only rows that exist in both tables?
FULL OUTER JOIN
RIGHT JOIN
INNER JOIN
LEFT JOIN
Which SQL function returns the year from a date column?
DATE()
DAY()
YEAR()
MONTH()
If you want to show all rows from the left table and only matching rows from the right table, which JOIN should you use?
FULL OUTER JOIN
RIGHT JOIN
LEFT JOIN
INNER JOIN
Which command is correct for adding a new column to an existing table?
INSERT INTO employees ADD hire_year INT;
MODIFY TABLE employees ADD hire_year INT;
ALTER TABLE employees ADD hire_year INT;
UPDATE TABLE employees ADD hire_year INT;
What will this query return? SELECT hire_weekday, COUNT (*) FROM employees_table GROUP BY hire_weekday;
Number of employees grouped by weekday hired
All employees with NULL hire dates
All weekdays in a year
The total salary per weekday
Which statement about FOREIGN KEYS is true?
They always cascade deletes automatically.
They allow duplicate primary keys.
They connect rows in one table to rows in another.
They must always be unique.
What function removes extra spaces from a text string?
REMOVE
CLEAN
TRIM
SUBSTITUTE
Which feature allows you to eliminate duplicate entries in a dataset?
Flash Fill
Sort
Remove Duplicates
Data Validation
Which tool splits data into columns based on a delimiter?
Column Break
Data Split
Separate Data
Text to Columns
Which function joins text from multiple cells?
GROUP
LINK
SPLIT
CONCATENATE
What function counts numeric values in a range?
COUNTIF
SUM
COUNTA
COUNT
What is used to refer to a fixed cell in a formula?
INDIRECT
Relative Reference
Dynamic Range
Absolute Reference
Which chart is best to show parts of a whole?
Bar
Line
Area
Pie
How do you apply a color scale to values?
Use Themes
Data Bars
Use Cell Styles
Conditional Formatting
In a star schema, which type of table stores descriptive attributes like “product name” or “customer Name”?
Report View
Fact Table
Bridge Table
Dimension Table
Which of the following is a valid DAX function for creating calculated columns or measures?
SUM
AVERAGE
SUMX
SUMSQ
SUMIF
What is the main purpose of normalization in database?
To reduce data redundancy and improve data integrity
To simplify database queries by combining tables
To create complex data relationships between tables
To create data redundancy and increase duplicates
Which of the following is TRUE about DAX measures
DAX measures are only gotten with calculated columns
Dax measures are simplified context commands to derive a standing aggregation after a measure
DAX measures are calculations used in data models to perform data aggregations based on filter context
DAX measures are only gotten through basic mathematics functions and cannot be refreshed
Which of the following are examples of fact tables fields?
Customer name
Sales date
Sales amount
Store Location
Product category
What is the similarity between Excel and Power Bi
Both are for Word Processing.
Both are Data analysis tools
Power Bi has to do with Data-Modelling while Excel doesn’t.
Both are Microsoft products for Pivot Tables and mathematics
Which of the following is true in Data modelling
Data modelling excludes relationship among data entities
Data modelling involves creating a detailed representation of your data
Data modelling has a limit to roes and columns imported into Power Bi
Data modelling cannot work without data being normalized
Which operation is typically performed during data cleaning in Power BI?
Creating Null Values
Adding Duplicates
Removing Null Values
Removing Duplicates
Altering Duplicates
Which table in a star schema contains numeric transactional records used for aggregations?
Fact table
Bridge table
Dimension table
Report view
