Microsoft Power BI Test – 7

Select 1 option(s):

Sales_1 connects to a Microsoft SQL Server database by using DirectQuery connection. After you have published the Sales_1 report to the Power BI service, the visualizations don’t work.
How can you solve the issue?

Select 1 option(s):

Select 1 option(s):

Which files can you import in Power BI as a dataset?

Select 2 option(s):

Which action must you perform?

Select 2 option(s):

You want to add one of your videos to a tile in the Subscritions&Views dashboard.
Which type of tile should you add?

Select 1 option(s):

What do you need to perform in Power BI Desktop?

Select 1 option(s):

Select the three actions you should perform in sequence.

Select 1 option(s):

When the dashboard refreshes data it takes too much time to be ready, because the refresh involves the last five years’ sales data.
How can you optimize the data refresh performance?

Select 1 option(s):

Then, you publish the report on the Power BI Service to share data with other company’s users.
You need that users who access the report from Power BI Service can interrogate the last update of data from the SSAS.
What should you implement to meet the goal?

Select 1 option(s):

What should you do?

Select 1 option(s):

Often, these reports are exported as PDF files. The Company’s policy requires that the exported reports are encrypted.
What can you use to meet this requirement?

Select 1 option(s):

After you publish the report in Power BI Service you want to create a dashboard that contains all the visualizations, slicer included.
What should you do?

Select 1 option(s):

A specific municipal office records every new birth in an Azure SQL Database.
Your company is in charge of monitoring the correlation between the numbers of birth and the hospitals’ available rooms by creating a specific Power BI report.
As data are frequently updated and it is required that they must be visible in ten minutes after every update, how should the company configure the data connection?

Select 1 option(s):

Your colleagues require access to the workspace in order to carry out the following task:
User A needs to create and publish Power BI apps.
User B needs to publish reports and delete dashboards.
Which user role should you assign to each user?

Select 1 option(s):

How guest users can be integrated into the Organization users Tenant?

Select 1 option(s):

The customer wants to receive a notification about the daily total enrollments shown on the card.
How can you meet the goal?

Select 1 option(s):

You decide to embed them into a public Website.
Select the visualizations that you can embed into the Website.

Select 2 option(s):

Note that the region_id column is managed by only one sales manager.
You are in charge of building a Power BI report by following these requirements:
– You must create a visual that shows sales by region.
– Every Enrollments Manager wants to see the Enrollments data of the Region he manages only.
– Enrollments Managers require a report that contains the number of enrollments.
You need to create a Power BI solution that allows Enrollments Managers to access reports with the permissions required.
What do you include in your solution?

Select 1 option(s):

Select 1 option(s):

You need to provide a user@01datapower.com with the ability to edit and publish reports.
Select the right solution.

Select 1 option(s):

On behalf of Power BI Admin, how can you achieve this task?

Select 1 option(s):

You have a Power BI Workspace named SalesTeamBI Workspace. Michael is a Power BI user who has access to SalesTeamBI Workspace. He is also a member of a Security Group named Sales_Team.
You must prevent Michael from exporting data from SalesTeamBI Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of the Sales_Team Security Group.
Does this solution resolve the issue?

Select 1 option(s):

You plan to use Power BI to achieve this task, thanks to its straightforward Auto ML tool.
Select the sequence of the right steps to enable and use the Auto ML tool.

Select 1 option(s):

However, users who try to access the Power BI Service receive the error message shown in the picture.

In order to ensure that all users can have access to the PowerBI Service, what should you do first?

Select 1 option(s):

You have a Power BI Workspace named SalesTeamBI Workspace. Michael is a Power BI user who has access to SalesTeamBI Workspace. He is also a member of a Security Group named Sales_Team.
You must prevent Michael from exporting data from SalesTeamBI Workspace.
Solution: From Tenant settings in the PowerBI Admin Portal, you modify the Developer Settings.
Does this solution resolve the issue?

Select 1 option(s):

What should you do?

Select 1 option(s):

Select 1 option(s):

Select the right data source to use.

Select 1 option(s):

What do you need to change?

Select 1 option(s):

Select three types of visualizations that will work correctly when you will publish the report to the PowerBI Report Server.

Select 3 option(s):

After you have created a report in an app workspace on Power BI Service, you embed the report into a page on the Enrollments site by using the Power BI web part.
You must ensure that all of the 1,000 users can view the report from the Enrollments Sharepoint site.
Which option should you do first?

Select 1 option(s):

You must prevent Michael from exporting data from SalesTeamBI Workspace.
Solution: From the Microsoft Office 365 Admin center, you remove Michael from the All Users security group.
Does this solution resolve the issue?

Select 1 option(s):

You need to plan a solution to ensure that the company will be compliant with the security policy also when using Power BI Service.
What should you include in your recommendation?

Select 1 option(s):

Which information should you provide to the application developers?

Select 1 option(s):

Select the three operations that developers can achieve by using the API.

Select 3 option(s):

You choose to use Powershell to achieve the task. Complete the following cmdlet:


Select 1 option(s):

You want to be sure that Build and Share Permissions will be also removed.
How can you achieve the goal?

Select 1 option(s):

NOTE: You must use the minimum administrative effort.
Select the right option:

Select 1 option(s):

What should you do to fix the problem?

Select 1 option(s):

Select the action that the members of the app workspace can’t perform.

Select 1 option(s):

There is a many-to-one relationship between Sales[ProductKey] and Product[ProductKey], and between Sales[StoreKey] and Stores[StoreKey].
To restrict data acces, you create two different Role-level security (RLS) groups, with the following filters:
– Store[State] = ”USA”
– Product[ProductName] = ”T-shirts”
What will a user be able to see if he is a member of both the two RLS groups?

Select 1 option(s):

Your queries generate two tables named Enrollments and Teacher. A sample data of tables is shown in the picture.

You want to get more efficient queries, so you plan to enable the Assume Referential Integrity option.
Is it a good solution in this case?

Select 1 option(s):

The columns Checked_by, Approved_by and Not_Approved_by present a Many-to-One relationship on the column User_ID in the Users table.
N.B. Only the relationship between Checked_by and User_ID is marked as Active Relationship.
You need to count the number of documents edited by each User, filtered by ‘Checked_by’, ‘Approved_by’ and ‘Not_Approved_by’.
Solution: Before setting visualizations, create a DAX formula using CALCULATE, COUNT and USERELATIONSHIP functions.
Does this solution meet the goal?

Select 1 option(s):

Check the information stored in the following columns:
– Date[Month] in the mmyyyy format
– Date[Date_ID] in the ddmmyyyy format
– Date[Date_name] in the mm/dd/yyyy format
– Monthly Drop out[Month_ID] in the mmyyyy format
The only relationship is between the Course table and the Monthly Drop Out table by the CourseID Column.
You plan to create a visualization that displays a sum of Enrollments[Total Paid] by month for the Enrollment date column and the Starting date column.
How do you model the data?

Select 1 option(s):

Now, you want to update the query to get dynamic use of the parameter instead of copying the location-path in each query.
Solution: Modify the source step of the queries and use ExcelDataSet as the file path.
Does this solution meet the goal?

Select 1 option(s):

– Course (Columns: CourseID, CourseName)
– Enrollments (Columns: EnrollmentsID, EnrollmentsDate, CourseID, TeacherID, TotalPaid)
– Teacher (Columns: TeacherID, TeacherName)
You want to create the following measure: SoldCourse = DISTINCTCOUNT(Enrollments[CourseID])
You must create the following relationships:
– Enrollments to Course
– Enrollments to Teacher
N.B. The measures must display the number of courses sold and the teacher who is responsible for it.
Select the right configuration of relationships.

Select 1 option(s):

DeltaCompanySales retrieves data from an imported dataset that contains one table with 15 million rows. The report is a single page with 12 PowerBI default visuals. The customer complains about the report performances when loading data and interacting with visuals.
What do you suggest to increase report performances?

Select 1 option(s):

The data in “Starting Time” is in the following format: 2021-01-10 at 09:00.
You want to analyze the Badging trend by the Starting Time column and use a built-in date hierarchy. What should you do?

Select 1 option(s):

The model contains the following tables:
– Item(columns: Item_id, Item_Name)
– Sales (columns: Order_id, Order_Date, Item_id, Store_id, Total_Paid)
– Stores (columns: Store_id, Store_address)
The model has the following relationships:
– Sales to Item
– Sales to Stores
After you have imported the Power Pivot model in PowerBI you need to generate a report that displays the count of Items sold by each Store.
Which task you should perform before creating the report?

Select 1 option(s):

The Database Engineer created a single view in Microsoft SQL Server that joined the fact and dimension tables in the underlying query as you need to reduce your effort in Power BI modeling data.
Does this solution work?

Select 1 option(s):

Consider a many-to-one relationship from Order table to Date table that uses Order[Purchase_date] and Date[Date]. The Cross filter direction of the relationship is set to Single. You want to create a visualization that displays the following two measures:
– Count of OrderID by Month based on the Purchase_date
– Count of OrderID by Month based on the Shipping_date
Which task you should perform before creating the measure?

Select 1 option(s):

– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
NOTE: You can’t meet the goal by duplicating data or loading additional data.
Solution: You should create two copies of the Date table named AttendanceDate and StartingDate, then you create a measure that uses the new tables.
Does this solution resolve the issue?

Select 1 option(s):

The Date Table contains only one column named Date. The tables have the following relationships:
Enrollments [EnrollmentDate] to Date[Date]
Enrollments [AttendanceDate] to Date[Date]
Enrollments [StartingDate] to Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this solution resolve the issue?

Select 1 option(s):

How can you meet the goal?

Select 1 option(s):

– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You create measures that use the following functions: CALCULATE, COUNT, and FILTER DAX function.
Does this solution resolve the issue?

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 PowerBI report following these requirements:
– Region Managers need a visual to analyze weekly enrollments and returns.
– You must create a relationship between the Weekly_Returns table and the Date table to meet the Region Managers goal.
What should you do?

Select 1 option(s):

Check the sample data for the tables shown in the picture.

You need to model a relationship from the Account Table to the Insurance Table and from the Account Table to the Customer Table by joining the ID_Acc column.
How should you meet the goal?

Select 1 option(s):

N.B. Both Order_date and Order_Shipping are connected to the Date table. But Order_date is an active relationship, while Order_shipping is inactive.
Which function should you include in the DAX formula to create the calculated column?

Select 1 option(s):

The Product Table has a relationship to the Product Category Table on the SKU column.
Here, you can check a sample of data inside the tables:
Product Table:
SKU: HD-001, Product: GymSmartwatch, Color: Blue
SKU: HD-002, Product: XSound Headphones, Color: Black
SKU: HD-003, Product: Laptop Pro 2000, Color: Green
Product Category Table:
SKU: HD-001, Category: Smartwatch
SKU: HD-002, Category: Headphone
SKU: HD-003, Category: Computer
You need to use in your Power BI report a Hierarchy that shows two levels: product and category.
Solution: From Power Query, merge the tables and then create the hierarchy.
Does this solution meet the goal?

Select 1 option(s):

The columns Checked_by, Approved_by and Not_Approved_by present a Many-to-One relationship on the column User_ID in the Users table.
N.B. Only the relationship between Checked_by and User_ID is marked as Active Relationship.
You need to count the number of documents edited by each User, filtered by ‘Checked_by’, ‘Approved_by’ and ‘Not_Approved_by’.
Solution: Create a table visualization in Power BI Report tab and add User_ID, Checked_by, Approved_by and Not_Approved_by to the Values field.
Does this solution meet the goal?

Select 1 option(s):

Solution: Add a WHERE clause to the SQL statement.
Does this meet the goal?

Select 1 option(s):

– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You should create a calculated table, then you create a measure that uses the new table. Does this solution resolve the issue?

Select 1 option(s):

You want to set a many-to-one cardinality between tables, but it appears as not available in the relationship settings as shown in the picture.

What should you do before creating the Many-to-One relationship?

Select 1 option(s):

Your company wants to build a second SQL database that works as a development database.
The data structure available in the new development database is the same as the CompanyBI_01 one.
Now, you need to easily switch the data source in your Power BI Desktop environment between the development database and the CompanyBI_01 one.
Which is the simplest action that ensures you do that?

Select 1 option(s):