CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-500

Free DP-500 Exam Braindumps

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.

  1. 70 Premium per user
  2. one Premium
  3. 70 Pro
  4. one Embedded
  5. 35 Pro
  6. 35 Premium per user

Answer(s): B,F

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



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.

  1. Remove the data source permissions.
  2. Delete all the Power Query Editor objects.
  3. Modify the source of each query.
  4. Update all the parameter values.
  5. Delete all the calculated tables.

Answer(s): C,D

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/power-bi/transform-model/desktop-query-overview
https://docs.microsoft.com/en-us/learn/modules/dax-power-bi-add-calculated-tables/1-introduction



HOTSPOT (Drag and Drop is not supported)
You have an Azure Synapse notebook.

You need to create the visual shown in the following exhibit.



How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: fill_between
atplotlib.pyplot.fill_between fills the area between two horizontal curves.

The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.

Box 2: suptitle
Set the title of the visual.
suptitle adds a centred title to the figure.


Reference:

https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.fill_between.html#matplotlib.pyplot.fill_between
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle



You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.

You need to review statistics for a DataFrame that includes:

-The column name
-The column type
-The number of distinct values
-Whether the column has missing values

Which function should you use?

  1. displayHTML()
  2. display(df, summary=true)
  3. %%configure
  4. display(df)
  5. %%lsmagic

Answer(s): B

Explanation:

display(df) statistic details
You can use display(df, summary = true) to check the statistics summary of a given Apache Spark DataFrame that include the column name, column type, unique values, and missing values for each column. You can also select on specific column to see its minimum value, maximum value, mean value and standard deviation.


Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization






Post your Comments and Discuss Microsoft DP-500 exam with other Community members:

Summer commented on July 28, 2024
Wonderful site. It helped me pass my exam. Way to go guys!
UNITED STATES
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

siyaa commented on January 19, 2024
helped me understand the material better.
Anonymous
upvote

Bunny commented on June 19, 2023
Good Content
Anonymous
upvote

Demetrius commented on June 01, 2023
Important and useful
Anonymous
upvote

Kartoos commented on April 06, 2023
The practice exam was an important part of my preparation and helped me understand the material better.
FRANCE
upvote