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 (page: 23)

Page 23 of 46
PDF with 194 Questions

You have a Power BI data model.

You need to refresh the data from the source every 15 minutes.

What should you do first?

  1. Configure a scheduled refresh.
  2. Change the storage mode of the dataset.
  3. Enable the XMLA endpoint.
  4. Define an incremental refresh policy.

Answer(s): A

Explanation:

To get to the Scheduled refresh screen:

1. In the navigation pane, under Datasets, select More options (...) next to a dataset listed.
2. Select Schedule refresh.


Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh



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?

  1. [UserPermissions] = USERPRINCIPALNAME()
  2. [User] = USERPRINCIPALNAME()
  3. [User] = USEROBJECTID()
  4. [UserPermissions] = USERNAME()
  5. [User] = USERNAME()

Answer(s): E

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].

Incorrect:
Not A, not B: USERPRINCIPALNAME() returns the user principal name. It returns the name of the user as their email address, aka user@domain.com.

Not C: USEROBJECTID() returns the current user's Object ID from Azure AD or security identifier (SID).


Reference:

https://docs.microsoft.com/en-us/dax/username-function-dax



You have an Azure Synapse Analytics serverless SQL pool.
You need to catalog the serverless SQL pool by using Azure Purview.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. Create a managed identity in Azure Active Directory (Azure AD).
  2. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
  3. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
  4. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
  5. Register a data source.

Answer(s): B,C,E

Explanation:

The Answer should be, in order:
E: Register a data source
C: Set the Reader role and enter your Microsoft Purview account name.
B: Set the Storage blob data reader role and enter your Microsoft Purview account name.


Reference:

https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=MI#authentication-for-enumerating-serverless-sql-database-resources



HOTSPOT (Drag and Drop is not supported)
You need to recommend an automated solution to monitor Power BI user activity. The solution must meet the following requirements:

-Security admins must identify when users export reports from Power BI within five days of a new sensitivity label being applied to the artifacts in Power BI.
-Power BI admins must identify updates or changes to the Power BI 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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: the unified audit log in Microsoft 365
Security admins must identify when users export reports from Power BI within five days of a new sensitivity label being applied to the artifacts in Power BI.

Use the audit log
If your task is to track user activities across Power BI and Microsoft 365, you work with auditing in Microsoft 365 compliance or use PowerShell. Auditing relies on functionality in Exchange Online, which automatically supports Power BI.

You can filter the audit data by date range, user, dashboard, report, dataset, and activity type. You can also download the activities in a csv (comma-separated value) file to analyze offline.

Box 2: Power BI activity log
Power BI admins must identify updates or changes to the Power BI capacity.

Use the activity log
Power BI administrators can analyze usage for all Power BI resources at the tenant level by using custom reports that are based on the Power BI activity log.


Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing



Page 23 of 46



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