100% Guarantee 70-778 Ebook 2021

NEW QUESTION 1
You have a service published to a website.
When you connect to the website, you receive the following data.

You need to create a query that retrieves the Categories data and the Customers data. Which type of source should you use?

• A. JSON
• B. Text/CSV
• C. OData Feed
• D. XML

Answer: D

NEW QUESTION 2
Note: This question is a 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 query for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Replace Values… Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 3
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.

Answer: D

NEW QUESTION 4
You create a KPI visualization in Power BI Desktop that uses the month as the trend axis. You discover that the data is not sorted by month.
You need to change the sort order of the visualization. What should you do first?

• A. Convert the visualization to a different type.
• B. Remove the trend axis from the visualization.
• C. Modify the visual level filters.
• D. Modify the drill through filters.

Answer: B

NEW QUESTION 5
You need to create a custom visualization for Power BI. What should you install first?

• A. jQuery
• B. Node.js
• C. Microsoft Azure PowerShell
• D. Microsoft.NET

Answer: B

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools

NEW QUESTION 6
You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?

• A. The application token and the report URL
• B. The report URL and a user name
• C. The app workspace name and the access key
• D. The access key and the report ID

Answer: C

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/developer/integrate-report

NEW QUESTION 7
You have a query that uses a Microsoft Excel data source. The data source contains the following table.

You need the data to appear as shown in the following table.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 8
From Power BI Desktop, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard.
In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and received the expected results.
You need to ensure that the user can use both queries to receive the same results.
Which four actions should you perform in sequence? To answer, move the appropriate actions form the list of actions to the answer area and arrange them in the correct order.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Funnel charts
• B. Custom visuals
• C. Bubble maps
• D. Breadcrumbs
• E. R visuals

Answer: DE

Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart-powerbi-report/

NEW QUESTION 10
Note: This question is a part of a series of questions that present 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.)

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

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 “NA” else [Subcategory] Which command should you use in Query Editor?

• A. Column From Examples
• B. Custom Column
• C. Invoke Custom Function
• D. Conditional Column

Answer: D

Explanation:
References:
http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

NEW QUESTION 11
You have the following tables.

You need to create a new table that displays the top 10 customers by the total of SalesAmount.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 12
You are creating a report in Power BI Desktop. You are consuming the following tables.

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal month and calendar month. What should you do?

• A. Union Fiscal and Date as one table.
• B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
• C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
• D. Merge Fiscal into the Date table.

Answer: D

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

NEW QUESTION 13
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.

Answer: C

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/publisher-for-excel

NEW QUESTION 14
You have a Power 81 model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

• A. DATE ADD
• B. LASTDATE
• C. ENDOFVEAR
• D. PREVIOUSYEAR

Answer: D

NEW QUESTION 15
You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Download and install Microsoft R Server.
• B. Download and install RStudio Server on the computer that has Power BI Desktop installed.
• C. Install SQL Server R Services on the server that runs SQL Server.
• D. Enable R Scripting on the computer that has Power BI Desktop installed.
• E. Download and install Microsoft R on the computer that has Power BI Desktop installed.

Answer: E

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

NEW QUESTION 16
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) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

NEW QUESTION 17
You are configuring the relationships between the following tables.

A customer can have multiple accounts. An account can only be associated to one customer. Each account is associated to only one insurance policy.
You need to configure the relationships between the tables to ensure that you can create a report displaying customers and their associated insurance policies.
How should you configure each relationship? To answer, drag the appropriate cardinalities to the correct relationships. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

NEW QUESTION 18
You have a table named Sales. A sample of the data in Sales is shown in the following table.

You created a stacked column chart visualization that displays ProductName by Date. You discover that the axis for the visualization displays all the individual dates.
You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.
What should you do first?

• A. Configure a visual filter for the Date column that uses an advanced filter.
• B. Create a new table that has columns for the date, year, week, and day.
• C. Create a new hierarchy in the Sales table.
• D. Format the virtualization and set the type of the X-Axis to Categorical.

Answer: B

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter#add-a-filter-to-a-specific-visualization-aka

NEW QUESTION 19
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which three types of visualizations should you include in the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. bubble maps
• B. custom visuals
• C. R visuals
• D. breadcrumbs
• E. funnel charts

Answer: ABE

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop

NEW QUESTION 20
You have a Power BI model that contains the following tables:
Sales (Sales_ID, DateID, sales_amount)
Date (DateID, Date, Month, week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?

• A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (‘Date’ [Date]))
• B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (‘Date’ [Date]))
• C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[Date]))
• D. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]),DATESYTD(‘Date’[Date]))

Answer: C

Explanation:
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics https://msdn.microsoft.com/en-us/library/ee634972.aspx

NEW QUESTION 21
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format.
What should you do in the model before you create the relationship?

• A. Change the Data Type of ActivityStart to Date.
• B. Create a measure in ActivityLog that uses the format DAX function.
• C. Change the Data Type of DatelD to Date.
• D. Create a calculated column in ActivityLog that uses the format DAX function.

Answer: D

NEW QUESTION 22
Note: This question is 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.

The following columns contain date information:
• Date[Month] in the mmyyyy format
• Date[Date_ID] in the ddmmyyyy format
• Date[Date_name] in the mm/dd/yyyy format
• Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the StoreJD column. This is the only relationship between the tables.
You plan to use Power Bl Desktop to create an analytics solution for the data. End of repeated scenario.
You are modeling the data in Power Bl.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. In the Power Bl model, create a calculated table.
• B. From Query Editor, create a custom column that uses a custom column formula.
• C. From Query Editor, add a select statement that uses a where clause to the source definition.
• D. From Query Editor, create a column by using Column From Examples.
• E. From Query Editor, filter the table by Order_date.

Answer: C

NEW QUESTION 23
......