Free Preparation Discussions
MENU
Databricks Certified Data Analyst Associate Exam - Topic 4 Question 17 Discussion
Topic #: 4
A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every 10 minutes.
A data analyst has created a dashboard based on this gold level dat
a. The project stakeholders want to see the results in the dashboard updated within 10 minutes or less of new data becoming available within the gold-level tables.
What is the ability to ensure the streamed data is included in the dashboard at the standard requested by the project stakeholders?
The result set provided shows a combination of grouping by two columns (group_1 and group_2) with subtotals for each level of grouping and a grand total. This pattern is typical of a GROUP BY ... WITH ROLLUP operation in SQL, which provides subtotal rows and a grand total row in the result set.
Considering the query options:
A) Option A: GROUP BY group_1, group_2 INCLUDING NULL - This is not a standard SQL clause and would not result in subtotals and a grand total.
B) Option B: GROUP BY group_1, group_2 WITH ROLLUP - This would create subtotals for each unique group_1, each combination of group_1 and group_2, and a grand total, which matches the result set provided.
C) Option C: GROUP BY group_1, group 2 - This is a simple GROUP BY and would not include subtotals or a grand total.
D) Option D: GROUP BY group_1, group_2, (group_1, group_2) - This syntax is not standard and would likely result in an error or be interpreted as a simple GROUP BY, not providing the subtotals and grand total.
E) Option E: GROUP BY group_1, group_2 WITH CUBE - The WITH CUBE operation produces subtotals for all combinations of the selected columns and a grand total, which is more than what is shown in the result set.
The correct answer is Option B, which uses WITH ROLLUP to generate the subtotals for each level of grouping as well as a grand total. This matches the result set where we have subtotals for each group_1, each combination of group_1 and group_2, and the grand total where both group_1 and group_2 are NULL.
Sonia
7 days agoRickie
13 days agoYolande
19 days agoGail
24 days agoNobuko
29 days agoLuann
1 month agoEleonora
1 month agoEstrella
1 month agoLuis
1 month agoTheola
1 month agoLasandra
1 month agoFrancis
2 months agoElden
2 months agoAlbina
6 months agoLauryn
6 months agoJustine
5 months agoVanesa
5 months agoBen
5 months agoJosphine
7 months agoJeffrey
5 months agoVanna
5 months agoDeeann
5 months agoParis
7 months agoParis
7 months agoTamie
5 months agoGladys
5 months agoFanny
6 months agoBettye
6 months agoGwen
7 months agoDestiny
7 months agoLeana
7 months ago