Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Approved 70-778 pdf are available on Google Drive, GET MORE: https://drive.google.com/open?id=1B1-cc80N9I92n0MN9aRLFZj3h3SJUCGh
Q1. You manage a Power BI model has a table named Sales.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= u201cUnited Statesu201d && [ProductCategory]= u201cClothingu201d
B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= u201cUnited Statesu201d
D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
Q2. 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:
u2711 Date[Month] in the mmyyyy format
u2711 Date[Date_ID] in the ddmmyyyy format
u2711 Date[Date_name] in the mm/dd/yyyy format
u2711 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(u2021Storeu2021 [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 (u2021Orderu2021[Order_amount]) DAX formula.
D. To the order table, add a measure that uses the SUM (u2021Orderu2021 [Order_amount]) DAX formula.
Answer: A,D
Explanation:
References:
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
Q3. 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
Q4. You have an on-premises Power BI Report Server.
You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?
A. Microsoft Azure SQL Database
B. a Microsoft SQL Server database
C. a Microsoft SQL Server Analysis Services (SSAS) database
D. Microsoft Excel
Answer: C
Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources
Q5. In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.
What should you do?
A. From the app workplace, click Update app, and then configure the Access settings.
B. Share the dashboard, and then modify the Access settings of the dashboard.
C. Configure security for the dataset used by the app.
D. Modify the members of the app workspace.
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365
Q6. 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
Q7. 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 need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then u201cNAu201d else [Subcategory] Which command should you use in Query Editor?
A. Column From Examples
B. Custom Column
C. Invoke Custom Function
D. Conditional Column
Answer: D
Explanation:
References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
Q8. 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
Q9. 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
Q10. 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 Microsoft Azure Active Directory, you remove the Power BI license from User1.
Does this meet the goal?
A. Yes
B. No
Answer: A
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
Recommend!! Get the Approved 70-778 dumps in VCE and PDF From Certifytools, Welcome to download: https://www.certifytools.com/70-778-exam.html (New 58 Q&As Version)