259 Teil 1: Data Connectivity, Storage Modes, Refresh

1.

2.

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

3.

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?

1. You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset can be refreshed in powerbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. 
   

   You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

1. You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

1. HOTSPOT You are using Power BI Desktop to connect to an Azure SQL database. The connection is configured 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 solution is worth one point

1. DRAG DROP

You have two Microsoft Excel workbooks in a Microsoft OneDrive folder. Each workbook contains a table named Sales. The tables have the same data structure in both workbooks. You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset. Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode 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

1. 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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date. Does this meet the goal?

1. You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

1. You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. You have a PBIX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

1. You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

1. DRAG DROP You publish a dataset that contains data from an on-premises Microsoft SQL Server database. The dataset must be refreshed daily. You need to ensure that the Power BI service can connect to the database and refresh the dataset. CertyIQ Which four actions should you perform n sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway. You confirm the following with the administrator of the gateway:

•You have the appropriate permissions to use the gateway.

•The data source was created on the gateway.

•The gateway has a status of Running. What is the most likely reason the gateway is unavailable?

A.The type of data source is not supported by the on-premises data gateway. B.The server name in the PBIX file does not match the data source name in the gateway. C.The credentials for the data source are invalid. D.The data source is configured to use single sign-on (SSO)