70-768 Table Practice Questions
The free 70-768: Developing SQL Data Models questions that deal with table, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #4
When designing a model, what should the primary key in a dimension table be?
Correct answer: B
Explanation
The primary key in a dimension table should be a unique identifier to ensure data integrity.
Question #6
What is the role of a fact table in a data model?
Correct answer: C
Explanation
A fact table is primarily used to store measurable data, often including foreign keys to dimension tables.
Question #7
Which DAX function would you use to filter a table in a report?
Correct answer: D
Explanation
The FILTER function allows you to apply conditions to a table and retrieve specific data for reports.
Continue with 70-768: Developing SQL Data Models
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 70-768: Developing SQL Data Models, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.