- (Topic 4)
You have a Power Bl report
You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
• A card that shows the number of records
• A bar chart that snows total transaction amount by territory
• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory
You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?

1. A. Apply a row filter to the Dalai query in Power Query Editor.
2. B. Add a trend line to the scatter plot
3. C. Enable high-density sampling on the scatter plot
4. D. Add a count field of the transaction amount to the size bucket of the scatter plot

Correct Answer: B

- (Topic 4)
You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.
You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve
the original colors of the reports.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Upload a snapshot.
2. B. Select the dark dashboard theme.
3. C. Turn on tile flow.
4. D. When pinning visuals to the dashboard, select Use destination theme.
5. E. For the browser, set the color preference to dark mode.

Correct Answer: BD

- (Topic 4)
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 in 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?

1. A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
2. B. Change the data type of the Logged column to Date.
3. C. Split the Logged column by using at as the delimiter.
4. D. Apply a transformation to extract the first 11 characters of the Logged column.

Correct Answer: C
Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:
= Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"})
It will even automatically change the type to Date:
= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date},
{"Date.2", type time}})

- (Topic 4)
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

1. A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
2. B. Publish the reports to a different workspace other than the one hosting the datasets.
3. C. Publish the reports in an app and grant the HR managers access permission.
4. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Correct Answer: C
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

HOTSPOT - (Topic 4)
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."
You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Solution:
Graphical user interface, text, application
Description automatically generated
Box 1: Yes
The four columns used in the 2018 transactions are already displayed.
Box 2: Yes
The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.
Box 3: Yes
Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A