Get 100% Success with Latest Azure Enterprise Data Analyst Associate DP-500 Exam Dumps Dec 01, 2023
The Best DP-500 Exam Study Material and Preparation Test Question Dumps
NEW QUESTION # 59
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 BI 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 denormalizing the data model.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
Explanation:
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 # 60
You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.
You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?
- A. [User] = USERNAME()
- B. [UserPermissions] - USERNAME()
- C. [User] = USERPRINCIPALNAME()
- D. [User] = USEROBJECTID()
- E. [UserPermissions] - USERPRINCIPALNAME()
Answer: A
Explanation:
USERNAME() returns the domain name and username from the credentials given to the system at connection time.
It should be compared to column name of User, which in DAX is expressed through [User].
NEW QUESTION # 61
You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.
* New reports can be embedded only in locations that require authentication.
* Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. From Capacity settings, set XMLA Endpoint to Read Write.
- B. From the Premium per user settings, set XMLA Endpoint to Off.
- C. From Embed Codes, delete all the codes.
- D. From Tenant settings, set Publish to web to Disable.
- E. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
Answer: A,D,E
Explanation:
Reference:
https://powerbi.microsoft.com/en-us/blog/power-bi-february-service-update
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:
NEW QUESTION # 63
You have a sales report as shown in the following exhibit.
The sales report has the following characteristics:
The measures are optimized.
The dataset uses import storage mode.
Data points, hierarchies, and fields cannot be removed or filtered from the report page.
From powerbi.com, users experience slow load times when viewing the report.
You need to reduce how long it takes for the report to load without affecting the data displayed in the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.
- B. Change the report theme to monochromatic.
- C. Replace all the filters on the Filters pane with visual slicers on the report page.
- D. Replace the single-value cards with a multi-row card.
Answer: A,D
NEW QUESTION # 64
You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.
Multiple reports use the dataset.
A database administrator reports that too many queries are being sent from Power Bl to the database.
You need to reduce the number of queries sent to the database. The solution must meet the following requirements:
* DirectQuery must continue to be used.
* Visual interactions in all the reports must remain as they are configured currently.
* Consumers of the reports must only be allowed to apply filters from the Filter pane.
Which two settings should you select? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Add a single Apply button to the filter pane to apply changes at once
- B. Add Apply buttons to all basic filters to apply changes when you're ready
- C. Add an Apply button to each slicer to apply changes when you're ready
- D. Disabling cross highlighting/filtering by default
- E. Ignore the Privacy Levels and potentially improve performance
Answer: A,C
Explanation:
Reduce queries
Reduce the number of queries sent by Power BI using the Query reduction settings. For slicers, select the "Add an Apply button to each slicer to apply changes when you're ready" option. For filters, select "Add a single Apply button to the filter pane to apply changes at once (preview)."
NEW QUESTION # 65
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 # 66
You are planning a Power Bl solution for a customer.
The customer will have 200 Power Bl users. The customer identifies the following requirements:
* Ensure that all the users can create paginated reports.
* Ensure that the users can create reports containing Al visuals.
* Provide autoscaling of the CPU resources during heavy usage spikes.
You need to recommend a Power Bl solution for the customer. The solution must minimize costs. What should you recommend?
- A. Power Bl Pro per user
- B. a Power Bl Premium per capacity
- C. Power Bl Premium per user
- D. Power Bl Report Server
Answer: C
Explanation:
Explanation
Announcing Power BI Premium Per User general availability and autoscale preview for Gen2.
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.
* Automated machine learning (AutoML) in Power BI enables business users to build ML models to predict outcomes without having to write any code.
* Etc.
Note:
Power BI empowers every business user and business analyst to get amazing insights with AI infused experiences. With Power BI Premium, we enable business analysts to not only analyze and visualize their data, but to also build an end-to-end data platform through drag and drop experiences. Everything from ingesting and transforming data at scale, to building automated machine learning models, and analyzing massive volumes of data is now possible for our millions of business analysts.
Reference:
https://powerbi.microsoft.com/nl-be/blog/announcing-power-bi-premium-per-user-general-availability-and-autos
NEW QUESTION # 67
You need to integrate the external data source to support the planned 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:
1 - Create a web data source.
2 - Expand the attributes.
3 - Publish the model.
NEW QUESTION # 68
You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
- A. The storage account must have hierarchical namespace enabled.
- B. The storage account must be protected by using an Azure Firewall.
- C. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
- D. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
- E. Dataflows must exist already for any directly connected Power Bl workspaces.
Answer: A,D
NEW QUESTION # 69
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 Premium capacity.
From the Power Bl Premium Capacity Metrics app, you discover the following:
* There is insufficient CPU to execute dataset refreshes.
* Out-of-memory throttling occurs when the dataset is waiting.
You need to recommend a solution to resolve the performance issues.
Solution: You move the datasets to a larger capacity.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION # 70
You have a Power Bl dataset that contains the following measure.
You need to improve the performance of the measure without affecting the logic or the results. What should you do?
- A. Remove "calendar'[Flag] = "YTD" from the code.
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Create a variable and replace the values for [sales Amount].
- D. Remove the alternative result of blank( ) from the divide function.
Answer: B
NEW QUESTION # 71
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 72
You have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: sqlanalytics
Read from a SQL Pool table with Spark
// Read the table we just created in the sql pool as a Spark dataframe
val spark_read = spark.read.
sqlanalytics(s"$sql_pool_name.dbo.PublicHoliday")
spark_read.show(5, truncate = false)
Box 2: spark_read.show
Sample output:
Graphical user interface, text, application, email Description automatically generated
Reference:
https://github.com/Azure-Samples/Synapse/blob/main/Notebooks/Scala/03%20Read%20and%20write%20from%
NEW QUESTION # 73
You need to integrate the external data source to support the planned 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:
Explanation
NEW QUESTION # 74
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:
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.
Reference: https://www.mssqltips.com/sqlservertutorial/3211/denormalize-for-performance/
NEW QUESTION # 75
You need to integrate the external data source to support the planned 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:
1 - Create a web data source.
2 - Expand the attributes.
3 - Publish the model.
NEW QUESTION # 76
......
Get Ready to Pass the DP-500 exam Right Now Using Our Azure Enterprise Data Analyst Associate Exam Package: https://www.vcetorrent.com/DP-500-valid-vce-torrent.html
Enhance Your Career With Available Preparation Guide for DP-500 Exam: https://drive.google.com/open?id=1Ct18fSCfcII1mql4efL_fweBBTGQCsLM