70-778 Exam
A Review Of Virtual 70-778 forum
It is more faster and easier to pass the Microsoft 70-778 exam by using Best Quality Microsoft Analyzing and Visualizing Data with Microsoft Power BI (beta) questuins and answers. Immediate access to the Abreast of the times 70-778 Exam and find the same core area 70-778 questions with professionally verified answers, then PASS your exam with a high score now.
P.S. Best Quality 70-778 samples 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)
Question No: 2
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
Question No: 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.
Your company has 1,000 users in a Microsoft Office 365 subscription.
A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.
You discover that a use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.
Solution: From the Power BI Admin portal, you modify the Dashboard settings. Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-your-organization#how-do-i-remove-power-bi-for-users-that-already-signed-up
Question No: 4
HOTSPOT
You open powerbi.com as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-data-classification
Question No: 5
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 Remove Errors. Does this meet the goal?
A. Yes
B. No
Answer: B
Question No: 6
You have a Power BI model for sales data.
You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.
Which DAX function should you use?
A. PARALLELPERIOD
B. SAMEPERIODLAST YEAR
C. DATESYTD
D. PREVIOUSYEAR
Answer: A
Explanation:
References: https://msdn.microsoft.com/en-us/library/ee634873.aspx
Question No: 7
HOTSPOT
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.
Answer:
Explanation:
References: https://msdn.microsoft.com/en-us/library/gg492198.aspx
Question No: 8
You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
The reports display the data configured as shown in the following table.
You need to ensure that the users of the reports can locate the correct report by using natural language queries.
What should you do?
A. From the properties of the dataset, create four Featured Q&A Questions.
B. From the Format settings of the reports, modify the Page Information.
C. From the properties of the dataset, modify the Q&A and Cortana settings.
D. From the properties of the workspace, modify the Language Settings.
Answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
Question No: 9
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
Question No: 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 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
Question No: 11
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: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
P.S. Easily pass 70-778 Exam with Certifytools Best Quality Dumps & pdf vce, Try Free: https://www.certifytools.com/70-778-exam.html (58 New Questions)