Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

D365 > 70-778 > Flashcards

70-778 Flashcards

1
Q

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
✑ Sales[DueDate] and Date[Date]
✑ Sales[ShipDate] and Date[Date]
✑ Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create a calculated table. You create a measure that uses the new table.
Does this meet the goal?

A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
✑ Sales[DueDate] and Date[Date]
✑ Sales[ShipDate] and Date[Date]
✑ Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.
Does this meet the goal?

A. Yes
B. No

A

A. Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
✑ Sales[DueDate] and Date[Date]
✑ Sales[ShipDate] and Date[Date]
✑ Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?

A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You have a user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group.
Does this meet the goal?

A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You have a user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
Does this meet the goal?

A. Yes
B. No

A

A. Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

You have a user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the PowerBI setting, you modify the Developer Settings.
Does this meet the goal?

A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You plan to embed multiple visualizations in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.

VIsual 1: Uses row-level security (RLS)
Visual 2: Uses a dataset that is stored in Microsoft OneDrive for Business
Visual 3: Contained in a report that was shared to your use account
Visual 4: IS a custom visual
Visual 5: Uses a dataset from an on-premises Microsoft SQL Server Analysis Services (SSAS) database

Which two visualizations can you embed into the website? Each correct answer presents a complete solution.
A. Visual 1
B. Visual 2
C. Visual 3
D. Visual 4
E. Visual 5
A

B. Visual 2

D. Visual 4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries.
You need to ensure that the users can find data by using natural language queries.
What should you do?

A. From the settings of the workspace, modify the Language Settings.
B. From the Sales Data dashboard, set the dashboard as a Favorite.
C. From the properties of the datasets, modify the Q&A and Cortana settings.
D. From the properties of the dashboard, modify the Q&A settings.

A

D. From the properties of the dashboard, modify the Q&A settings.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DRAG DROP -
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the visualizations in the dashboard are updated daily.
Which three actions should you perform in sequence?

Actions:

  1. Download and install an on-premises data gateway (personal).
  2. Configure the Gateway Connection settings for the dataset.
  3. Add subscriptions for the reports.
  4. Download and install Power BI Desktop.
  5. Configure the Schedule Refresh settings for the dataset.
A
  1. Download and install an on-premises data gateway (personal).
  2. Configure the Gateway Connection settings for the dataset.
  3. Configure the Schedule Refresh settings for the dataset.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You manage a Power BI model that has two tables named Sales and Product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of Unites States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

A. Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing
B. From Power BI Desktop, create a new role that has the following filters. [CountryRegionName] = “United States” [ProductCategory] = “Clothing”
C. Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing
D. From Power BI Desktop, create a new role that has the following filter. [CountryRegionName] = “United States” && [ProductCategory] = “Clothing”

A

B. From Power BI Desktop, create a new role that has the following filters. [CountryRegionName] = “United States” [ProductCategory] = “Clothing”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You create a report in the Power BI service that displays the following visualizations:
✑ A KPI that displays the count of customers
✑ A table that displays the count of customers by country
✑ A line chart that displays the count of customers by year
You need to receive an alert when the total number of customers reaches 10,000.
What should you do first?

A. Pin the line chart to a dashboard.
B. Pin the KPI to a dashboard.
C. Embed the report into a Microsoft SharePoint page.
D. Pin the report to a dashboard.

A

B. Pin the KPI to a dashboard.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify form the Power BI Settings?

A. Subscriptions
B. Workbooks
C. Dashboards
D. Datasets

A

D. Datasets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You have an app workspace named Retail Store Analysis in the Power BI service.
You need to manage the members that have access to the app workspace using the least amount of administrative effort.
What should you do?

A. From the Office 365 Admin center, click Users.
B. From the Power BI Admin portal, click Tenant settings.
C. From the Power BI Admin portal, click Usage metrics.
D. From the Office 365 Admin center, click Groups.

A

D. From the Office 365 Admin center, click Groups.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Your organization has a Microsoft Office 365 subscription.
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.)
https://imgur.com/w2rkmq4

You need to ensure that all the users can access the Power BI service.
What should you do first?
A. From the properties of each dashboard, modify the Share dashboard settings.
B. From Microsoft Azure PowerShell, run the Set-MsolDomain cmdlet.
C. Instruct each user to install Microsoft Office 2016.
D. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
E. From Power BI Admin portal, modify the Tenant settings.
F. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user.
G. From the Power BI Admin portal, modify the Privacy Settings.

A

D. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?

A. From the Power BI service, import the data from the Excel workbook.
B. From Excel, publish the workbook to the Power BI service.
C. From the Power BI tab in Excel, pin the table.
D. From the Power BI service, upload the Excel workbook.

A

C. From the Power BI tab in Excel, pin the table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

HOTSPOT -
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
✑ Access a published Power BI app.
Modify reports in an app workspace.

✑ Share dashboards created in My Workspace.
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) license, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.

  • Power BI (free)
  • Power BI PRO
  1. Access a published Power BI app
  2. Modify reports in an app workspace
  3. Share dashboards created in My Workspace
A
  1. Power BI (free)
  2. Power BI PRO
  3. Power BI PRO

D365 (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions