P.S. Best Quality 70-778 practice exam are available on Google Drive, GET MORE: https://drive.google.com/open?id=1Zb7qlLlURVXOtFMDwxwzj1NnDPrxKcEG
New Microsoft 70-778 Exam Dumps Collection (Question 2 - Question 11)
New Questions 2
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: D,E
Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart- powerbi-report/
New Questions 3
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 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:
u2711 Sales [DueDate] and Date [Date]
u2711 Sales [ShipDate] and Date [Date]
u2711 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 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?
A. Yes
B. No
Answer: B
New Questions 4
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 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:
u2711 Sales [DueDate] and Date [Date]
u2711 Sales [ShipDate] and Date [Date]
u2711 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 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?
A. Yes
B. No
Answer: A
Explanation:
References:
https://msdn.microsoft.com/en-us/library/ee634966.aspx https://msdn.microsoft.com/en-us/library/ee634825.aspx https://msdn.microsoft.com/en-us/library/ee634791.aspx
New Questions 5
You have the following two queries in Power BI Desktop:
u2711 A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
u2711 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:
References: http://radacad.com/append-vs-merge-in-power-bi-and-power-query
New Questions 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 Questions 7
HOTSPOT
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
u2711 Access a published Power BI app
u2711 Modify reports in an app workspace
u2711 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.
Answer:
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 Questions 8
You have a power BI model that contains the following tables:
u2711 Assets( AssetsID, AssetName, Purchase_DateID, Value)
u2711 Date( DateID, Date, Month, Week, Year)
The tables have relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the percentage that the total assets value
increased since one year ago. Which DAX formula should you use?
A. (sum(Assets[Value])
u2013CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(u2021Dateu2021[Date])))/CALCULATE
(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021 [Date]))
B. CALCULATEx(sum(Assets[Value]) DATESYTD (u2021Dateu2021[Date]))/sum(Assets[Value])
C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021 [Date]))
D. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021
[Date]))/sum(Assets[Value])
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 Questions 9
HOTSPOT
You have a query that retrieves data from a Microsoft Azure SQL database.
You discover that column named ErrorCode has several values starting with a space character, and a column named SubStatus contains several non-printable characters.
You need to remove all the leading whitespaces from ErrorCode and all the non-printable characters from SubStatus. All other data must be retained.
What should you do on each column? To answer, drag the appropriate tasks to the correct columns. Each task 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.
Answer:
Explanation:
References:
https://msdn.microsoft.com/en-us/library/mt260494.aspx https://msdn.microsoft.com/en-us/library/mt253328.aspx
New Questions 10
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
A. Visual1
B. Visual2
C. Visual3
D. Visual4
E. Visual5
Answer: B,D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web
New Questions 11
You have two tables named CustomerVisits and Date in a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)
You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month. What should you do?
A. Create a relationship between the CustomerVisits table and the Date table.
B. Create a hierarchy in the Date table.
C. Modify the n=measure to use the CALCULATE DAX function.
D. Modify the measure to use the SUM DAX function.
Answer: A
Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
Recommend!! Get the Best Quality 70-778 dumps in VCE and PDF From Examcollection, Welcome to download: http://www.examcollectionuk.com/70-778-vce-download.html (New 58 Q&As Version)