The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Vendor: Microsoft Exam Code: 70-778 Exam Name: Analyzing and Visualizing Data with Microsoft Power BI Full Version Q & As: 155
Get FULL VERSION Real Exam Dumps http://www.ensurepass.com/70-778.html
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 1 DRAG DROP You create a report in Power BI Desktop. You need to embed the report into a Microsoft SharePoint Online site. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
QUESTION 2 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.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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. B. C. D.
Create a calculated measure that uses the COUNTA(Order_ID) DAX formula. Create a calculated measure that uses the SUM (Order_ID) DAX formula. Create a calculated column that uses the SUM (Order_ID) DAX formula. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.
Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures QUESTION 3 HOTSPOT You create an app workspace named Wingtip Sales. Wingtip Sales is configured as shown in the following exhibit.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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.
Correct Answer:
QUESTION 4 DRAG DROP You are configuring the relationships between the following tables.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
A customer can have multiple accounts. An account can only be associated to one customer. Each account is associated to only one insurance policy. You need to configure the relationships between the tables to ensure that you can create a report displaying customers and their associated insurance policies. How should you configure each relationship? To answer, drag the appropriate cardinalities to the correct relationships. Each value 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.
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 5 You plan to use Power BI Desktop to create a report. The report will consume data from an onpremises 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. Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery QUESTION 6 You have a Power BI app named App1. The privacy for the App1 workspace is set to Private. A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account. You need to ensure that User sees App1 from the My organization AppSource. What should you do? A. From the app workspace, click Update app, configure the Content settings, and then click Update app. B. From the app workspace settings, add a member. C. From the app workspace, click Update app, configure the Access setting, and then click Update app. D. From the app workspace, share the dashboard. Correct Answer: C Explanation: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#whatGuaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
is-appsource QUESTION 7 You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data. Which data source you should use? A. B. C. D.
Microsoft Azure Data Lake Store Microsoft Azure Table Storage Microsoft Azure HDInsight Microsoft Azure SQL Database
Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect QUESTION 8 From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data.
You add Region and Sales to a visualization and the visualization displays the following data.
What causes the visualization to display four rows of data instead of six? A. B. C. D.
the Data Category of Region the Default Summarization on Region the Default Summarization on Sales the Data Category of Sales
Correct Answer: B QUESTION 9 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. Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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: Sales [DueDate] and Date [Date] Sales [ShipDate] and Date [Date] 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 a calculated table. You create a measure that uses the new table. Does this meet the goal? A. Yes B. No Correct Answer: B QUESTION 10 Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service. Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. B. C. D. E.
Retrieve rows from a dataset Create a dataset Add rows to a dataset Refresh an imported dataset Add a member to a row-level security role
Correct Answer: ABC
QUESTION 11 Note: This question is 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 Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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 one column named Date. The tables have the following relationships: The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading 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 Correct Answer: B QUESTION 12 DRAG DROP You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a dashboard that displays data from the tables. You update the tables each day. You need to ensure that the virtualizations in the dashboard are updated daily. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Correct Answer:
QUESTION 13 You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use? A. DATEADD B. TOTALYTD Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
C. DATESYTD D. ENDOFYEAR Correct Answer: C Explanation: https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/ QUESTION 14 HOTSPOT Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks: Access a published Power BI app Modify reports in an app workspace 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.
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 15 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. B. C. D.
From the settings of the workspace, modify the Language Settings. From the properties of the dashboard, modify the Q&A settings. From the Sales Data dashboard, modify the dashboard as a Favorite. From the properties of the datasets, modify the Q&A and Cortana settings.
Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-publicpreview QUESTION 16 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. Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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 properties of each dashboard, you modify the Share settings. Does this meet the goal? A. Yes B. No Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-yourorganization#how-do-i-remove-power-bi-for-users-that-already-signed-up QUESTION 17 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 three types of visualizations should you include in the report? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. B. C. D. E.
bubble maps custom visuals R visuals breadcrumbs funnel charts
Correct Answer: ABE Explanation: https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop QUESTION 18 Note: This question is part of a series of questions that use 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 button.)
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario. You need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50. Which DAX formula should you use?
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
A. B. C. D.
Option A Option B Option C Option D
Correct Answer: C QUESTION 19 Note: This question is 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 CustomerlD. The Data Type of CustomerlD 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 CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove Errors. Does this meet the goal? A. Yes B. No Correct Answer: B QUESTION 20 Note: This question is 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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power BI service. Solution: From Excel, click Publish to Power BI, and then click Export. Does this meet the goal? A. Yes B. No Correct Answer: B Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 21 You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do? A. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a report. Pin the report to a dashboard. B. Create an app workspace and publish the workspace to a dashboard. C. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a report. Pin the report to a dashboard. D. Add a custom streaming data tile to a dashboard. Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#set-up-your-real-timestreaming-dataset-in-power-bi QUESTION 22 You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What should you do? A. B. C. D.
Assign each user a Power BI Pro license. Store the dataset in Microsoft Azure Storage that uses the Premium storage tier. Create the app workspace by using an account that is assigned a Power BI Pro license. Configure the app workspace for Premium capacity.
Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/service-premium QUESTION 23 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.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
What should you do? A. B. C. D.
From the Extract menu, click Last Characters. From the Extract menu, click Text After Delimiter. From the Format menu, click Trim. From the Split Column menu, click BY Delimiter.
Correct Answer: B Explanation: https://msdn.microsoft.com/en-us/library/mt798301.aspx QUESTION 24 Note: This question is 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 one column named Date. The tables have the following relationships: The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create a calculated table. You create a measure that uses the new table. Does this meet the goal? A. Yes B. No Correct Answer: B
QUESTION 25 Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Note: This question is part of a series of questions that use 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 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 date 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 a relationship to the Monthly_returns table on the StoreJD column. This is the only relationship between the tables. You plan to use Power Bl Desktop to create an analytics solution for the data. End of repeated scenario. You are modeling the data in Power Bl. Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
You need to import only a sample of the data from the Order table. What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. B. C. D. E.
In the Power Bl model, create a calculated table. From Query Editor, create a custom column that uses a custom column formula. From Query Editor, add a select statement that uses a where clause to the source definition. From Query Editor, create a column by using Column From Examples. From Query Editor, filter the table by Order_date.
Correct Answer: C 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 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).
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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 measure to rank total sales by product. The results must appear as shown in the following table.
Which DAX formula should you use? A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip) B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense) C. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Skip) Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
D. Product Ranking= RANKX (ALL (`Product'), [SalesAmount], , Asc, Dense Correct Answer: B Explanation: https://msdn.microsoft.com/en-us/library/gg492185.aspx QUESTION 27 You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop. You need to create a bar chart showing the total sales amount by region. When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region. You need to modify the query to ensure that the data appears correctly. What should you do? A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server. B. In Query Editor, add a calculated column that totals the sales amount column. C. Change the Data Type of sales amount column to Numeric. D. Refresh the data model. Correct Answer: B QUESTION 28 You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year. You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year. What should you do? A. B. C. D.
Pin each visualization to the dashboard, and then add a web content tile. Add a page level filter, and then pin each visualization to the dashboard. Publish the app workspace. Pin the report as a live page.
Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-live-tile-from-report QUESTION 29 You have a Power Bl Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.)
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Customer Count is a measure that uses the countRows function to calculate the number of customers. You create a table visualization that displays ProductID, Product, and Customer Count. When you view the table, you discover that Customer Count always displays the total number of customers instead of the number of customers who purchased the product. You need to ensure that the table visualization displays the number of customers who purchased each product. What should you do? A. Modify the Customer Count measure to use the count function. B. Modify the table relationship between the Customers table and the Sales table to use a Cross filter direction of Both. C. Modify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both D. Modify the Customer Count measure to use the countx function. Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships QUESTION 30 You have the following tables.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to Single. You plan to create a column chart that displays the following two measures: Count of SubscriberID by Month based on the StartDate Count of SubscriberID by Month based on the EndDate What should you do before you create the measures? A. B. C. D.
Create an active one-to-one relationship from Subscriber[StartDate] to Date[Date]. Change the Cross filter direction of the active relationship to Both. Change the active relationship for many-to-one. Create an inactive many-to-one relationship from Subscriber[StartDate] to Date[Date].
Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships QUESTION 31 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 Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-yourorganization#how-do-i-remove-power-bi-for-users-that-already-signed-up QUESTION 32 You plan to use Power BI Desktop to import 100 CSV files. The files contain data from different stores. The files have the same structure and are stored in a network share. You need to import the CSV files into one table. The solution must minimize administrative effort. What should you do? A. B. C. D.
Add a folder data source and use the Combine Files command. Add a folder data source and use the Merge Queries command. Add a Microsoft Excel data source and use the Merge Queries command. Add text/CSV data sources and use the Append Queries command.
Correct Answer: A Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries QUESTION 33 Note: This question is 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 CustomerlD. The Data Type of CustomerlD 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 CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column. Click Replace Errors... and enter a value of 0 Does this meet the goal? A. Yes B. No Correct Answer: A QUESTION 34 DRAG DROP Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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).
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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 edit the Product Category table query to match the desired Power BI model. How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 35 DRAG DROP You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a dashboard that displays data from the tables. You update the tables each day. You need to ensure that the visualizations in the dashboard are updated daily. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE. More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 36 DRAG DROP You have a query named FactlnternetSales used by several Power BI reports. The query is shown in the exhibit. (Click the Exhibit button.)
You plan to create a bar chart showing the count of sales by year that have a SalesAmount greater than $1,000. You need to create a measure that will be used in the bar chart. How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets. Each value 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.
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 37 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. B. C. D.
The application token and the report URL The report URL and a user name The app workspace name and the access key The access key and the report ID
Correct Answer: C Explanation: https://docs.microsoft.com/en-us/power-bi/developer/integrate-report QUESTION 38 Your company has a custom line-of-business application named SalesApp. The developers of SalesApp want to push data into the Power BI service to create several visualizations. You need to ensure that the developers can push the data from SalesApp to the Power BI service. What should you do? A. B. C. D.
Go to portal.azure.com and create a web app. Go to dev.powerbi.com/apps and register an application. Go to app.powerbi.com/admin-portal and click Publish to web. Go to app.powerbi.com and create an app workspace.
Correct Answer: B Explanation: https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-withazure-ad QUESTION 39 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. B. C. D.
Microsoft Azure SQL Database a Microsoft SQL Server database a Microsoft SQL Server Analysis Services (SSAS) database Microsoft Excel
Correct Answer: C Explanation: 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 Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 40 You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd. You create a new Power BI Desktop model that uses 120 tables from SQLDev. You plan to publish the Power BI file to the Power BI service. You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort. What should you do from Query Editor before you publish the model? A. B. C. D.
Create a new connection to SQLProd, and then import the tables from SQLProd. Delete the existing queries, and then add new data sources. Configure the Data source settings. Edit the source of each table query.
Correct Answer: D Explanation: https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data QUESTION 41 Note: This question is 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 user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace. You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI. Does this meet the goal? A. Yes B. No Correct Answer: A Explanation: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-andoffice-365 QUESTION 42 You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table. Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
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. B. C. D. E.
Data 1 Data2 Data 3 Data4 Data 5
Correct Answer: AE Explanation: https://docs.microsoft.com/en-us/power-bi/service-get-data QUESTION 43 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 Correct Answer: A Explanation: Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-yourorganization#how-do-i-remove-power-bi-for-users-that-already-signed-up QUESTION 44 You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.
You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart. A. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter. B. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight. C. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter. D. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight. Correct Answer: C Explanation: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions QUESTION 45 You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: Customer ID CustomerName Address City ProvState Country You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart? Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
A. B. C. D.
In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City. In the Axis field, add Country at the top, followed by ProvState, and then City. In the Value field, add Country at the top, followed by ProvState, and then City.
Correct Answer: C Explanation: https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18 https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down QUESTION 46 Note: This question is 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 user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace. You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the PowerBI setting, you modify the Developer Settings. Does this meet the goal? A. Yes B. No Correct Answer: B QUESTION 47 Note: This question is 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 user named User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards. Solution: From the Office 365 Admin center, you remove the Power BI license from User1. Does this meet the goal? A. Yes Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
B. No Correct Answer: B QUESTION 48 HOTSPOT You have a Power BI model that has the following tables: Product (Product_id, Product_Name) Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID]) You need to create the following relationships: Sales to Product Sales to Salesperson The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson. How should you configure the relationships? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Correct Answer:
Guaranteed Success with EnsurePass VCE Software & PDF File
The Latest 70-778 Exam ☆ Instant Download ☆ Free Update for 365 Days
QUESTION 49 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. B. C. D.
Modify the members of the app workspace. Configure security for the dataset used by the app. Share the dashboard, and then modify the Access settings of the dashboard. From the app workspace, click Update app, and then configure the Access settings.
Correct Answer: C QUESTION 50 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. B. C. D.
Subscriptions Dashboards Datasets Workbooks
Correct Answer: C Explanation: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions
Guaranteed Success with EnsurePass VCE Software & PDF File
EnsurePass.com All Products 20% OFF! Copy it : MMJ4-IGD8-X3QW
100-105 Dumps
200-105 Dumps
70-410 Dumps
663 Q&As
269 Q&As
517 Q&As
Updated: 02-01-2020
Updated: 02-01-2020
Updated: 02-01-2020
Price: $63.99
Price: $63.99
Price: $63.99
70-411 Dumps
70-412 Dumps
SY0-501 Dumps
399 Q&As
467 Q&As
659 Q&As
Updated: 02-01-2020
Updated: 02-01-2020
Updated: 02-01-2020
Price: $63.99
Price: $63.99
Price: $63.99
Hot Exams Dumps List 70-410
AZ-103
210-260
70-411
AZ-900
300-101
70-412
MD-100
300-115
70-461
MD-101
300-135
70-462
PL-900
300-206
70-463
300-208
70-480
100-105
300-209
70-483
200-105
300-210
70-486
200-125
300-320
70-487
200-150
400-101
70-740
200-155
70-741
200-310
200-1001
70-742
200-355
200-1002
70-761
210-060
SY0-501
70-762
210-065
CAS-003
70-767
210-250
70-768
210-255