Get Full Version of the Exam
http://www.EnsurePass.com/70-778.html

Question No.1

Note: This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that contains the following tables.

image

The Oder table contains more than one million rows.

The Store table has a relationship to the Monthy_returns table on the StoreID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data. End of repeated scenario.

You are modifying the model to report on the number of orders. You need to calculate the number of orders.

What should you do?

  1. Create a Calculated measure that uses the COUNTA(Order_ID) DAX formula.

  2. Create a Calculated measure that uses the SUM(Order_ID) DAX formula.

  3. Create a Calculated column that uses the SUM(Order_ID) DAX formula.

  4. None of the above.

Correct Answer: A

Question No.2

You plan to use Power BI Desktop to create a report. The report will consume data from an on- premises tabular database named SalesDB in Microsoft SQL Server Analysis Service (SSAS). The report will be published to the Power BI service.

You need to ensure that the report published to the Power BI service will access the current data in Sales DB.

What should you do?

  1. Deploy an on-premises data gateway and configure the connection to Sales DB to use the Import Data Connectivity mode.

  2. Deploy an on-premises data gateway and configure the connection to Sales DB to use the Correct live option.

  3. Deploy an on-premises data gateway (personal mode) and configure the connection to Sales DB to use the DirectQuery Data Connectivity mode.

  4. Deploy an on-premises data gateway and configure the connection to Sales DB to use DirectQuery Data Connectivity mode.

Correct Answer: B

Question No.3

HOTSPOT

You open powrbi.com as shown in the following exhibit.

image

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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 two columns named Date and Time.

The tables have the following relationships:

image

The active relationship is on Sales[DueDate].

You need to create measure to count the number of order by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any 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?

  1. Yes

  2. No

Correct Answer: B

Question No.5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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 two columns named Date and Time.

The tables have the following relationships:

image

The active relationship is on Sales[DueDate].

You need to create measure to count the number of order by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.

Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.6

Note This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button)

image

You plan to develop a Power BI model at shown in the Power BI Model exhibit (Click the Exhibit button)

image

You plan to use Power BI to import data from 2013 to 2015 Product Subcategory[Subcategory] contains NULL values. End of repeated scenario.

You implement the Power BI model

You need to add a new column to the Product Subcategory table that uses the following formula.

-if [Subcategory]-null then 鈥淣A鈥?else [Subcategory] Which command should you use in Query Editor?

  1. Column from Examples

  2. Column Column

  3. Invoke Custom Function

  4. Conditional Column

Correct Answer: C

Question No.7

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

Your company has 1.000 users m a Microsoft Office 365 subscription

A Power BI administrator named Admin 1 creates 20 dashboards and shares them with 50 users. You discover that a user named User1 can access all the dashboard-.

You need to prevent User 1 from accessing all the dashboards

Solution: From the properties of each dashboard. you modify the Share settings Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.8

You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private

A user named User1 reports that App1 does not appear in the My organization AppSource App1 appears in the My organization AppSource for your account

You need to ensure that User 1 sees App1 from the My organization AppSource. What should you do?

  1. From the app workspace, click Update app, configure the Content settings, and then click Update app.

  2. From the app workspace settings, add a member.

  3. From the app workspace, click Update app. configure the Access setting and then click Update app.

  4. From the app workspace, share the dashboard.

Correct Answer: C

Question No.9

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

  1. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

  2. Deploy an on-premises data gateway. Import the data by using Import Data Connectivity mode.

  3. Deploy an on-premises data gateway (personal mode).Import the data by using Data Query Data Connectivity mode.

  4. Deploy an on-premises data gateway (personal mode). Import the data by using the Directory Query Data Connectivity mode.

Correct Answer: D

Question No.10

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

Your company has 1.000 users m a Microsoft Office 365 subscription

A Power BI administrator named Admin 1 creates 20 dashboards and shares them with 50 users. You discover that a user named User1 can access all the dashboard-.

You need to prevent User 1 from accessing all the dashboards

Solution: From Microsoft Azure Active Directory, you remove the Power BI license form User1. Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Get Full Version of the Exam
70-778 Dumps
70-778 VCE and PDF

Comments are closed.