MCQ Collection
Data Warehousing and Business Intelligence MCQs
Practice Data Warehousing and Business Intelligence questions with answers and explanations.
Choose an option to check your answer.
A.
Divide sales by ROW_NUMBER()
B.
Use COUNT(*) as the denominator
C.
Divide regional sales by SUM(regional sales) OVER ()
D.
Apply DISTINCT to the sales amount
Show Answer
Correct Answer: C. Divide regional sales by SUM(regional sales) OVER ()
Explanation:
A window SUM over all result rows supplies the denominator while retaining each region.
Choose an option to check your answer.
A.
Assign a different bright color to every mark
B.
Use red and green without considering accessibility
C.
Use it consistently and sparingly to encode meaning or draw attention
D.
Change category colors between every chart
Show Answer
Correct Answer: C. Use it consistently and sparingly to encode meaning or draw attention
Explanation:
Consistent color semantics reduce cognitive load and support rapid interpretation.
Choose an option to check your answer.
A.
A process that physically divides database files
B.
A DAX function that deletes rows
C.
An on-canvas control that lets users filter report visuals interactively
D.
A tool for creating surrogate keys
Show Answer
Correct Answer: C. An on-canvas control that lets users filter report visuals interactively
Explanation:
Slicers expose filter choices directly on a report page.
Choose an option to check your answer.
A.
Give every analyst database-owner rights
B.
Share one administrator account across departments
C.
Grant each user only the access necessary for assigned responsibilities
D.
Disable all audit logs
Show Answer
Correct Answer: C. Grant each user only the access necessary for assigned responsibilities
Explanation:
Least privilege limits accidental and malicious misuse of data or systems.
Choose an option to check your answer.
A.
Returns the fourth row only
B.
Calculates four different totals
C.
Removes every fourth row
D.
Assigns rows as evenly as possible to four numbered buckets
Show Answer
Correct Answer: D. Assigns rows as evenly as possible to four numbered buckets
Explanation:
NTILE divides ordered rows into a requested number of groups.
Choose an option to check your answer.
A.
A long explanatory paragraph
B.
A complex SQL query
C.
A hidden worksheet formula
D.
A distinctly different color or size detected rapidly before conscious reading
Show Answer
Correct Answer: D. A distinctly different color or size detected rapidly before conscious reading
Explanation:
Preattentive attributes such as color, position, and size can make exceptions stand out immediately.
Choose an option to check your answer.
A.
A method for rebuilding indexes
B.
A new source-system transaction screen
C.
A replacement for all report tooltips
D.
A detail page filtered to the context selected in another visual
Show Answer
Correct Answer: D. A detail page filtered to the context selected in another visual
Explanation:
Drill-through passes selected category context to a dedicated detail page.
Choose an option to check your answer.
A.
A rule that every table contains one row
B.
A requirement that dashboards use row charts
C.
A physical division of tables into files
D.
A predicate that limits which table rows a user can read or modify
Show Answer
Correct Answer: D. A predicate that limits which table rows a user can read or modify
Explanation:
Row-level security applies data-access rules inside the database engine.
Choose an option to check your answer.
A.
The expression value from the first row of the defined ordered frame
B.
The smallest value regardless of ordering
C.
The first physical row stored on disk
D.
A unique key generated by SQL Server
Show Answer
Correct Answer: A. The expression value from the first row of the defined ordered frame
Explanation:
FIRST_VALUE follows the window ordering and frame definition.
Choose an option to check your answer.
A.
Users can interpret and move through them with less cognitive effort
B.
Consistency guarantees data accuracy
C.
It eliminates the need for definitions
D.
It forces every page to show the same metrics
Show Answer
Correct Answer: A. Users can interpret and move through them with less cognitive effort
Explanation:
Consistent conventions let users transfer learned meanings across pages.
Choose an option to check your answer.
A.
A saved report state including filters, visibility, and navigation context
B.
A permanent copy of every source transaction
C.
A database backup chain
D.
An SSIS package configuration only
Show Answer
Correct Answer: A. A saved report state including filters, visibility, and navigation context
Explanation:
Bookmarks preserve a designed view of the report.
Choose an option to check your answer.
A.
Obscure sensitive field values from nonprivileged query users while retaining stored data
B.
Encrypt backups with an unrecoverable key
C.
Delete sensitive columns permanently
D.
Prevent authorized users from seeing full values
Show Answer
Correct Answer: A. Obscure sensitive field values from nonprivileged query users while retaining stored data
Explanation:
Masking changes the displayed representation according to permissions.
