The new 70-779 dumps pdf 2019 now are available, here are part of 70-779 exam questions (FYI):
[Get the download link at the end of this post]
Download Latest 70-779 Exam Dumps: http://bit.ly/power-bi-70-779-dumps
NEW QUESTION 1
Your company has a data analyst who uses Microsoft Power BI Desktop to create a data model and several reports. The data analyst publishes the reports to the Power BI service. You need to create a PivotTable in Excel that uses the data model created by the data analyst. The solution must prevent the data from being imported into Excel. What should you do first?
A. From powerbt.com, select the report. From the File menu, click Save as.
B. From Excel, create a new query that uses the Data Catalog.
C. From powerbi.com, select the report From the File menu, click Download report.
D. From powerbi.com, select the report and click Analyze in Excel.
Answer: D
NEW QUESTION 2
You have a PivotChart template named Template1. You add a PivotChart to a worksheet. You need to apply the template to the PivotChart. What should you do?
A. On the Design tab, click Change Chart Type.
B. On the Format tab, click Format Selection.
C. Right-click the chart and then click PivotChart Options.
D. Right-click the chart and then click Format Chart Area.
Answer: A
Explanation:
-- Click the chart.
-- On the Charts tab, under Change Chart Type, click Other, and then under Templates, click the chart template that you created.
NEW QUESTION 3
You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier. You need to minimize the amount of memory used to load the mode. The solution must ensure that you can create visualizations based on Price, Quantity, and Total. What should you do?
A. Replace the Total column by using a measure.
B. Replace the Total column by using a calculated column.
C. From Query Editor, remove duplicate rows from the table.
D. Move the Total column to a lookup table.
Answer: B
NEW QUESTION 4
You have an Excel workbook that has the following two workbook queries:
-- A query named consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database
-- A query named employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database
Both tables have the same columns. You need to combine all the data from Consultants and Employees into one table. Which command should you use?
A. Transpose
B. Append Queries
C. Merge Queries
D. Combine Binaries
Answer: B
NEW QUESTION 5
You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1. but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.
Solution: You delete the existing queries, and then you add new data sources.
Does this meet the goal?
A. Yes
B. No
Answer: B
NEW QUESTION 6
You have a table that contains data relating to exam candidates and their associated scores. You need to visualize the exam data by separating the data into quartiles. The visualization must display the mean score and must identify any outliers. Which type of chart should you use?
A. line
B. histogram
C. pie
D. box and whisker
Answer: D
NEW QUESTION 7
You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do?
A. From the File tab, click Option, and then modify the Data option.
B. From the File tab, click Options, and then modify the General options.
C. From the Data tab, click Queries & Connections, and then edit the properties of the query.
D. From the Power Pivot model, modify the Table Behavior setting.
Answer: C
NEW QUESTION 8
You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months. What should you use to define the target value?
A. an absolute value
B. a calculated column
C. a calculated field
D. a measure
Answer: A
NEW QUESTION 9
You install Microsoft Power BI Publisher for Excel. You need to use Excel to connect and analyze Power BI data. To which two types of Power BI data can you connect? (Each correct answer presents a complete solution. Choose two.)
A. apps
B. datasets
C. reports
D. dashboard
Answer: BC
Explanation:
Analyze in Excel is very useful for datasets and reports that connect to Analysis Services Tabular or Multidimensional databases, or from Power BI Desktop files or Excel workbooks with data models that have model measures created using Data Analysis Expressions (DAX).
NEW QUESTION 10
You have a workbook query that loads data from C:\Data\Users.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refresh the data from Users.xlsx. What should you do?
A. From the Linked Table tab in Power Pivot, modify the Update Mode.
B. From Query Editor, modify the Source step.
C. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
D. From the Data tab in Excel click Connections, and then modify the properties of the connection.
Answer: A