|Exam Name||:||Analyzing and Visualizing Data with Power BI|
|Questions and Answers||:||127 Q & A|
|Updated On||:||Click to Check Update|
|PDF Download Mirror||:||70-778 Brain Dump|
|Get Full Version||:||Pass4sure 70-778 Full Version|
|70-778 killexams.com | 70-778 dumps | 70-778 exam dumps | 70-778 braindumps | 70-778 exam braindumps | 70-778 real questions | 70-778 practice test | 70-778 practice questions | 70-778 questions and answers | 70-778 dumps free | 70-778 dumps free pdf | 70-778 killexams|
You need to create a custom visualization for Power BI. What should you install first?
Microsoft Azure PowerShell
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.
Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter.
Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight.
Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.
Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight.
Your company has a security policy stating that proprietary data must not be transferred over the Internet. During a security audit, auditors discover that executives use the Power BI service for reporting. You need to recommend a solution to ensure that the company adheres to the security policy. What should you include in the recommendation?
Microsoft SQL Server column encryption
Microsoft Azure ExpressRoute
a site-to-site VPN to Microsoft Azure
the on-premises gateway for Power BI
You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database. When you publish the Power BI Desktop project to the Power BI service,
the visualizations cannot display the data. What should you do to resolve the issue?
Locate the published dataset for the project in the Power BI service and configure the data source credentials.
Install the on-premises data gateway (personal mode) and republish the project.
Install the on-premises data gateway and configure a data source.
Configure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service.
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization. The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.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?
Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option.
Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.
Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
Deploy an on-premises data gateway. Connect to the data by using the Connect live option.
You create a new app workspace. You add a user named Userl1 as a member of the workspace. Userl1 can edit content. You plan to create a report in an app workspace that uses data from a Microsoft Azure SQL database. You need to create the report. The solution must ensure that Userl1 can edit the report from Power BI Desktop and from powerbi.com. 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.
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format. What should you do in the model before you create the relationship?
Change the Data Type of ActivityStart to Date.
Create a measure in ActivityLog that uses the format DAX function.
Change the Data Type of DatelD to Date.
Create a calculated column in ActivityLog that uses the format DAX function.
You have a query that uses a Microsoft Excel data source. The data source contains the following table.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)
The file is in c:\data\. You need to ensure that you can publish the file to Power BI. What should you do first?
Save the file in a Microsoft SharePoint document library.
Decrypt the workbook.
Add a digital signature to the workbook.
Set the file attributes to read-only.
You have two tables named Customer and Orders. A sample of the data in Customer is shown in the following table.
A sample of the data in Orders is shown in the following table.
You need to create the following new table.
You must use Customer as the first table. Which join kind should you use?