2018 June new Microsoft 70-778 Exam Dumps with PDF and VCE Free Updated Today! Following are some new 70-778 Real Exam Question:
1.|2018 Latest 70-778 Exam Dumps (PDF & VCE) 60Q&As Download:
https://www.braindump2go.com/70-778.html
2.|2018 Latest 70-778 Exam Questions & Answers Download:
https://drive.google.com/drive/folders/16paLNO0K007UUoxJ5EJClSbsQGAtO3Xy?usp=sharing
QUESTION 23
You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace.
What should you do?
A. From the Power BI Admin portal, click Usage metrics.
B. From the Office 365 Admin center, click Users.
C. From the Office 365 Admin center, click Groups.
D. From the Power BI Admin portal, click Tenant settings.
Answer: C
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365
QUESTION 24
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:
https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart-powerbi-report/
QUESTION 25
You have a workspace that contains 10 dashboards. A dashboard named Sales 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 properties of the dashboard, modify the Q&A settings.
C. From the Sales Data dashboard, modify the dashboard as a Favorite.
D. From the properties of the datasets, modify the Q&A and Cortana settings.
Answer: D
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
QUESTION 26
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 contains the following tables.
The following columns contain data 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 relationship to the Monthly_returns table on the Store_ID 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 order.
You need to calculate the number of orders.
What should you do?
A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
B. Create a calculated measure that uses the SUM (Order_ID) DAX formula.
C. Create a calculated column that uses the SUM (Order_ID) DAX formula.
D. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.
Answer: A
Explanation:
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
QUESTION 27
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 contains the following tables.
The following columns contain data 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 relationship to the Monthly_returns table on the Store_ID 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 plan to create a chart that displays total Order [Order_amount] by Store [Name]. You need to modify the model to ensure that you can create the chart. Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. To the Order table, add a column that uses the RELATED(`Store’ [Store_ID]) DAX formula.
B. Create a relationship between the Order table and the Store table.
C. To the Order table, add a measure that uses the COUNT (`Order'[Order_amount]) DAX formula.
D. To the order table, add a measure that uses the SUM (`Order’ [Order_amount]) DAX formula.
Answer: AD
Explanation:
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns
QUESTION 28
You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis Services (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 SalesDB.
What should you do?
A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.
B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.
C. Deploy an on-premises data gateway (personal mode) and configure to SalesDB to use the DirectQuery Data Connectivity mode.
D. Deploy an on-premises data gateway and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.
Answer: B
Explanation:
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
QUESTION 29
From Power BI Desktop, you create a query that imports the following table.
You need to configure the table to appear as shown in the following table.
What should you do?
A. From the Extract menu, click Last Characters.
B. From the Extract menu, click Text After Delimiter.
C. From the Format menu, click Trim.
D. From the Split Column menu, click BY Delimiter.
Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/mt798301.aspx
QUESTION 30
You plan to create several datasets by using the Power BI service.
You have the files configured as shown in the following table.
You need to identify which files can be used as datasets.
Which two files should you identify? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Data 1
B. Data2
C. Data 3
D. Data4
E. Data 5
Answer: AE
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-get-data
QUESTION 31
You have the following two queries in Power BI Desktop:
– A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
– A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database
Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers.
Which command should you use?
A. Combine Files
B. Merge Columns
C. Merge Queries
D. Append Queries
Answer: D
Explanation:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
QUESTION 32
You have a table in Power BI Desktop as shown in the following exhibit.
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row3. The solution must preserve all the data.
What should you do?
A. Change the Data Type of the Value column.
B. Select the Score column, and then click Remove Errors.
C. Select the Key column, and then click Remove Duplicates
D. Change the Aggregate Value Function of the pivot.
Answer: D
Explanation:
https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
QUESTION 33
You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales can view the report from the Sales site.
What should you do?
A. Configure the app workspace for Premium capacity.
B. Enable anonymous access for the Sales site.
C. Configure the Portal Site Connection for the Sales site.
D. Disable the Embed content in apps setting from the Tenant settings in Power BI.
Answer: A
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo
!!!RECOMMEND!!!
1.|2018 Latest 70-778 Exam Dumps (PDF & VCE) 60Q&As Download:
https://www.braindump2go.com/70-778.html
2.|2018 Latest 70-778 Study Guide Video: