B is correct.
QuantityPerUnit column from the Products table is not necessary for the analysis.
Discontinued products may not be filtered out because OrderDetails can still have foreign key referencing to them (historical data must be kept).
In Option A, it's expected to be one row per CategoryID (dimension table) therefore grouping data using it would change nothing
In Option D, changing data type for OrderID column would break relationship between "Orders" and Order Details" tables (moreover, integer data type usually takes less space than text data type)
Filtering discontinued products could remove some rows from our data model (depending on how many discontinued products could be in the data table) but it would impact older reports in periods
where it could happen these products were not discontinued yet and there is a requirement "The reports must show historical data for the current calendar year and the last three calendar years."
The "QuantityPerUnit" field is not explicitely mentioned to be used in any report hence we can remove this entire column and save that storage in our data model
The QuantityPerUnit column from the Products table is not necessary for the analysis, so that is the correct answer. Filtering does not affect the size of the dataset, so as the grouping.
Filtering rows during import DOES affect the size of the dataset.
I think that the correct argumentation should be that discontinued products may not be filtered out because OrderDetails can still have foreign key referencing to them.
"The reports must show historical data" including discontinued products.
upvoted 8 times
...
...
...
...
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
fred92
Highly Voted 2 years, 6 months agoHoeishetmogelijk
Highly Voted 2 years, 4 months agojaume
Most Recent 5 months, 1 week agoDani_eL
1 year, 1 month agoShalaleh
2 years agoNisa93
2 years agolukelin08
2 years, 5 months agoTin123
2 years, 6 months agoivanb94
2 years, 5 months agoHoeishetmogelijk
2 years, 4 months agoerhard
2 years, 3 months ago