You are a stock trading analyst working with a table that contains Microsoft’s daily closing stock prices for the past year.

You have to create a Power BI visual to monitor Microsoft’s stock price along with the relevant information below:

· 52-week high,

· 52-week low

· Current Microsoft stock price

· Stock’s 50 Day Moving Average (DMA)

You track the stock price, and if the price moves above/below 50 DMA, you plan to buy/sell the stock in large quantities. Which visual would you use?

John Carmack is a new Power BI developer. He updates the dashboard theme by changing the Tile background color. He observes that, out of 3 visuals in the dashboard, one visual has no effect.

What could be the reason for his observation?

Which of the following statements about dashboard themes and report themes in Power BI is TRUE?

Your Power BI team creates dashboards for the Marketing automation team. Where can the users share feedback by adding comments for effective collaboration?

You have a dataset of the height and weight of Grade 10 students.

You need to use both height and weight to visualize and identify students who are very tall, a cut above the rest of the batch, for an inter-school basketball match.

Which Power BI visual would you use?

You apply a custom theme to your reports by importing a JSON file in Power BI Desktop. Which theme gets applied when you pin a tile from a report to the Power BI dashboard?

You are working with the POS purchases data set of a top US retail company. You have to analyze the data to discover different customer segments based on Total Sales across Product Category, Product Subcategory, Region, Shipping mode, etc.

Which of the following visuals would you use?

You import tables from the Adventure Works Data warehouse and design the below report page. When the user selects any of the Organization Name (on the column chart) and a Year (from the slicer) and clicks the Show Data button, you should show a detailed report page for the selected Organization Name and Year.

How would you configure the report?

You are a finance professional working with a specialized chemicals manufacturing company. You need to track how the Day Sales Outstanding (DSO) number of your company changes over time in relation to the industry average.

Which of the following Power BI visuals would you use?

Note: Lower the DSO number, the better your organization is doing at collecting accounts receivables.

Arun is a deployment manager. Which Power BI workspace role would you assign to him so he can perform his job effectively?

Below is a line chart that plots Apple stock’s daily closing price for the past five years and the 200-Day Simple Moving Average (200 DMA). Some traders use 200 DMA to enter/exit positions in a stock.

As a trader, if Apple’s stock price goes above 200 DMA, you enter a position. If Apple’s stock goes below 200 DMA, you exit a position.

Accordingly, you want Power BI to notify you of such price movements. What would you do?

Which of the following statements about sensitivity labels in Power BI is TRUE?

You build a Power BI report for graduates of a b-school. Given below is a sample dataset.

The final report has the following requirements:

1. When a student logs in, the report should display their name (Graduate Name) and Grades.

2. The report should display their peer grades without revealing personal information (name) about whom those grades belong. That is, the report should not display the names of their peers.

3. The users should be able to compare their performance with the performance of the batch mates.

How would you create the report?

You create multiple reports on the company’s last quarter financial information. You would like to share these reports with the C-level executives of the company. How would you share the reports?

Note: Ignore all aspects of Power BI licensing.

You have an app workspace Marketing Efficiency. You need to grant marketing users read-only access to all the reports in the workspace.

Which of the following solutions meet the stated goals?

The IT bellwether Infosys serves its clients across five main verticals:

1. BFSI

2. Life sciences

3. Manufacturing & hi-tech

4. Energy & Utilities

5. Communications & services.

The company develops a Power BI report that displays project information in these verticals. They define row-level security roles to enable bulk access for the SPMs, DMs, BU heads, etc., to the project's insights in their vertical. i.e., they can access project data only for their verticals via Azure AD security groups.

You, a delivery manager (DM) in the BFSI space, received a transfer to the Life sciences vertical.

How should your access be managed in Power BI?

You want to publish a dataset to all users in the organization. i.e., even users who do not have access to the dataset should be able to view the dataset in the data hub and request access to it.

Which of the following actions do you need to perform?

Your Power BI report displays sensitive information like customers’ Social Security Numbers to report users. You export the report from the service as PDF/PowerPoint and share it with your vendors for collaboration. You have to ensure that only the authorized users (in the vendor team) can access the exported reports.

Which of the following features would you use?

From the AdventureWorks Datawarehouse, you import the below tables into Power BI Desktop. You have to analyze Reseller Sales for each Sales Territory. How would you configure the relationship between Dim Geo and Dim Territory?