Microsoft Power BI Test – 6

Consider a new table named SchoolYearDate which has the same columns schema as the Date table. You want to create a report that shows the total Enrollments by SchoolYearDate and Calendar Month.
How can you achieve the task?

Select 1 option(s):

You create a new Power BI Desktop project based on 50 tables from SQLTest. Before publishing the report to Power BI Service, you need to connect the project to tables in SQLlive.
What should you do in the Query Editor, with a low administrative effort, in order to meet the goal?

Select 1 option(s):

All cells in the date column must contain a date. You want to replace null values with the date from the previous row.
Which command should you run in Power Query?

Select 1 option(s):

How can you achieve this task?

Select 1 option(s):

Select the right command to use.

Select 1 option(s):

The tables come from a Microsoft SQL Server database.
The Enrollments table contains more than two million rows. You plan to import a sample of data from the Enrollments table in Power BI Desktop.
There are two ways to achieve the goal from the following options, select them.

Select 2 option(s):

You want to configure the table as shown in picture 2:

Which command should you use?

Select 1 option(s):

You notice that the data model presents a huge list of queries that make it difficult to organize the transformation steps.

Which best practice can you adopt in Power Query to solve this issue?

Select 1 option(s):

Course[CourseName] contains NULL values. You plan to add a new column to the Course table that uses the following formula:
=if [CourseName]=null then “NA” else [CourseName]
Select the option available in the Query Editor to meet the goal.

Select 1 option(s):

The Sales[DateKey] column is in the Date/time format as shown:

What can you do to improve performance when you are getting data in Power BI?

Select 1 option(s):

The Sales table contains one million records per month. You want to minimize the data model size. Plus, you want to count sales by Date and Store. How can you meet the two goals?

Select 1 option(s):

How can you achieve the goal?

Select 1 option(s):

The query retrieves 10,200 records. After checking the data source, you discover that there are 21,300 records.
How can you ensure that the query retrieves all 21,300 records?

Select 1 option(s):

Now you need to set-up a new ID Column to be sure that every row in the Products table contains a unique value.
How can you meet the goal?

Select 2 option(s):

You plan to create a relationship between the Enrollments table and the Courses table on the Course _ ID column.

What task do you need to perform before creating the relationship?

Select 1 option(s):

There is a relationship between tables, you want to create a report in Power BI Service that shows TotalPaid by EnrollmentDate and by CourseName.
N.B. Only the required columns must be shown in the report.
Select the right configuration of EnrollmentID column and TeacherID column.

Select 1 option(s):

In the picture, you can find a sample of data for the tables. You want to know which Teacher is responsible for which course.
Which kind of Join should you use?

Select 1 option(s):

– ColumnA presents several values starting with space;
– ColumnB contains several non-printable characters.
Which couple of commands should you use to fix the above column errors?

Select 1 option(s):

You plan to create a relationship between the Courses table and another table called Enrollments.
Which function let you optimize the query for Courses before creating the relationship?

Select 1 option(s):

Select 1 option(s):

How can you achieve the goal?

Select 1 option(s):

You want to ensure that when you select a year on the Line chart, the Pie chart remains unchanged.
How can you perform this task?

Select 1 option(s):

Select 1 option(s):

Which type of visual best fits your needs?

Select 1 option(s):

Which actions should you perform to use R scripting in Power BI Desktop?

Select 1 option(s):

You plan to create a slide show that displays the donut charts filtered by different years. You want that the slide show can be used from Power BI Service.
What should you do before publishing the report?

Select 1 option(s):

What should you do to meet the goal?

Select 1 option(s):

Note that in the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
You are in charge of building a Power BI report following these requirements:
The Enrollments managers ask for a visual to analyze enrollment performance versus enrollment targets. You must include in the visualization a time trend across months.
Which visualization object should you select?

Select 1 option(s):

from matplotlib import pyplot;
ax = pyplot.gca();
dataset.plot.line(x = ‘Courses’, y = ‘Total Enrollments’, color = ‘green’, ax = ax)
Power BI Desktop returns the following error message:

How can you fix the issue?

Select 1 option(s):

– StudentID;
– CourseID;
– Date;
– CourseName;
– FeePaid.
You create a report that contains a Stacked Column Chart that shows the count of Students by CourseName, then you want to customize the information placed in the visualization tooltip for the chart.
What should you do first?

Select 1 option(s):

– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You configure a bar chart to display the number of students by Country, and drill down to ProvState, and in the end to City.
You publish the Enrollments_BI project to Power BI Service and plan to share it with your colleagues: how could you share it?
N.B. Your colleagues must be able to use the Drill Down feature.
Solution: You create a dashboard and pin the Bar Chart visualization to it, then share the dashboard with your team.
Does this solution meet the goal?

Select 1 option(s):

– Date;
– Funds;
– Expenses.
You configure a Line and Clustered Column Chart as the following:
– Date Column as Shared Axis
– Funds Column as Line Values
– Expenses Column as Column Values
You notice that the Line Values doesn’t’ match the correspondent Y-axis Values and it is set on the top of the chart by default as shown in the picture:

How can you fix the visualization?

Select 1 option(s):

You want to enable sample questions that users can ask when using the Q&A option.

What do you need to modify in the Power BI Settings?

Select 1 option(s):

You need to customize the report with both the corporate colors of your organization and a set of custom icons.
How can you meet the goal?

Select 1 option(s):

You want to improve the visual by adding a horizontal line that shows which products have a return amount above the median amount.
How could you reach the goal?

Select 1 option(s):

Which action should you perform?

Select 1 option(s):

– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You are creating a Power BI report that includes a bar chart to display the number of students by location. You want that the report will show the number of students by Country, and drill down to ProvState, and in the end to City.
Select the right configuration of the drill down in the bar chart.

Select 1 option(s):

You want to be sure that the user will read it in a logical way when he/she uses the keyboard.
On what should you have to work on?

Select 1 option(s):

You try to create a map to show Enrollments by Area, but you find out that the map doesn’t work.
What can you do to fix the map visualization?

Select 1 option(s):

After you have imported the Excel file to Power BI Desktop, you create a bar chart showing the Enrollments amount by region.
Unfortunately, the Enrollments amount value appears as the count of Enrollments amount instead of the sum of Enrollments amount for each region.
You need to modify the query to ensure that the data appears correctly.
How can you fix the issue?

Select 1 option(s):

You found that the total number of customer visits was 60,000 and that there were only 5,000 customer visits in August. You check that the total number of visits was 90,000 and that there were only 10,000 visits in October.
How can you fix the report visualization?

Select 1 option(s):

When you start to print the reports, you notice that some tables show less rows than they really have.
How can you solve this issue?

Select 1 option(s):

After you have created a stacked bar chart to display CourseName by StartingDate, you notice that the axis shows all the individual dates. You want to set the drill down in the chart to display CourseName by year, by week, and day.
What is the first task to do?

Select 1 option(s):

Select 1 option(s):

– A measure named Total Enrollments Last Year shows the Enrollments from the previous calendar year. The current value is 52,000.
– A measure named Total Enrollments This Year shows the Enrollments from the current calendar year. The current value is16,000.
– A measure named Total Sales Difference based on the following DAX formula: Enrollments[Last Year] – Enrollments[This Year].
You need to create the following visualization.

You plan to create a Gauge visualization by using the measures above. Select the right configuration for the visualization.

Select 1 option(s):

You add Country and Enrollments columns to a table visualization in Power BI Desktop and the result appears as in the following picture:

Why does it show three rows of data instead of six?

Select 1 option(s):

You want to understand which variables may affect this result.
Which solutions can help you to explore the possible causes in Power BI Desktop?

Select 2 option(s):

The App will be available to all Organization users. You need to be sure that all the PowerBI users will have access to the App.

Select 1 option(s):

Select the right order of the actions to achieve the goal.

Select 1 option(s):

You have enabled the option ”Allow users to build new content using the underlying dataset” from the report settings.
What will happen to the underlying dataset? Select the true statements.

Select 2 option(s):

You need that the sales managers can interact with the data from their region. In addition, you want that sales managers can’t modify the report’s layout.
Note that the datasets use row-level security (RLS).
How can you meet the goal?

Select 1 option(s):

You plan to start a reports maintenance program. You need to know which reports present a critical usage.
How can you achieve this task?

Select 1 option(s):

You want to add the Enrollments table to a Power BI dashboard as a tile.

What is the tile configuration?

Select 1 option(s):

The report retrieves data from an Azure SQL Database. How can you ensure that users of your organization will see the current data when they access the report on the Power BI Service?

Select 1 option(s):

What can you do to prevent the reports from being published on the Web?

Select 1 option(s):

Which function best fit your needs?

Select 1 option(s):

The developers ask for pushing data into the Power BI Service from the custom app.
How can you ensure this task?

Select 1 option(s):

Which View Mode should you set for the Sales_01 report?

Select 1 option(s):

How can you review data in Power Query before creating the data model?

Select 1 option(s):

You create a calculated table named Country from the dataset for unique values of country in the table named Customer.
You generate visualizations for the sales data including showing sales by product manager. The product manager data is not in the data warehouse. The product manager data is in an Excel workbook on your local computer as shown in the Workbook exhibit below.

You do not have the Power BI On-Premises Gateway installed. You need to explain to the user when the data in the visualizations was last refreshed.
Visuals referring to the Product Managers table show the values from..

Select 1 option(s):

Select 1 option(s):