Sample Questions

Data Analytics — 5 random MCQs with answers & explanations

← Back to Data Analytics

These 5 questions are randomly selected (standard MCQs only, not case-based).

Q1 What is a slowly changing dimension?

  • A. A dimension whose attributes change over time Correct Answer
  • B. A slow query
  • C. An unmodifiable table
  • D. A temporary CTE
Explanation:
Slowly changing dimension techniques manage historical changes to descriptive attributes.

Marks: 2

Q2 Which command is commonly used to inspect a query execution plan?

  • A. EXPLAIN Correct Answer
  • B. SHOW QUERY TEXT ONLY
  • C. PLAN QUERY ONLY
  • D. DESCRIBE SQL
Explanation:
EXPLAIN is widely supported for inspecting query execution strategies.

Marks: 1

Q3 What is partitioning in a large analytical table?

  • A. Dividing table data into partitions based on a key or range Correct Answer
  • B. Duplicating databases
  • C. Removing keys
  • D. Converting all data to text
Explanation:
Large tables can be partitioned by date, range, list, or another supported strategy.

Marks: 2

Q4 Which function returns the first value in a window frame?

  • A. FIRST_VALUE() Correct Answer
  • B. FIRST_ROW()
  • C. MIN_ROW()
  • D. START_VALUE()
Explanation:
FIRST_VALUE returns an expression's value from the first row of the window frame.

Marks: 2

Q5 How can several business metrics be calculated in one grouped query?

  • A. Conditional aggregation Correct Answer
  • B. Multiple database creation commands
  • C. CROSS JOIN only
  • D. ORDER BY only
Explanation:
Multiple conditional SUM or COUNT expressions can calculate several metrics together.

Marks: 2

Start Mock Tests →

Explore More Mock Tests

Practice structured mock tests designed like real professional exams.

Browse All Subjects Start Free Test

Free account · Login to start mocks

Create a free ExaPrac account

Register to start exam-style mock tests, save your scores, and compare attempts.

Register free