Ultimate access to all questions.
Contoso, Ltd. is a health supplements company based in the US, and it is structured into two divisions: Sales and Research. The Sales division consists of two departments, namely Online Sales and Retail Sales, while the Research division assigns internally developed product lines to individual teams of researchers and analysts. Contoso utilizes a Microsoft Entra tenant named contoso.com, which includes two groups: ResearchReviewersGroup1 and ResearchReviewersGroup2. The Sales division leverages Microsoft Power BI Premium capacity. The semantic model within the Online Sales department features a fact table named Orders, operating in Import mode. Within the system of origin, the OrderID value signifies the sequence in which orders are created. The Research division relies on an on-premises, third-party data warehousing solution. Fabric is enabled for the contoso.com tenant. An Azure Data Lake Storage Gen2 account named storage1 stores data for a product line called Productline1 within the Research division, formatted in the delta format. Another Data Lake Storage Gen2 account named storage2 holds data for a product line called Productline2, presented in CSV format.
Contoso plans the following changes:
Contoso has identified these data analytics requirements:
Data preparation requirements identified by Contoso include:
Requirements for implementing and managing semantic models include:
High-level requirements identified by Contoso for all solutions include:
Which syntax should you use in a notebook to access the Research division data for Productline1?