Pass Your Azure Enterprise Data Analyst Associate DP-500 Exam on Nov 25, 2023 with 150 Questions
DP-500 Free Exam Study Guide! (Updated 150 Questions)
Microsoft DP-500 exam is an excellent certification for individuals who are seeking to advance their career in data analytics and business intelligence. It is a challenging exam that requires candidates to have a strong understanding of various topics related to analytics solutions design and implementation. By passing DP-500 exam, individuals can demonstrate their expertise and knowledge in this field, which can help them to advance their career and increase their earning potential.
The DP-500 exam measures the candidate's ability to design and implement big data batch processing and real-time processing solutions, as well as design and implement data storage solutions. DP-500 exam also tests the candidate's ability to design and implement Azure data lake storage, Azure Stream Analytics, and Azure Synapse Analytics solutions, as well as design and implement Power BI solutions.
NEW QUESTION # 46
You have an Azure Synapse Analytics dedicated SQL pool and a Microsoft Purview account. The Microsoft Purview account has been granted sufficient permissions to the dedicated SQL pool. You need to ensure that the SQL pool is scanned by Microsoft Purview.
What should you do first?
- A. Create a data policy.
- B. Register a data source.
- C. Search the data catalog.
- D. Create a data share connection.
Answer: B
NEW QUESTION # 47
You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:
* Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource
* The workspace templates must be stored in the publish branch.
* A branch named dev123 will be created to support the development of a new feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 48
You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set Use datasets across workspaces to Enabled
- B. Publish the financial data to the web.
- C. Grant the Build permission for the financial data to each customer.
- D. Configure the FinData workspace to use a Power Bl Premium capacity.
Answer: A,D
Explanation:
Explanation
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 Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-admin-across-workspaces
Topic 2, Litware, Inc. 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.
NEW QUESTION # 49
You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.
You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?
- A. Create calculated columns in Dataset1.
- B. Normalize the tables in DB1.
- C. Denormalize the tables in DB1.
- D. Remove the relationships from Dataset1.
Answer: C
Explanation:
Denormalize to improve query performance.
Note: Normalization prevents data duplications, preserves disk space, and improves the performance of the disk I/O operations. The downside of the normalization is that the queries based on these normalized tables require more table joins.
Schema denormalization (i.e. consolidation of some dimension tables) for such databases can significantly reduce costs of the analytical queries and improve the performance.
NEW QUESTION # 50
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
Step 1: Install the on-premises data gateway (standard mode)
The personal mode is only for a single user, not to be used for a shared dataset.
Step 2: From powerbi.com, add a data source to the gateway clusters
After you install the on-premises data gateway, you can add data sources that can be used with the gateway.
Add a data source
Under Data Source Type, select SQL Server.
After you fill in everything, select Create. You can now use this data source for scheduled refresh or DirectQuery against a SQL Server that's on-premises. You see Created New data source if it succeeded.
Step 3: From powerbi.com, configure Dataset1 to use a data gateway.
Connect a dataset to a SQL Server database
In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network. Follow these steps to add your on-premises SQL Server database as a data source to a gateway and then connect your dataset to this data source.
Sign in to Power BI. In the upper-right corner, select the settings gear icon and then select Settings.
On the Datasets tab, select the dataset AdventureWorksProducts, so you can connect to your on-premises SQL Server database through a data gateway.
Expand Gateway connection and verify that at least one gateway is listed.
Under Actions, expand the toggle button to view the data sources and select the Add to gateway link.
On the Gateways management page, on the Data Source Settings tab, enter and verify the following information, and select Add.
On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
NEW QUESTION # 51
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
Step 1: From Power BI Desktop, create a role named Project Managers.
Create roles
You can define roles within Power BI Desktop.
Step 2: Open Tabular Editor
Under Tables, select the table to which you want to apply a DAX rule.
In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = "Value".
Step 3: From Power BI Desktop, add a DAX filter to the Project Managers role.
Step 4: For Table1, the Budget and Forecast columns, set the permissions to None.
Reference: https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION # 52
You have a Power BI workspace named Workspace1 that contains five dataflows.
You need to configure Workspace1 to store the dataflows in an Azure Data Lake Storage Gen2 account.
What should you do first?
- A. Change the Data source settings in the dataflow queries.
- B. Disable load for all dataflow queries.
- C. From the Power Bl Admin portal, enable tenant-level storage.
- D. Delete the dataflow queries.
Answer: C
Explanation:
Explanation
Configuring Azure connections is an optional setting with additional properties that can optionally be set:
* Tenant Level storage, which lets you set a default, and/or
* Workspace-level storage, which lets you specify the connection per workspace You can optionally configure tenant-level storage if you want to use a centralized data lake only, or want this to be the default option.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storage-integra
NEW QUESTION # 53
You are configuring a Power Bl report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Sentiment colors
- B. Theme colors
- C. Divergent colors
- D. First-level elements colors
Answer: A,B
NEW QUESTION # 54
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?
- A. Sales[Sales Amount]
- B. Plan[RowlD]
- C. Sales[Sales ID]
- D. Sales[RowlD]
Answer: C
Explanation:
Explanation
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.
Reference: https://blog.enterprisedna.co/vertipaq-analyzer-tutorial-relationships-referential-integrity/
NEW QUESTION # 55
You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. You have insufficient permissions.
- B. The sensitivity level for the dataset is set to Highly Confidential.
- C. Row-level security (RLS) is missing from the dataset.
- D. The workspace is in shared capacity.
- E. Dataset certification is disabled for the Power Bl tenant.
Answer: A,E
Explanation:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorsement-overview Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content
NEW QUESTION # 56
Your company is migrating its current, custom-built reporting solution to Power BI.
The Power BI tenant must support the following scenarios:
40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.
Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
You need to recommend a licensing solution for the company. The solution must minimize costs.
Which two Power BI license options should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. 70 Premium per user
- B. 70 Pro
- C. 35 Premium per user
- D. one Premium
- E. one Embedded
- F. 35 Pro
Answer: C,D,F
Explanation:
Explanation
B:
Free - 40 reports that will be embedded in external websites. The websites control their own security.
Free - The reports will be consumed by 50 users monthly.
Free + 1 Premium for the Worspace -Forty-five users that require access to the workspaces and apps in the Power BI Admin portal.
F: Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional
15 users will consume the reports.
Power BI Premium per user features and capabilities
* Pixel perfect paginated reports are available for operational reporting capabilities based on SSRS technology. Users can create highly formatted reports in various formats such as PDF and PPT, which are embeddable in applications and are designed to be printed or shared.
Note: There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User.
Power BI (free): Access to content in My Workspace
Power BI (free) + Workspace is Premium: Consume content shared with them Power BI Pro: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Pro license Power BI Pro + Workspace is Premium: Distribute content to users who have free licenses Power BI Premium Per User: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Premium Per User license Power BI Premium Per User + Workspace is Premium: Distribute content to users who have free and Pro licenses Reference: https://docs.microsoft.com/en-us/power-bi/fundamentals/service-features-license-type
NEW QUESTION # 57
You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication.
You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?
- A. Public
- B. Private
- C. Organizational
- D. None
Answer: A
Explanation:
Explanation
A Public data source gives everyone visibility to the data contained in the data source. Only files, internet data sources, or workbook data can be marked Public. Data from a Public data source may be freely folded to other sources.
Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels
NEW QUESTION # 58
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
Step 1: From powerbi.com, create a new report..
The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Step 2: Add a report measure
Measures are used in some of the most common data analyses. Simple summarizations such as sums, averages, minimum, maximum and counts can be set through the Fields well. The calculated results of measures are always changing in response to your interaction with your reports, allowing for fast and dynamic ad-hoc data exploration.
Step 3: Add visuals to the report
Step 4: Publish the report to the Sales Analytics workspace
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures
NEW QUESTION # 59
You plan to a Power Bl dataset.
You open the Impact analysis panel for the dataset and select Notify contacts.
Which contacts will be notified when you use the Notify contacts feature?
- A. all the workspace members of any workspace that uses the dataset
- B. the workspace admins of any workspace that uses the dataset
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the Power Bl admins
Answer: A
Explanation:
Explanation
Notify contacts
If you've made a change to a dataset or are thinking about making a change, you might want to contact the relevant users to tell them about it. When you notify contacts, an email is sent to the contact lists of all the impacted workspaces. Your name appears on the email so the contacts can find you and reply back in a new email thread.
Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-impact-analysis
NEW QUESTION # 60
You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate.
You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
1 - Create RangeStart and RangeEndDateTime parameters.
2 - Add an applied step that adds a custom date filter OrderDate is Between RangeStart and RangeEnd.
3 - Configure an incremental refresh to archive data that starts two years before the refresh date.
4 - Add an applied step that filters OrderDate to the start of the prior year.
NEW QUESTION # 61
You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is shown in the following exhibit.
Answer:
Explanation:
Explanation
NEW QUESTION # 62
You use Vertipaq Analyzer to analyze a model.
The Relationships tab contains the results shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Customer
There are 1804 invalid rows (records) in the Customer table.
Box 2: 1804
There is a very good video explaining the concept on
https://www.youtube.com/watch?v=XvZyo9Kgyio&list=PLU6II7MW-aiIREc1XdCYviQEj4Ui2pNDS&index=
NEW QUESTION # 63
......
Skills measured
- Implement and manage a data analytics environment (25–30%)
- Explore and visualize data (20–25%)
- Implement and manage data models (25–30%)
- Query and transform data (20–25%)
DP-500 Dumps for Azure Enterprise Data Analyst Associate Certified Exam Questions and Answer: https://lead2pass.testvalid.com/DP-500-valid-exam-test.html