Free DP-500 Exam Braindumps

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.

Overview
Contoso, Ltd.is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.

Existing Environment

Data Infrastructure
Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines.

The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data.

Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool.

Users frequently query the Synapse Analytics workspace by using Transact-SQL.

User Problems
Contoso identifies the following user issues:

-Some users indicate that the visuals in Power BI reports are slow to render when making filter selections.
-Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.
-Users indicate that the data in Power BI reports is stale. You discover that the refresh process of the Power BI model occasionally times out.

Planned Changes
Contoso plans to implement the following changes:

-Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API.
-Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
-Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
-Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
-Deploy prebuilt datasets to Power BI to simplify the query experience of the customers.
-Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.

Overview
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and at its stores located in six countries.

Azure Resources
Litware has the following Azure resources:
•An Azure Synapse Analytics workspace named synapseworkspace1
•An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
•A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool
SQLDW contains a dimensional model that contains the following table.




SQLDW contains the following additional tables.




SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customeriD], dbo.Customer
[CustomerEmail], dbo.ProductfProductID] and dbo.Product[ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.

Power BI
Litware has a new Power Bl tenant that contains an empty workspace named Sales Analytics. All users have Power B1 Premium per user licenses.
IT data analysts are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company's sales analytics goals. The dataset will be refreshed every 30 minutes.

Analytics Goals
Litware identifies the following analytics goals:
•Provide historical reporting of sales by product and channel over time.
•Allow sales managers to perform ad hoc sales reporting with minimal effort.
•Perform market basket analysis to understand which products are commonly purchased in the same transaction.
•Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Litware plans to monitor the adoption of Power Bl reports over time. The company wants custom Power Bl usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.

Security Requirements
Litware identifies the following security requirements for the analytics environment:
•All the users in the sales department and the marketing department must be able to see Power B1 reports that contain market basket analysis and data about which customers are likely to purchase a product.
•Customer contact data in SQLDW and the Power B1 dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.
•Sales associates must be prevented from seeing the CustomerEmail column in Power B1 reports.
•Sales managers must be prevented from modifying reports created by other users. Development Process Requirements

Litware identifies the following development process requirements:

•SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
•Power Bl content must be deployed to test and production by using deployment pipelines.
•All SQL scripts must be stored in Azure Repos.

The IT data analysts prefer to build Power Bl reports in Synapse Studio.

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.

Overview
General Overview
Fabrikam, Inc. is a software company that develops educational software for higher education.

Organizational Structure
Fabrikam has the following business units:

•Finance and Accounting
•Sales and Marketing
•Operations
•Product

The Product business unit contains the following groups:

•User experience designers
•Software engineers
•Product managers
•Testers

The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team.

Existing Environment

Data Storage
Fabrikam has three Azure Synapse Analytics workspaces named workspace1prod, workspace1test, and workspace1dev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power BI.

The company imports the following files into the Data Lake Storage accounts:

•User experience data stored as JSON files
•Finance data stored as CSV files
•Sales data stored as CSV files

Reporting
Fabrikam has a Power BI tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQueiy datasets. All reports are interactive.

Fabrikam has three frequently used workspaces as shown in the following table.



The Corporate Data Models workspace contains a dataset named Financial Model that is used by reports in the P&L workspace. Financial Model is maintained by the enterprise analytics team. The Corporate Data Models workspace and the User Experience workspace have corresponding development and test workspaces.

User Problems
Administrators report an increase in the maintenance of Power BI tenant assets due to analysts in the Finance and Accounting business unit who create new Power BI datasets when the existing datasets already meet their needs.

Analysts in the Product business unit report the following issues:

•Datasets are published to the User Experience workspace, while the data sources reference workspace1test.
•The parsing of user experience data in Power Query is very slow.

The enterprise analytics team identifies two DAX measures in the Financial Model dataset that are consistently slow to execute. The team must identify all the reports that use the Financial Model dataset and notify the report owners of changes to the measures.

Members of the enterprise analytics team report that creating Power BI reports and adjusting tables and views in Azure Synapse is tedious because they must switch between the Power BI workspaces and the Azure Synapse workspaces.

The information security team identifies that the user experience data is being shared externally.

Requirements

Planned Changes
Fabrikam plans to implement the following changes:

•Power BI will be registered as a data source in Microsoft Purview.
•The analysts in the Product business unit will create a more automated process for deploying Power BI reports and datasets to the User Experience workspace.

The enterprise analytics team plans to perform the following tasks:

•Update the DAX calculations in the Financial Model dataset.
•Create views in the Azure Synapse workspaces to speed up the parsing of user experience data.
•Create and document the change management process for shared Power BI datasets.

Technical Requirements
From Microsoft Purview, analysts in all the business units must be able to see all the assets in the Power BI tenant and the Azure Synapse workspaces. Power BI asset information must include lineage to identify the data sources used by each report.

The information security team must identify all the Power BI reports and datasets that contain Personally Identifiable Information (PII).

Fabrikam requires a security solution for the Power BI tenant. The solution must meet the following requirements:

•Access to the tenant by external users must be approved by a manager and granted by the IT group.
•The external users must be prevented from publishing or modifying content in the tenant.
•Users must be prevented from sharing Power BI reports publicly to the internet.

The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.

This Exam Topic does not have a case study.