Exam 70-767 topic 1 question 65 discussion

Actual exam question from Microsoft's 70-767

Question #: 65
Topic #: 1

You have a data warehouse named DW1.
In DW1, you plan to create a table named Table1 that will be partitioned by hour. Table1 will contain the last three hours of data.
You plan to implement a sliding window process for inserting data into Table1.
You need to recommend the minimum number of partitions that must be included in Table1 to support the planned implementation. The solution must minimize the number of transaction log records created during the insert process.
How many partitions should you recommend?

A. 3
B. 5
C. 9
D. 24

Show Suggested Answer

Suggested Answer: B 🗳️

by juansiclaro at March 4, 2020, 4:24 p.m.

Comments

Submit Cancel

irfanarifhussain

Highly Voted 5 years, 3 months ago

Table1 contain three hours of data, add two boundary partitions with it.

upvoted 8 times

Jrestrepo

4 years, 10 months ago

Are we assumming that within 9 hour (3 + the 2 boundry partitions) there will be a processing of partition every 3 hours. I thought the answer was 24/3 = 8 +1 = 9

upvoted 1 times

...

othman_ee

Highly Voted 4 years, 10 months ago

You have 3 partitions (3hours ->partitioned hourly). When you define 3 boundery values on a partition function it creates 4. (N+1 known as the catch-all partition). You need one additional partition for the archive. Hence 5.

upvoted 7 times

...

Lukis92

Most Recent 4 years, 7 months ago

"The minimum number of partitions that must be included in Table1 to support the planned implementation". Based on official 70-767 Microsoft book, archive data is keeping in the separated table, e.g. Table1_Archive. Therefore partition containing older data than 3 hours shouldn't be considered to calculate the number of separations in Table1. Assuming it's 8:00 a.m. right now and the sliding window partition process has just been completed. Table 1: 1 partition: <6:00, 7:00) 2 partition: <7:00, 8:00) 3 partition (newly created with no data): <8:00, 9:00) Table1_Archive Switched partition <5:00, 6:00) So I would choose A.

upvoted 1 times

...

Slava_bcd81

4 years, 8 months ago

"recommend the minimum number of partitions that must be included in Table1" -the minimum number of partitions is 3 - one partition for each hour, two boundaries So I would choose A

upvoted 2 times

...

juansiclaro

5 years, 3 months ago

Anyone knows why is 5? thanks a lot

upvoted 1 times

Slava_bcd81

4 years, 8 months ago

3 is too simple

upvoted 2 times

...