Azure Synapse database templates are organized by "business areas," which are broader groupings that include various tables related to specific aspects of a business or industry.
While "facts and dimensions" are a part of the overall data modeling process within these business areas, the question specifically asks about the grouping method used in the template tables. Therefore, the grouping method for adding additional tables to an Azure Synapse database template would align with the business areas defined within the template, making option B, "business area," the most appropriate choice given the context of the question and the structure of the Synapse database templates.
The answer is right below the first image in the documentation:
https://learn.microsoft.com/en-us/azure/synapse-analytics/database-designer/overview-database-templates
B. business area
This is a common approach where tables are grouped based on the business areas or domains they belong to, making it easier to manage, organize, and understand the structure of the database.
This grouping applies to data warehouse star/snowflake schemas, not lake databases
upvoted 1 times
...
...
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.
vernillen
Highly Voted 6 months, 4 weeks agothe_frix
5 months agoELJORDAN23
Highly Voted 7 months, 1 week agoDusica
Most Recent 4 months agoAlongi
4 months, 1 week agosdg2844
7 months, 1 week agomoize
7 months, 2 weeks agoFilda123
7 months, 2 weeks agodakku987
7 months, 2 weeks agojongert
7 months, 3 weeks agomrplmcc
7 months, 3 weeks agoihmot
6 days, 8 hours ago