Prepare For Realistic DP-500 Dumps PDF - 100% Passing Guarantee
Check the Available DP-500 Exam Dumps with 115 Q's
NEW QUESTION # 26
You are using an Azure Synapse notebook to create a Python visual.
You run the following code cell to import a dataset named Iris.
A sample of the data is shown in the following table.
You need to create the visual shown in the exhibit. (Click the Exhibit tab.)
How should you complete the Python code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 27
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 28
You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
* Returns the fiscal prior year-to-date value for [sales Amount]
* Uses a fiscal year end of June 30
* Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
https://docs.microsoft.com/en-us/dax/datesytd-function-dax
NEW QUESTION # 29
You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the
entities from two different collections by using the same service root
The OData feed is still in development. The location of the feed will change once development is complete.
The report will be published before the OData feed development is complete.
You need to minimize development effort to change the data source once the location changes.
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:
NEW QUESTION # 30
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining an external table for the Parquet files and updating the query to use the table Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Topic 2, Litware, Inc.
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 # 31
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. The workspace is in shared capacity.
- B. You have insufficient permissions.
- C. Dataset certification is disabled for the Power Bl tenant.
- D. Row-level security (RLS) is missing from the dataset.
- E. The sensitivity level for the dataset is set to Highly Confidential.
Answer: B,C
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 # 32
You have the following code in an Azure Synapse notebook.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the code.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 33
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:
1 - From Power BI Desktop, create a role named Project Managers.
2 - Open Tabular Editor
3 - From Power BI Desktop, add a DAX filter to the Project Managers role.
4 - For Table1, the Budget and Forecast columns, set the permissions to None.
NEW QUESTION # 34
You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.
During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB." You need to ensure that you can refresh the dataset.
What should you do?
- A. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
- B. Change License mode to Premium per user.
- C. Change the location of the Premium capacity.
- D. Turn on Large dataset storage format.
Answer: C
Explanation:
Assigning workspaces to capacities
Workspaces can be assigned to a Premium capacity in the Power BI Admin portal or, for a workspace, in the Workspace pane.
Note: Capacity limits
Workspace storage limits, whether for My Workspace or an app workspace, depend on whether the workspace is in shared or Premium capacity.
* Shared capacity limits
For workspaces in shared capacity:
There is a per-workspace storage limit of 10 GB.
Premium Per User (PPU) tenants have a 100 TB storage limit.
When using a Pro license, the total usage can't exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.
* Premium capacity limits
For workspaces in Premium capacity:
There is a limit of 100 TB per Premium capacity.
There is no per-user storage limit.
Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.
Incorrect:
Not C: If your organization is using the original version of Power BI Premium, you're required to migrate to the modern Premium Gen2 platform. Microsoft began migrating all Premium capacities to Gen2.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi
NEW QUESTION # 35
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?
- A. a Data Explorer pool
- B. a dedicated SQL pool
- C. an Apache Spark pool
- D. a serverless SQL pool
Answer: C
Explanation:
In Azure Synapse, training machine learning models can be performed on the Apache Spark Pools with tools like PySpark/Python, Scala, or .NET.
NEW QUESTION # 36
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/selectedvalue-function
NEW QUESTION # 37
You have the Power BI workspaces 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:
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces
NEW QUESTION # 38
You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?
- A. PIVOT
- B. CAST
- C. GROUPING
- D. PREDICT
Answer: A
NEW QUESTION # 39
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)
Users indicate that when they build reports from the data model, the reports take a long time to load.
You need to recommend a solution to reduce the load times of the reports.
Solution: You recommend moving all the measures to a calculation group.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Instead denormalize For Performance.
Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.
NEW QUESTION # 40
You have the Power BI workspaces 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:
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces
NEW QUESTION # 41
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join
operations in the query. What should you review?
- A. the query history
- B. the query plan
- C. the query statistics
- D. the server timings
Answer: B
NEW QUESTION # 42
You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to
the visual libraries. Which Python libraries should you use?
- A. Matplotlib and Seaborn
- B. TensorFlow only
- C. Seaborn and TensorFlow
- D. Seaborn only
- E. Matplotlib and TensorFlow
- F. Matplotlib only
Answer: B
NEW QUESTION # 43
You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?
- A. Create a new pull request.
- B. Disconnect from the GitHub repository.
- C. Change the active branch.
- D. Change the workspace to live mode.
Answer: B
Explanation:
By default, Synapse Studio authors directly against the Synapse service. If you have a need for collaboration using Git for source control, Synapse Studio allows you to associate your workspace with a Git repository, Azure DevOps, or GitHub.
Prerequisites
Users must have the Azure Contributor (Azure RBAC) or higher role on the Synapse workspace to configure, edit settings and disconnect a Git repository with Synapse.
NEW QUESTION # 44
You have two Power BI reports named Report1 and Report2.
Report1 connects to a shared dataset named Dataset1.
Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.
You need to prepare Report2 to use Dataset1.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Update all the parameter values.
- B. Remove the data source permissions.
- C. Delete all the calculated tables.
- D. Delete all the Power Query Editor objects.
- E. Modify the source of each query.
Answer: A,E
Explanation:
C: Power BI Desktop also comes with Power Query Editor. Use Power Query Editor to connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.
D: Common uses for parameters
Here are some of the most common ways to use parameters.
Control paginated report data
* Filter paginated report data at the data source by writing dataset queries that contain variables.
* Etc.
Reference:
https://docs.microsoft.com/en-us/learn/modules/dax-power-bi-add-calculated-tables/1-introduction
NEW QUESTION # 45
You are creating a Python visual in Power Bl Desktop.
You need to retrieve the value of a column named Unit Price from a DataFrame.
How should you reference the Unit Price column in the Python code?
- A. data = [Unit Price]
- B. ('Unit Price')
- C. dataset['Unit Price']
- D. pandas.DataFrame('Unit Price')
Answer: D
NEW QUESTION # 46
You have an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that the SQL pool is scanned by Azure Purview.
What should you do first?
- A. Create a data share connection.
- B. Create a data policy.
- C. Search the data catalog.
- D. Register a data source.
Answer: C
NEW QUESTION # 47
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl dataset named Datasetl.
In Datasetl, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Power Bl Desktop, you group the measures in a display folder.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Solution: From DAX Studio, you write a query that uses grouping sets.
A grouping is a set of discrete values that are used to group measure fields.
NEW QUESTION # 48
You have a Power Bl report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency. What should you do?
- A. Change the red background color to orange.
- B. Add icons to represent the sales status of each product.
- C. Add additional measures to the table values.
- D. Change the font color of values in the Sales column to white.
Answer: A
NEW QUESTION # 49
You are optimizing a Power Bl data model by using DAX Studio.
You need to capture the query events generated by a Power Bl Desktop report.
What should you use?
- A. a Server Timings trace
- B. a Query Plan trace
- C. an All Queries trace
- D. the DMV list
Answer: A
NEW QUESTION # 50
......
Download DP-500 Exam Dumps Questions to get 100% Success: https://www.getvalidtest.com/DP-500-exam.html
100% Accurate Answers! DP-500 Actual Real Exam Questions: https://drive.google.com/open?id=1j7WAnBniJP8b_-UeQxBPs96sm8Zga-DX