|Exam Name||:||Analyzing and Visualizing Data with Power BI|
|Questions and Answers||:||144 Q & A|
|Updated On||:||Click to Check Update|
|PDF Download Mirror||:||70-778 Brain Dump|
|Get Full Version||:||Pass4sure 70-778 Full Version|
You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business. You create a report named Report1 that uses dataset1. You pin Report1 to a dashboard named Dashboard1.
You publish the app workspace to all the users in your organization. You need to delete dataset2 from the app workspace. What should you do first?
Unpublish the app.
Configure the refresh settings for Dataset2.
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 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 two types of visualizations should you exclude from the report? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
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?
Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
In Query Editor, add a calculated column that totals the sales amount column.
Change the Data Type of sales amount column to Numeric.
Refresh the data model.
You have a Power Pivot model that includes a KPI. You need to create a visualization based on the Power Pivot model as shown in the exhibit. (Click the Exhibit button.)
Which type of visualization should you use?
multi row card
You have a Power BI model that has a date table. A sample of the data shown in the following table.
You need to add a column to display the date in the format of December 01, 2014. Which DAX formula should you use in Power BI Desktop?
FORMAT([Date], "MMM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
FORMAT([Date], "MM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
[Date].[Month] & " " & FORMAT([Date], "D") & ", " & [Date].[Year])
FORMAT([Date], "MMMM DO, YYYY")
You have a Power Bl Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.)
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?
Modify the Customer Count measure to use the count function.
Modify the table relationship between the Customers table and the Sales table to use a Cross filter direction of Both.
Modify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both
Modify the Customer Count measure to use the countx function.