Accurate of 70-778 rapidshare materials and tutorials for Microsoft certification for IT candidates, Real Success Guaranteed with Updated 70-778 pdf dumps vce Materials. 100% PASS Analyzing and Visualizing Data with Microsoft Power BI (beta) exam Today!
P.S. Accurate 70-778 tutorials are available on Google Drive, GET MORE: https://drive.google.com/open?id=1Zb7qlLlURVXOtFMDwxwzj1NnDPrxKcEG
New Microsoft 70-778 Exam Dumps Collection (Question 4 - Question 13)
Q4. 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:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
Q5. 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 add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
A. Table.RemoveMatchingRows
B. Table.Distinct
C. Table.InDistinct
D. Table.ReplaceMatchingRows
Answer: B
Explanation:
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx
Q6. You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?
A. Subscriptions
B. Dashboards
C. Datasets
D. Workbooks
Answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured- questions
Q7. 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: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter#add-a-filter-to-a-specific-visualization-aka-visual-filter
Q8. 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 Valuesu2026 Does this meet the goal?
A. Yes
B. No
Answer: B
Q9. 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?
A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.
C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.
D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes
Q10. 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
Q11. You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.
You need to ensure that when you select a year on the bar chart, the donut remains unchanged.
What should you do?
A. Set a visual level filter on the bar chart.
B. Edit the interactions form the Format menu.
C. Set a visual level filter on the donut chart.
D. Add a slicer to the page that uses the year column.
Answer: B
Explanation:
References: https://www.excelguru.ca/blog/2021/11/23/visual-interactions-in-power-bi/
Q12. 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
Q13. HOTSPOT
You have the following tables.
You need to create a measure to calculate a running total of TransactionQuantity.
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.
Answer:
Explanation:
References: http://www.daxpatterns.com/cumulative-total/
P.S. Easily pass 70-778 Exam with Certleader Accurate Dumps & pdf vce, Try Free: https://www.certleader.com/70-778-dumps.html (58 New Questions)