Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

What is partitioning in a data warehouse?

A Dividing a large table into segments, usually by date, so queries scan less data
B Splitting the database across servers
C Encrypting sensitive columns
D Duplicating tables for redundancy

Answer

Dividing a large table into segments, usually by date, so queries scan less data

Partition pruning lets the engine skip irrelevant segments entirely, which is the main reason date filters perform well on huge tables.

All Data Warehousing MCQs

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer