You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at
08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

• A.Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
• B.Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
• C.Apply the parse function from the Date transformations options to the Logged column.
• D.Create a column by example that starts with 2018-12-31.

Comment: *

Name: *

Email: *

Verification: *

You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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.

Correct Answer:

Explanation:
1- Convert list to table
2- Expand Column
3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expand columns:
https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

Comment: *

Name: *

Email: *

Verification: *

You have a Power Bl report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.
What should you do?

• A.Add the Azure network security team as members of the RLS role.
• B.Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
• C.Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
• D.Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

Comment: *

Name: *

Email: *

Verification: *

You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

• A.Use the Test as role option to view data as the salesperson's user account.
• B.Use the Test as role option to view data as the Sales role.
• C.Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
• D.Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Correct Answer: A

Validate the roles within Power BI Desktop
* After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.
A picture containing application Description automatically generatedThe View as roles window appears, where you see the roles you've created.Graphical user interface, text, application Description automatically generated


* Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.
* You can also select Other user and supply a given user.Graphical user interface, application Description automatically generated
* Select OK.The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?

• A.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• B.Create one workspace for development. From the new workspace, publish an app for production.
• C.Create a workspace for development and a workspace for production. From the production workspace, publish an app.
• D.In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

Comment: *

Name: *

Email: *

Verification: *