70-778 (UQ)

Which of the following statements are true with regard to using the Slicer visual in a Power BI report? (Select all that apply) ​ A. A Slicer visual is used on Power BI reports to provide the report consumer with interactive filtering behavior. ​ B. A Slicer visual from a Power BI report can be pinned to a dashboard to make the dashboard interactive. ​ C. A Slicer visual based on a Date column can be configured to use slider controls. ​ D. When adding a field to the Field well of a Slicer visual, you can use either a column or a measure.

A. A Slicer visual is used on Power BI reports to provide the report consumer with interactive filtering behavior. C. A Slicer visual based on a Date column can be configured to use slider controls. Explanation Slicer cannot be pinned to dashboard because dashboards are not interactive. Measure are not allowed to use in slicer.

Which of the following resources are automatically provisioned when you create a new app workspace in the Power BI Service? (Select all that apply) A. A storage container for Power Bl resources including datasets, reports and dashboards B. An Azure Active Directory user account to serve as the workspace identity C. An Office 365 Group which triggers the creation of a SharePoint team site D. A shared capacity which is used to host the workspace

A. A storage container for Power Bl resources including datasets, reports and dashboards B. An Office 365 Group which triggers the creation of a SharePoint team site

Which two field options are available when creating a waterfall chart? ​ A. Category ​ B. X Axis ​ C. Y Axis ​ D. Size

A. Category C. Y Axis Explanation When creating a waterfall chart, you need to define both the Category and the Y Axis fields.

What are the possible options to share a dashboard with other users? (Select all that apply) A. Click the ellipsis next to the dashboard name on the Dashboards list, and then click Share. B. Click Share from the upper right of the dashboard you want to share. C. From your browser, click Share. D. Right-click anywhere in the dashboard, and then click Share.

A. Click the ellipsis next to the dashboard name on the Dashboards list, and then click Share. B. Click Share from the upper right of the dashboard you want to share. Explanation 3rd option is not valid. Right click anywhere won't give you any sharing option.4

How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created. A. Connect to the files with Folder connector and use the Combine Binaries functionality B. Connect to a new file each month, perform transformations, and use Append function in Power Query Editor to combine all targets in the same table

A. Connect to the files with Folder connector and use the Combine Binaries functionality Explanation Connecting to files separately will take time if there are lot of files in the folder. Its always better to connect to folder if files have same structure. If you copy new files in that folder with same structure, that file will be loaded automatically without doing any change to data sources.

You want to create a line chart showing Quantity by the invoice date. You notice that there is a relationship between the Date from the Date table and the Invoice Date Key from the Sale table, but the relationship is inactive. All other visuals in your report will be analyzing values by delivery date. How should you approach this problem? ​ A. Create the following measure:Quantity by Invoice Date =CALCULATE (SUM ( Sale[Quantity] ),USERELATIONSHIP ( 'Date'[Date], Sale[Invoice Date Key] )) ​ B. Delete the relationship based on the delivery date and activate the relationship based on the invoice date. ​ C. Activate the relationship based on invoice date, keeping the other relationship as is. ​ D. Use the TREATAS function.

A. Create the following measure:Quantity by Invoice Date =CALCULATE (SUM ( Sale[Quantity] ),USERELATIONSHIP ( 'Date'[Date], Sale[Invoice Date Key] )) (Correct) Explanation The answer is A. Because this is going to be a one-off visual, creating a measure that activates the relationship at query time solves the problem and involves the least effort.If you delete the relationship based on delivery date, as option B suggests, other visuals that use the Date table will display the wrong values. Following option C is not possible because no more than one relationship can be active at a time. Using TREATAS as peroption D will result in the wrong figures.

Which of the following operations can be accomplished by a developer using the Power BI Service API (aka Power BI REST API)? (Select all that apply) A. Creating a new dataset B. Adding rows to an existing dataset C. Retrieving rows from an existing dataset D. Refreshing an imported dataset

A. Creating a new dataset B. Adding rows to an existing dataset D. Refreshing an imported dataset Explanation It's not allowed to retrieve data from dataset.

The marketing team needs a new dashboard to show the uptake of social users on the company's corporate forum. The dashboard will contain one particular report that shows the total number of users that registered for the site in each of the months of the year. For this report you want to create a dataset with a calculated column that displays the date with the abbreviated month name followed by the four digit year e.g. Jan 2018 Which DAX expression should you use? ​ A. FORMAT( [RegistrationDate], "MMM yyyy" ) ​ B. FORMAT( [RegistrationDate], "MM yyyy" ) ​ C. FORMAT( [RegistrationDate], "mm yyyy" ) ​ D. FORMAT( [RegistrationDate], "M yyyy" )

A. FORMAT( [RegistrationDate], "MMM yyyy" )

How to create a chart by "Asking Question" feature? (Select all that apply) A. Home -> Ask Question B. Double Click on Report View C. Modeling-> Ask Question

A. Home -> Ask Question B. Double Click on Report View

What are the advantages of installing Power BI Desktop from the Microsoft Store instead of installing it using the standard MSI download? (Select all that apply) A. Installation does not require administrative privileges. B. It provides Power Bl Desktop with greater access to content in Office 365 and Microsoft Azure. C. Monthly updates for Power Bl Desktop are automatically installed in the background when they're available. D. It lowers the total cost of ownership (TCO) for an organization's IT department when distributing Power Bl Desktop to a large audience.

A. Installation does not require administrative privileges. C. Monthly updates for Power Bl Desktop are automatically installed in the background when they're available. D. It lowers the total cost of ownership (TCO) for an organization's IT department when distributing Power Bl Desktop to a large audience.

Into which of the following scopes can you import a custom visual created for Power BI? A. Into the scope of a Power Bl Desktop project B. Into the scope of your personal workspace C. Into the scope of an app workspace D. Into the scope of a premium capacity

A. Into the scope of a Power Bl Desktop project Explanation Custom visual can be imported In Power Bl Desktop and power bi Service. 1st Option is correct other 3 are wrong.

What does the option "Assume Referential Integrity" in Power BI Desktop mean(When creating relationships between tables)? ​ A. It enables queries on the data source to use INNER JOIN rather than OUTER JOIN which improves query efficiency ​ B. It assumes that there are no blank or null values in any of the data tables in the relationships ​ C. It allows for calculated columns to be used as the relationship column between two tables ​ D. It automatically assumes that your relationship is 1:1(Rather than 1:Many or Many:1)

A. It enables queries on the data source to use INNER JOIN rather than OUTER JOIN which improves query efficiency Explanation Setting Assume referential integer enables queries on the data source to use INNER JOIN statement rather than OUTER JOIN, which improves query efficiency.

What are the limitations of live connection? (Select all that apply) A. It is not possible to define relationship in live connection. B. Some visuals are not supported in live connection mode. C. Transformation cannot be applied to data. D. Need extra steps to share reports with users with free Power Bl license.

A. It is not possible to define relationship in live connection. C. Transformation cannot be applied to data.

Which three statements describe the Applied Step's area in the Query Editor window? A. It records the list of steps from connecting to the data source t o all the steps applied to the data. B. The recorded list is based on the step that has the least effect to the step that has the most effect to the data source. C. The recorded list follows the sequence of steps applied to the data source. D. You can modify the connection to the data source by modifying the Source step settings.

A. It records the list of steps from connecting to the data source t o all the steps applied to the data. C. The recorded list follows the sequence of steps applied to the data source. D. You can modify the connection to the data source by modifying the Source step settings. Explanation: The Applied steps area records the list of steps you performed on the data starting from the time you connect to the data source. The recorded list follows the sequence of steps you applied to the data and you can modify any of these steps by modifying the settings or simply removing them from the list.

Which three fields are available when creating a Pie chart visualization? ​ A. Legend ​ B. Group ​ C. Details ​ D. Value

A. Legend C. Details ​ D. Value Explanation When creating a Pie chart, you can define the Legend, Details, and Values fields.

Which language can be used when designing a query in Power BI Desktop? (Select all that apply) ​ A. M ​ B. SQL ​ C. Python ​ D. MDX

A. M ​ B. SQL ​ D. MDX Explanation Python can't be used for designing data sources.

Which of the following cardinalities are available in Power BI table relationships? (Select all that apply) A. Many to One B. One to One C. One to Many D. Many to Many

A. Many to One B. One to One C. One to Many D. Many to Many Explanation Power BI supports all cardinalities (Many to One , Many to Many , One to One , One to Many).

You are the BI developer at Adventure Works responsible for enabling report creation and sharing by business users. Currently, there is an on-premises data warehouse built with SQL Server 2017, and there are some files stored on a shared drive that contain sales targets. The files are updated manually on a weekly basis. All reports need to be refreshed automatically at-least once a day. Everyone in the organization has a Power BI Pro license. Adventure Works has a hot-desking policy, and all employees must lock their laptops in allocated cabinets. Some business users would like to be able to create their own reports and share them internally. Only a select group of users must have the rights to share reports externally. Adventure Works has a separate manager for each product category. One of the reports must be secured in such a way that each manager must be able to see the products of the category they manage only, while the CEO must be able to see all sales. An HR analyst maintains a table that maps the category name to the manager email address. The management requested your assistance in making sure that business users can create and share their Power BI reports within the organization. Based on background information and business requirements, answer the following question Business users ask your guidance on how they should configure automatic refresh. Which gateway installation mode is appropriate for Adventure Works? A. On-Premises Data Gateway B. On-Premises Data Gateway (Personal Mode)

A. On-Premises Data Gateway Explanation The answer is A. Because users need to lock their laptops away each night, a personalgateway is not a good choice. Furthermore, because the users need to use the samedata sources, installing gateways in personal mode is going to create extra work comparedto installing a single data gateway.

To create a column chart that displays Quantity by Color and can be drilled down to show Quantity by Stock Item. Which of the following solves the problem? (Select all that apply) ​ A. Put Color and Stock Item on axis. ​ B. Put Color on axis and Stock Item on legend. ​ C. Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. ​ D. Put Color on Axis and Stock Item on Tooltips.

A. Put Color and Stock Item on axis. C. Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. Explanation The correct answers are A and C. With either option, you will be able to drill down in the hierarchy. Answer B is wrong because you cannot use the legend to drill down. If you follow the option D, you will not see stock item names in the visual.

Why query parameters are used ? (Select all that apply) ​ A. Refine a dataset. ​ B. Add dynamic values. ​ C. Transform Data ​ D. Reduce size of dataset

A. Refine a dataset. ​ B. Add dynamic values. ​ D. Reduce size of dataset

In which of the following scenario refreshing an imported data set in the Power BI Service require either the on-premises gateway or a personal gateway? (Select all that apply) A. Refreshing a dataset which imports its data from an on premises SQL Server database. B. Refreshing a dataset which imports its data from an Azure SQL database. C. Refreshing an imported dataset which relies on an R input script as its source. D. Refreshing a dataset which imports its data from a list in Share Point Online.

A. Refreshing a dataset which imports its data from an onpremises SQL Server database. C. Refreshing an imported dataset which relies on an R input script as its source. Explanation: Sharepoint and Azure SQL database are online microsoft technologies that doesn't require On-Premise gateway.

Which views can be used in Power BI Desktop Data Model to create a new dimensional hierarchy? (Select all that apply) ​ A. Report View ​ B. Data View ​ C. Relationships View

A. Report View ​ B. Data View Explanation You cannot create hierarchy from Relationship view

Which of the following are advantages that Power BI reports have over Power BI dashboards? (Select all that apply) ​ A. Reports provide a better interactive filtering and drilldown experience. ​ B. Reports provide story telling capabilities using bookmarks. ​ C. Reports provide a better real-time experience when displaying data from a streaming dataset. ​ D. Report definitions can be saved using an external file format (PBIX) and checked into source control.

A. Reports provide a better interactive filtering and drilldown experience. ​ B. Reports provide story telling capabilities using bookmarks. ​ D. Report definitions can be saved using an external file format (PBIX) and checked into source control. Explanation Reports don't support streaming datasets. This feature is available in dashboard tiles.

Which two cross filter directions are available in Power BI table relationships? A. Single B. Double C. Both D. Multiple

A. Single C. Both Explanation Power BI table relationships support single and both cross filter directions.

In order to use the Power BI web part in SharePoint Online, the report author as well as all the report consumers require a Power BI Pro license. Is this statement true ? ​ A. TRUE ​ B. FALSE

A. TRUE Explanation All sharepoint report viewers must have Power BI pro license.

Which of the following statements are true with regard to designing Power BI content for mobile devices? (Select all that apply) A. The Power Bl Desktop report designer provides Phone Layout View to design reports which target mobile devices. B. The Power Bl Service report designer provides Phone Layout View in the browser to design reports which target mobile devices. C. The Power Bl Desktop dashboard designer provides Phone view to design dashboards which target mobile devices. D. The Power Bl service dashboard designer provides Phone view in the browser to design dashboards which target mobile devices.

A. The Power Bl Desktop report designer provides Phone Layout View to design reports which target mobile devices. D. The Power Bl service dashboard designer provides Phone view in the browser to design dashboards which target mobile devices. Explanation Power Bi Service reports page doesn't provide phone layout feature. Power Bl Desktop doesn't have dashboards.

Consider the following DAX formula for a calculated column in the Sales table: UnitPrice = Sales[Revenue] / Sales[Units] Which three statements describe the DAX formula? A. The formula creates a calculated column named UnitPrice . B. The value of the calculated column is dependent on the Revenue column. C. The value of the calculated column is dependent on the Units column. D. The Data type of the calculated column is Text.

A. The formula creates a calculated column named UnitPrice . B. The value of the calculated column is dependent on the Revenue column. C. The value of the calculated column is dependent on the Units column. Explanation The DAX formula creates a calculated column named UnitPrice, which values are derived from the value of Revenue column in the Sales table, divided by the value of Units column in the Sales table.

Which of the following report page details are recorded when you create a bookmark? (Select all that apply) A. The sort order of rows in a Table visual B. The current selection(s) for each slicer on the page C. The next page in the current bookmark collection's sequence D. Whether a visual has been spotlighted or hidden

A. The sort order of rows in a Table visual B. The current selection(s) for each slicer on the page D. Whether a visual has been spotlighted or hidden Explanation Bookmark stores current page but not the next page.

What happens when you click on Focus mode of a tile in Power BI dashboard? A. The tile you selected expands and takes the full space. B. The report from which the tile was pinned opens. C. The Power Bl desktop file gets downloaded. D. The Power Bl desktop file opens.

A. The tile you selected expands and takes the full space. Explanation When viewing a Power BI dashboard in a browser window, clicking the focus mode of a tile will expand the tile to take the full space.

What are the three reasons for which you might use calculated tables? ​ A. To union tables ​ B. To improve the speed and performance of an existing table ​ C. To perform different types of merge join ​ D. To create a table based on the result of a function or formula

A. To union tables C. To perform different types of merge join D. To create a table based on the result of a function or formula Explanation You can use calculated tables to create a table based on the result of a function or formula. For example, you can use calculated tables to union tables and perform different types of merge join.

Which of the following statements are true with respect to setting the Cross-filter Direction property for a table relationship based on two tables with a one-to-many relationship? (select all that Apply) ​ A. When the Cross-filter Direction is set to Single, the tabular database engine will only propagate the context filter in one direction from the one-side table to the many-side table. ​ B. When the Cross-filter Direction is set to Single, the tabular database engine will only propagate the context filter in one direction from the many-side table to the one-side table. ​ C. When the Cross-filter Direction is set to Both, the tabular database engine will propagate the context filter in both directions. ​ D. There are cases where setting the Cross-filter Direction to Both is not allowed because it creates an ambiguity that cannot be resolved.

A. When the Cross-filter Direction is set to Single, the tabular database engine will only propagate the context filter in one direction from the one-side table to the many-side table. ​ C. When the Cross-filter Direction is set to Both, the tabular database engine will propagate the context filter in both directions. ​ D. There are cases where setting the Cross-filter Direction to Both is not allowed because it creates an ambiguity that cannot be resolved.

The following table contains a Parent-Child hierarchy on the columns: Employee Key and Parent Employee Key. From the table you can see that employee 112 has no parent defined, employee 14 has employee 112 as manager (ParentEmployeeKey), employee 3 has employee 14 as manager and employees 11, 13, and 162 have employee 3 as manager. The above helps to understand that employee 112 has no manager above her/him, and she/he is the top manager for all employees. The PATHLENGTH Function (DAX) returns the number of levels in a given PATH(), starting at the current level until the oldest or topmost parent level. What would be the PATHLENGTH value for the third row below (values 3 and 14)? Employee Key Parent Employee Key 112 14 112 3 14 11 3 13 3 162 3 117 162 221 162 81 162 A. 2 B. 3 C. 4 D. 5

B. 3 Explanation The PATH expression reveals that the third row has a path of: 112|14|3, which of course means the path has a depth of 3, or a PATHLENGTH of 3.

You're creating a fancy little dashboard using Power BI Service. The dashboard shows the accumulative increase in the global population over the last several decades. The dashboard will contain an introductory YouTube video that you have uploaded to the YouTube website. After uploading the video you copy the embedded HTML code and paste it into your dashboard. Unfortunately the video is fixed to 560 pixels wide and you would like it to expand to fit the tile size. What should you do? ​ A. Remove the allowfullscreen parameter from the code ​ B. Change the iFrame width and height attribute values to 100% ​ C. Add an extra outer DIV with a style width:auto and height:auto value ​ D. Videos are fixed size and can't expand to fit tiles

B. Change the iFrame width and height attribute values to 100%

Which of the following strategies are recommended when designing the queries to import data from an OLTP-style database into a Power BI Desktop project? (Select all that apply) ​ A. Normalizing the data model to make it better suited for data analysis and reporting. ​ B. Denormalizing the data model to make it better suited for data analysis and reporting. ​ C. Refactoring the imported tables into a multidimensional cube. ​ D. Refactoring the imported tables into a star schema.

B. Denormalizing the data model to make it better suited for data analysis and reporting. D. Refactoring the imported tables into a star schema. Explanation Denormalization and start schema is desired to transform the data in the format that is best fit for visualizations.

As part of a large BI project you have created a new dashboard for consumption by the HR team. After opening the Get Data menu option and selecting SQL Server, you are not sure which Data Connectivity mode to select. If you want the data to automatically refresh as you interact with visualizations which option should you choose? A. Import B. DirectQuery

B. DirectQuery Explanation DirectQuery - no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, which means you're always viewing current data.

Which of the following visuals is not included as part of Power BI and must be added as a custom visual? ​ A. Waterfall ​ B. Histogram ​ C. Doughnut ​ D. Stacked Area

B. Histogram Explanation Histogram is not added to Power BI by default, it need to be added as custom visual.

Which three options allow you to hide a field from the Report view in Power BI Desktop? A. In Power Bl Desktop Report view, right-click the field on the Fields list, and click Delete. B. In Power Bl Desktop Data view, right-click the column header on the respective table, and click Hide in Report View. C. In Power Bl Desktop Relationships view, right-click the field on the respective table, and click Hide in Report View. D. In Power Bl Desktop Report view, right-click the field on the Fields list, and click Hide.

B. In Power Bl Desktop Data view, right-click the column header on the respective table, and click Hide in Report View. C. In Power Bl Desktop Relationships view, right-click the field on the respective table, and click Hide in Report View. D. In Power Bl Desktop Report view, right-click the field on the Fields list, and click Hide. Explanation If you delete a field from the Fields list, the field will be permanently deleted from the Power Bl desktop instead of just being hidden from the users.

What is the use of "Select Related Table" option while importing data from SQL Server? ​ A. It will import the tables that have similar schema. ​ B. It will import tables that have physical relationship with selected table. ​ C. It won't import any extra table or view. ​ D. It will also import views related to selected tables.

B. It will import tables that have physical relationship with selected table. (Correct) Explanation Select related tables will import all other tables that have relation with this table.

What is the purpose of the new Selection pane in the report designer in Power BI Desktop? A. It's used to control the tab order between visuals on a page. B. It's used to hide and show visuals on a page before recording a bookmark C. It's used to combine two or more visuals on a page into a visual group. D. It's used to select data in a visual for highlighting and drill down.

B. It's used to hide and show visuals on a page before recording a bookmark Explanation Selection pane is a story telling features as combined with bookmarks. With selection page you can hide and show visuals and with bookmark you can save the current state of the page.

Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number? ​ A. Click on ellipses on Right Top Corner of visual -> Sort by - MonthNumber ​ B. Modeling -> Select Month Column -> Sort By - MonthNumber ​ C. Right Click on field in report view and select sort by, then select MonthNumber

B. Modeling -> Select Month Column -> Sort By - MonthNumber

Imagine you have created a query named Customers in a Power BI Desktop to append the rows from three external tables with customer data into a single output table named Customers. What would be the best approach to add a new fabricated ID column to the Customers table to ensure that every row in the Customers table contains a unique ID value? A. Modify the Customers query by adding a Counter column B. Modify the Customers query by adding an Index column C. Modify the data model by extending the Customers table with a Counter column D. Modify the data model by extending the Customers table with an Index column

B. Modify the Customers query by adding an Index column Explanation Index column option is available in query editor to add indexed column starting from 0, 1 or custom number.

By default, which filter level behaves the same as a slicer in a report in Power BI Desktop? ​ A. Visual level filter ​ B. Page level filter ​ C. Report level filter ​ D. Query level filter

B. Page level filter Explanation When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.

What can you accomplish with data gateway? A. Report Publish B. Refresh Data C. Download Report D. View Report

B. Refresh Data Explanation Gateway is used to refresh the data from source to online power bi service.

Reports are often confused with dashboards since they too are canvases filled with visualizations. But there are some major differences. Which one allows you to filter, highlight, and slice, and also see data set tables and fields and values? A. Dashboard B. Report

B. Report Explanation With a dashboard you can NOT see underlying dataset tables and fields but can export data but can't see tables and fields in the dashboard itself. Also you can't filter or slice

What are the types of row context? (Select all that apply) ​ A. Function Context ​ B. Row Context ​ C. Filter Context

B. Row Context ​ C. Filter Context

When connecting to an Access database, which entities are shown in the Navigator window? A. Users from the Access data base B. Tables from the Access database. C. Rows in from Access database D. Columns from the Access database

B. Tables from the Access database. Explanation When you connect to Access database, you will see list of tables that you can import in your Power BI Desktop as queries.

What happens to the data types of Query Editor that are not available in data model while loading data? ​ A. Tables with not supported types will throw an error. ​ B. These types will be converted to related data types. ​ C. Data with these types will not load into data model.

B. These types will be converted to related data types. (Correct)

What is true about using variables in DAX? ​ A. Maximum of 5 variables can be created per formula. ​ B. Variables are created only one time in the current context ​ C. Variables must be defined inside return

B. Variables are created only one time in the current context

Some of the most powerful data analysis solutions in Power BI Desktop can be created by using measures. Measures help us by performing calculations on our data as we interact with our reports. Understanding aggregations is fundamental to understanding measures, because every measure will perform some type of aggregation. Which of the below is TRUE regarding measures in Power BI? (Select all that apply) ​ A. IF(OR((([HireDate]-[TermDate])*-1) >= 61,ISBLANK([TermDate])),0,1) ​ B. You can reference another measure in a DAX expression by just typing an opening bracket "[" ​ C. Every time you interact with your report, you are changing the context in which a measure calculates and displays its results ​ D. You can create a new measure by clicking on the New Measure button in the ribbon on Power BI Desktop's Home tab

B. You can reference another measure in a DAX expression by just typing an opening bracket "[" D. You can create a new measure by clicking on the New Measure button in the ribbon on Power BI Desktop's Home tab

What do you need to append to the URL of a Power BI dashboard in order to open it with the navigation pane collapsed by default? ​ A. ?navigationPane=false ​ B. ?navigationPane=collapsed ​ C. ?collapseNavigation=true ​ D. ?collapseNavigation=collapsed

C. ?collapseNavigation=true Explanation When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the Power BI Dashboard with the navigation pane collapsed.

Which of the following Power BI report settings can be customized using a report theme? (Select all that apply) ​ A. The report background color ​ B. The report background image ​ C. A sequence of custom colors which are used by the visuals in the report ​ D. The default properties for new visuals that are added to the report

C. A sequence of custom colors which are used by the visuals in the report ​ D. The default properties for new visuals that are added to the report Explanation Sequence of colors can be set from Custom theme. Default properties of new visual, if visual is already created and properties are set then theme will not effect that.

Which of the following are advantages that Power BI dashboards have over Power BI reports? (Select all that apply) ​ A. Dashboards support using the Natural Language Q&A features of Power BI. ​ B. Dashboards provide a better interactive filtering and drilldown experience. ​ C. Dashboards update automatically whenever the data in the underlying dataset is updated. ​ D. Dashboard provide support for data-driven alerts.

C. Dashboards update automatically whenever the data in the underlying dataset is updated. ​ D. Dashboard provide support for data-driven alerts. Explanation First option is not correct because dashboard and report both offer Q&A functionality. Second option is also not correct because dashboards are not interactive. Only a case of interaction is if you pin a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other tiles.

The management requested two Power BI reports to be produced: one that shows all historical data, including transactions that happened in the past 10 minutes, and another report that tracks sales targets versus actual figures for the past 12 months. Based on background information and business requirements, answer the following questions: Which data connectivity mode should you use for each report? A. DirectQuery for both B. Import data for both C. DirectQuery for the historical data report, Import data for the sales targets report D. DirectQuery for the sales targets report, Import data for the historical data report

C. DirectQuery for the historical data report, Import data for the sales targets report Explanation Historical data need to be latest data to minute, so direct query is the best choice because users want to see latest data all the time. Sales data shows month figures as compared to last 12 months. Sales report is prepared every month, so it's better to import data for sales and schedule refresh for this.

Which feature of query editor splits a query into parts? ​ A. Split Query ​ B. Format Query ​ C. Extract Previous

C. Extract Previous Explanation IF you right click any applied step to query and select extract previous, Power Bi will create another query with all the steps applied before selected step and reference this query to new query.

What is the purpose of TRIM function? ​ A. It trims a specific character from string. ​ B. It will remove white space from a string. ​ C. It will remove white space from start and end of a string.

C. It will remove white space from start and end of a string. (Correct) Explanation Trim function only removed whitespace from start and end of a string.

What is the file format used to define a theme for a Power BI report? ​ A. Cascading Style Sheets (CCS) ​ B. Extensible Markup Language (XML) ​ C. JavaScript Object Notation (JSON) ​ D. Power BI Markup Language (PBIML)

C. JavaScript Object Notation (JSON) Explanation Power BI color theme is created in JSON format.

Which data category setting is used to geographically map column values to United States cities when the column contains values in city, state format such as Dallas, TX and Tampa, FL? ​ A. State Or Province ​ B. City ​ C. Place ​ D. Address

C. Place

You want to import data from Microsoft Access database to Power BI desktop but there is an error appearing on the screen. "The 'Microsoft.ACE.OLEDN.12.0' provider is not registered on the local machine". What is the reason for this error? A. Database name is wrong. B. Access database is password protected. C. Provider is not installed in the system. D. Privacy is set t o access database.

C. Provider is not installed in the system.

You have four queries named Query 1, Query 2, Query 3, and Query 4 in the Power BI desktop. You are creating Query 5, which will be appended at the end of Query 3. When you load the data, which queries will be refreshed? ​ A. Query 1 to Query 4 ​ B. Query 1 to Query 5 ​ C. Query 3 and Query 5 ​ D. Only Query 5

C. Query 3 and Query 5 Explanation Query 5 is new query so it should be refreshed. Query 5 is appended to query 3 so there is change in query 3 that should be refreshed in data model also.

Which view shows the graphical representation of data tables structure in query editor? ​ A. Manage Data-source ​ B. Advance Editor ​ C. Query Dependency

C. Query Dependency (Correct) Explanation Query dependency shows the structure and heirarchy of tables in graphical format

Power BI tries to translate transformations into the data source's native language where possible. What is this step called? ​ A. Native Query View ​ B. Query Dependency ​ C. Query folding

C. Query folding

Which command in the Power BI Desktop query editor is used to create a new query that uses the output of another query as its input source? A. Duplicate B. Pipe C. Reference D. Map

C. Reference Explanation When you create a reference to another query, there is only one step in applied steps in which new query is referencing to another query and initially it's same like parent query.

Which of the following platforms are R visuals supported? (Select all that apply) A. Power Bl Portal B. Publish to Web C. Reports hosted on Power Bl Embedded(V2) D. Power Bl Mobile APP(for reports hosted on app.powerbi.com) E. Power Bl Desktop F. Power Bl Report Server

C. Reports hosted on Power Bl Embedded(V2) E. Power Bl Desktop F. Power Bl Report Server Explanation R Visuals are not supported on Publish to Web or Power Bl report Server.

Which feature is used to create alternative name for fields in tables. It will make it much easier for users to ask questions on dashboards? ​ A. Duplicate Name ​ B. Alternative ​ C. Synonyms

C. Synonyms

You create a line chart that shows Quantity by Month. You notice that month values are sorted alphabetically. How can you rectify this? Your solution should involve minimal effort. A. Use the ellipsis menu in the visual to change the sort order. B. Create a new column that has a month number in front of month name. C. Use the Sort by Column feature and sort Month by Calendar Month Number. D. Create a measure for each month and place them in the right order.

C. Use the Sort by Column feature and sort Month by Calendar Month Number. Explanation The answer is Use sort by column option. When you sort Month by Calendar Month Number, the month names will appear in the right order in any visual where you use the Month column. The ellipsis menu discussed in answer A only allows you to change the sort order from ascending to descending or sort by Quantity instead of Month. The approach described in answer B may put month names in the right order, but it requires more effort and will add unnecessary clutter. Creating a measure for each month, like in answer D, will not solve the problem, because using multiple measures is like using a legend-you will see multiple dots instead of a sequence of values.

When using Live Connection, what type of transformations can be applied to data? A. Transpose B. Add Custom Column C. Unpivot Columns D. None of them

D. None of them

To create a DAX formula that automatically calculates the previous month number, for example if the month is June then formula should return 5. Today Month = MONTH (Sales[Todays Date]) Which of the following DAX formulas returns correct result? ​ A. Previous Month= Sales[Today Month]- 1 B. Previous Month= PREVIOUSMONTH(Sales[Today Month]) C. Previous Month= STARTOFMONTH(Sales[Today Month])- 1 D. Previous Month= IF (Sales[Today Month] =1, 12,Sales[Today Month]- 1)

D. Previous Month= IF (Sales[Today Month] =1, 12,Sales[Today Month]• 1) Explanation: You would need to use an IF DAX function to check if it was December, then simply subtract one from the current month number. The first DAX formula above already returned the month number so it's simply a case of subtracting one. Note, PREVIOUSMONTH is incorrect because it returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context.

Data has been scraped from a table on a popular retirement website. However, the Health care quality column's scores were not automatically transformed from text to numbers when Query Editor loaded the table. You thus right-clicked the column header, and selected Change Type > Whole Number to change them. Unfortunately, the Health care quality column contains a few times in states' rankings, which was noted on the website by the word (tie) after their numbers. Query Editor thus reports a few errors. What is the consequence of using the Remove Errors option (ribbon or the right-click menu option) to resolve this? A. Removes the applied step that has errors B. Removes the error warnings but keeps all data C. Change the errors values to blank D. Removes any rows with errors

D. Removes any rows with errors Explanation: The Remove Errors (using the ribbon or the right-click menu) removes any rows that have errors.

You have loaded data from a database table which contains a list of filenames that have been processed by an internal team. One particular column called filename contains the name of each file processed e.g. example.abc123.xml Which Transform function will dissect the filename values into two separate columns, one for the filename and the other for the file extension e.g. XML ​ A. Extract - Text before delimiter ​ B. Split Column - Split at Each occurrence of the delimiter ​ C. Extract - Text after delimiter ​ D. Split Column - Split at Right-most delimiter

D. Split Column - Split at Right-most delimiter Explanation By using the Split Column you can split each value into two separate columns, using the right most delimiter option to preserve the entire filename that could potentially contain additional full stops (periods).

Consider the following custom column formula: = if [Country] = "USA" then "United States" else [Country] Which of the following statements describes the value of the custom column formula? ​ A. The value will be "USA". ​ B. The value will be "United States". ​ C. The value will be the same as the Country column. ​ D. The value will either be "United States" or whatever the value of the Country column is.

D. The value will either be "United States" or whatever the value of the Country column is. Explanation The formula will assign the value "United States" to the custom column whenever the value of the Country column is equals to "USA"", otherwise it will assign the value of the Country column.

Client provides you with SQL Server Analysis Service database connectivity with Multidimensional database structure. To import data use Get Data -> SQL Server Analysis Service and data will be imported to Power BI. Is this statement correct ? ​ TRUE ​ FALSE

FALSE Explanation Analysis Service Multidimentional database is not yet supported in Power BI.

The DAX FORMAT function converts a value to text according to the specified format provided as the second argument to the function. Which of the following DAX expression formats the number to display 20.00%? A. FORMAT( 0.2, "Percent" ) B. FORMAT( 0.2, ''p") C. FORMAT( 0.2, "%") D. FORMAT( 2 0 , "Percent")

FORMAT( 0.2, "Percent" ) Explanation The format strings supported as an argument to the DAX FORMAT function are based on the format strings used by Visual Basic (OLE Automation), not on the format strings used by the .NET Framework. Therefore, you might get unexpected results or an error i f the argument does not match any defined format strings. For example, "p" as an abbreviatio n for "Percent" is not supported.

Your company wants you to prepare a dashboard that shows the reports from 10 years of sales data. These reports will be used by company directors to see the monthly sales performance. You need to get data of 10 years from SQL server database. Is DirectQuery the best option to use in this scenario? Yes No

No Explanation No, Because 10 years data might be huge and getting that data through direct query will be very slow and users won't be able to use reports properly. You should use Import Data to make your dashboards load faster.

A large corporate project requires the data team to create a number of different Power BI reports for the company's internet sales data. You need to create a measure that estimates the variance of the SalesAmount_USD column from your InternetSales_USD table, for the entire population. The mathematical formula for this calculation should follow the agreed standard: ∑(x - x̃)²/n Which DAX formula should you use? ​ VAR.P ​ VAR.S

VAR.P Explanation VAR.P assumes that the column refers the entire population. If your data represents a sample of the population, then compute the variance by using VAR.S.

Is Q&A, Cortana and External Sharing is disabled for Power BI Reports that use Row Level Security (RLS)? ​ TRUE ​ FALSE

TRUE Explanation Q&A and Cortana are not supported with RLS at this time. You will not see the Q&A input box for dashboards if all models have RLS configured.

When writing the DAX expression for a calculated column, you can assume your DAX code automatically has row context for the table in which the calculated column is defined. Is this statement TRUE ? ​ TRUE ​ FALSE

TRUE Explanation True, because calculated table values are different for everyrow. Calculated table has row context, that's why values are different for every row.

Power BI doesn't have an R engine built into it, you need to have an installation of R on your machine in order to generate/use R visuals. Is this statement TRUE ? ​ TRUE ​ FALSE

TRUE ​ Explanation Power BI Desktop does not include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install R on your local computer.

When you share a dashboard with tiles that link to reports, those reports are also shared at the same time. But what if you want to share just a report? Just send the report page URL to your colleagues. As long as they have Power BI Pro licenses, are members of the same distribution group, in the same email domain as you, or have at least one dashboard that links to that same report (the dashboard has tiles that were pinned from that report), they'll be able to open the report. You want to share a report that is pre-filtered on the Store Territory with a value of NC. What should you add to the end of the report URL before you share it? ​ A. ?filter=Store/Territory eq NC ​ B. ?filter=Store/Territory = NC ​ C. ?filter=Store[Territory] eq NC ​ D. ?filter=Store/Territory == NC

A. ?filter=Store/Territory eq NC Explanation The correct format is: ?filter=tablename/fieldname eq value. The field must be of type string and neither the tablename or fieldname can contain spaces.

Which two of the following happen when you personalize a content pack? ​ A. A copy of a content pack where you can make changes is created. ​ B. The published version of the content pack is updated. ​ C. The published version of the content pack is disconnected from the personalized content pack. ​ D. The published version of the content pack is customized.

A. A copy of a content pack where you can make changes is created. ​ C. The published version of the content pack is disconnected from the personalized content pack. ​ Explanation When you personalize a content pack, a copy of the content pack is created and the personalized content pack is disconnected from the published version of the content pack. You can then make changes to the personalized content pack.

When designing a data model in Power BI Desktop, which of the following statements are true regarding the rules for creating table relationships?(Select All that Apply) ​ A. A relationship between two tables must be defined using a single field from each table. ​ B. A relationship between two tables can be defined using multiple fields from each table. ​ C. At least one column defined in a table relationship must contain unique values. ​ D. You can define multiple relationships between two tables in a data model but only one of the relationships can be marked as active.

A. A relationship between two tables must be defined using a single field from each table. ​ D. You can define multiple relationships between two tables in a data model but only one of the relationships can be marked as active. Explanation It's not allowed in Power BI to create relation with multiple fields. There can be only 1 active field in both tables. In case of 2 fields, 2 columns must be combined in order to join these tables.

When you make a copy of a page in your report by using Duplicate Page, which visualizations from the page are duplicated? ​ A. All visualizations ​ B. Only the selected visualizations ​ C. Only visualizations that have filter relationship ​ D. All visualizations, except the static images

A. All visualizations Explanation Duplicate Page is the easiest way to make a copy of a page and all its visualizations.

Which of the following Azure Active Directory (AAD) security principals can be used to configure the membership of an app workspace? ​ A. An Azure AD user account ​ B. An Azure AD security group ​ C. An Azure AD mail-enabled security group ​ D. An Office 365 group in an Azure Active Directory tenant

A. An Azure AD user account

Which of the following Azure Active Directory (AAD) security principals can be used to configure the membership of a security role created using the Row-Level Security (RLS) features supported by the Power BI service? ​ A. An Azure AD user account ​ B. An Azure AD security group ​ C. An Azure AD mail-enabled security group ​ D. An Office 365 group in an Azure Active Directory tenant

A. An Azure AD user account ​ B. An Azure AD security group ​ C. An Azure AD mail-enabled security group

Which three data sources allow you to use direct connection? ​ A. Azure SQL Database ​ B. Azure SQL Data Warehouse ​ C. Microsoft Access ​ D. SQL Server Analysis Services

A. Azure SQL Database ​ B. Azure SQL Data Warehouse ​ D. SQL Server Analysis Services Explanation Microsoft Access do not support Direct Connection.

What is true about VALUES and DISTINCT functions? ​ A. Both functions return distinct rows. ​ B. Values function return all rows but distinct function returns unique values ​ C. Values function receives only physical table and Distinct can also work with table expression ​ D. Distinct function receives only physical table and Values can also work with table expression

A. Both functions return distinct rows. ​ C. Values function receives only physical table and Distinct can also work with table expression

What are manage roles tasks that you can perform in Power BI desktop ? ​ A. Create ​ B. Rename ​ C. Delete

A. Create ​ B. Rename ​ C. Delete Explanation All of them are correct

Which of the following are advantages associated with moving an app workspace into a Premium capacity that has been created using a Power BI Premium P1 subscription? ​ A. Dashboards within the app workspace can be shared with users who have the Power BI Free license. ​ B. The app published from the app workspace can be installed and consumed by users who have the Power BI Free license. ​ C. Users who have the Power BI Free license can directly access the app workspace for read-only access to its content. ​ D. Reports and dashboards in the app workspace can be embedded by developers in custom applications and served to non-licensed users.

A. Dashboards within the app workspace can be shared with users who have the Power BI Free license. ​ B. The app published from the app workspace can be installed and consumed by users who have the Power BI Free license. ​ D. Reports and dashboards in the app workspace can be embedded by developers in custom applications and served to non-licensed users. Explanation Dashboards can be shared with the users who have free license, but they can't be added to workspace.

Which of the following are features in the file menu within the Power BI service when in edit mode of a report? (Select All that Apply) ​ A. Download Report ​ B. Share With users ​ C. Embed in SharePoint Online ​ D. Publish to Web ​ E. Print ​ F. Export to PowerPoint ​ G. Save/Save As

A. Download Report ​ C. Embed in SharePoint Online ​ D. Publish to Web ​ E. Print ​ F. Export to PowerPoint ​ G. Save/Save As Explanation All except share with users.

Which of the following will help to optimize a Power Bi Data Model for Quick Insights? ​ A. Ensure that your data model is rich enough - i.e it contains at least one dimension and one measure ​ B. Avoid use of calculated tables ​ C. Avoid use of certain DAX functions ​ D. Hide columns from your dataset which you don't want to be included in the analysis ​ E. Use a mix of data types such as names, times, dates and numbers ​ F. Avoid (or hide) columns with duplicate information

A. Ensure that your data model is rich enough - i.e it contains at least one dimension and one measure ​ D. Hide columns from your dataset which you don't want to be included in the analysis ​ E. Use a mix of data types such as names, times, dates and numbers ​ F. Avoid (or hide) columns with duplicate information

Which page view types are available in Power BI Report View? ​ A. Fit to page ​ B. Full Screen ​ C. Fit to Width ​ D. Actual Size

A. Fit to page ​ C. Fit to Width ​ D. Actual Size Explanation Full Screen is not a page view in Power BI.

What is meant by Dynamic Row Level Security (RLS)? ​ A. Making use of the user logged in to Power BI (using USERNAME or USERPRINCIPALNAME DAX functions) to filter data under RLS ​ B. Using the logged in user's team (from Exchange/Active Directory) to determine their permissions rather than roles setup in Power BI ​ C. Membership of roles in Power BI desktop varies according to logic predefined by the report author ​ D. Varying the data permissions e.g. according to time of day that user is logged into

A. Making use of the user logged in to Power BI (using USERNAME or USERPRINCIPALNAME DAX functions) to filter data under RLS Explanation Dynamic Row Level Security involves using the login of the currently logged user to drive RLS permissions.

Which of the following field types can be added to the Field well of a Slicer visual? ​ A. Native columns returned by a query. ​ B. Calculated columns created using a DAX expression. ​ C. Measures created using a DAX expression. ​ D. Groups created inside a table using the "New Group" command in Power BI Desktop.

A. Native columns returned by a query. ​ B. Calculated columns created using a DAX expression. ​ D. Groups created inside a table using the "New Group" command in Power BI Desktop. Explanation Measures are not allowed to be used in slicer.

Which of the following Power BI subscriptions provides licensing which allows user to view Power BI content through the Power BI mobile apps? ​ A. Power BI Free (user license) ​ B. Power BI Pro (user license) ​ C. Power BI Premium EM3 (capacity license) ​ D. Power BI Premium P1 (capacity license)

A. Power BI Free (user license) ​ B. Power BI Pro (user license) ​ D. Power BI Premium P1 (capacity license) Explanation IF you buy Power BI embedded, then you can only embed report in Websites or apps but you cannot share it with users who have free license.

What is the difference between Power BI service and Power BI Server ? ​ A. Power BI service is online cloud based and Power BI server is on-premise local system. Report will be installed in local server that can be accessed inside that network only. ​ B. Power BI server reports can be synced with Power BI Service. ​ C. Power BI Report is managed by Microsoft and Power BI server is managed by Company's IT Team.

A. Power BI service is online cloud based and Power BI server is on-premise local system. Report will be installed in local server that can be accessed inside that network only. ​ C. Power BI Report is managed by Microsoft and Power BI server is managed by Company's IT Team.

Query B is appended to query A. Which query will be loaded to data model when user click Close & Apply? ​ A. Query A ​ B. Query B ​ C. Both Queries D. None of them

A. Query A (Correct) ​ Explanation Query A will be loaded because when we append query B to query A, Query B will remain same but Query A will also have query B data. It means Query A is changed because it has more data now and that data should be loaded to data model.

What are the limitations of publishing a report to website? ​ A. R visuals are not supported ​ B. Custom visuals are not supported ​ C. Row level security won't work. ​ D. Reports that connect live to on-premises Analysis Services Tabular are not supported

A. R visuals are not supported ​ C. Row level security won't work. ​ D. Reports that connect live to on-premises Analysis Services Tabular are not supported

Which three transformations are available when you right-click a column header in the Query Editor window? ​ A. Remove ​ B. Change Type ​ C. Duplicate Column ​ D. Count Rows

A. Remove ​ B. Change Type ​ C. Duplicate Column Explanation Count Rows is not an option when you right click on column.

In Power BI Desktop Report view, which three options will create a measure in the Sales table? ​ A. Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon. ​ B. Create the measure from any table, and then set the Home Table properties to Sales. ​ C. On the Fields list, click the ellipsis next to the Sales table or right-click any field in the Sales table, and then click New Measure. ​ D. Click New Measure, and then type in the formula Home Table = Sales.

A. Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon. ​ B. Create the measure from any table, and then set the Home Table properties to Sales. ​ C. On the Fields list, click the ellipsis next to the Sales table or right-click any field in the Sales table, and then click New Measure. Explanation Option one and three allow you to create a measure directly in the Sales table. Option two allows you to create a measure in any table, and then move it to the Sales table.

Which four options modify the Z order of a visualization? ​ A. Send to Back ​ B. Bring to Front ​ C. Bring Forward ​ D. Set Transparent ​ E. Send Backward

A. Send to Back ​ B. Bring to Front ​ C. Bring Forward E. Send Backward Explanation You can modify the Z order of a visualization by using "Send to Back", "Bring to Front", "Bring Forward", and "Send Backward".

What happens when you upload an Excel workbook that has a Power View report to Power BI? ​ A. The Excel Power View report will be converted to a Power BI report. ​ B. The Excel Power View report will not be imported to Power BI. ​ C. The Excel Power View report will have the data model imported, but you need to create the visualizations manually. ​ D. The Excel Power View report will be imported as Power BI Dashboard.

A. The Excel Power View report will be converted to a Power BI report. ​ Explanation When you upload an Excel workbook that contains a Power View report to Power BI service, the Power View report will be converted to a Power BI report automatically.

What are the requirements for a computer running the On-premises data gateway? (Select All that Apply) ​ A. The computer requires a 64-bit version of Windows ​ B. The computer must run a server-side operating systems such as Windows Server 2016 or Windows Server 2012 R2. ​ C. The computer must be joined to an Active Directory domain. ​ D. The computer cannot be a domain controller.

A. The computer requires a 64-bit version of Windows ​ D. The computer cannot be a domain controller. Explanation Computer or server must be running 64 bit windows. Must be windows 7 or latest. If computer is domain controller, then Power BI won't install in that machine.

When you share a dashboard with people outside your organization, they get an email with a link to the shared dashboard, and they need a Power BI Pro license to access the dashboard. After they sign in, they see the shared dashboard in its own browser window without the left navigation pane, not in their usual Power BI portal. They have to bookmark the link to access this dashboard in the future. Which of the following statements is FALSE when sharing dashboard outside of your organization? ​ A. They can change any slicers available on the reports connected to the dashboard and save their changes ​ B. They can't edit any content in this dashboard or report ​ C. Only your direct recipients can see the shared dashboard. For example, if you sent the email to [email protected], only Vicki can see the dashboard ​ D. People outside your organization can't see any data if row-level security is implemented on on-premises Analysis Services tabular models

A. They can change any slicers available on the reports connected to the dashboard and save their changes Explanation Although users can filter and slice your report, they cannot save any changes.

Which three properties of a tile can be edited in the Power BI dashboard from the Tile details window? (Select all that apply) ​ A. Title ​ B. Subtitle ​ C. Destination link ​ D. Color scheme

A. Title ​ B. Subtitle ​ C. Destination link Explanation You cannot modify the color scheme of a tile from the Tile details window.

Which transformation option converts rows to columns and columns to rows? ​ A. Transpose ​ B. Pivot Column ​ C. Unpivot Columns ​ D. Unpivot Other Columns

A. Transpose Explanation As the name suggests, the Transpose option transposes (converts) rows as columns and columns as rows.

Which two functions are used to get username of current user? ​ A. USERNAME ​ B. USEREMAILADDRESS ​ C. USERPRINCIPALNAME

A. USERNAME ​ C. USERPRINCIPALNAME Explanation USEREMAILADDRESS is not a function of Power BI.

What could be the reason of error "This content isn't available. Learn more about Power BI" in Power BI? (Select all that apply) ​ A. User don't have access to report. ​ B. User don't have Power BI pro license. ​ C. SharePoint server is down for maintenance ​ D. Power Bi report was deleted after embedding.

A. User don't have access to report. ​ B. User don't have Power BI pro license. ​ D. Power Bi report was deleted after embedding.

Which of the following versions of the Windows operating system support installing Power BI Desktop? (Select all that apply) ​ A. Windows 10 ​ B. Windows 8.1 ​ C. Windows 7 ​ D. Windows Vista

A. Windows 10 ​ B. Windows 8.1 ​ C. Windows 7 Explanation Windows Vista is not supported by Power BI Desktop.

Having created a new blank model you want to load in data from SQL Server database which is hosted on the same PC as the Power BI Desktop application. You click the Get Date ribbon option and select SQL Server from the drop down list. What should be entered in Server text box in the dialog box appeared for database connectivity? ​ A. localhost ​ B. local ​ C. host ​ D. [blank]

A. localhost Explanation If SQL server database is on the same PC, then SQL Server name can be used as Localhost or IP Address.

You add the Calendar Year column to a table visual and see only one row, as shown in Figure 2-94. Which of the following options solve the problem? More than one answer can be correct. A. Right-click on Calendar Year in the Values field well and select Don't summarize. B. Set the data type of the column to Text. C. Set the default summarization to Don't Summarize. D. Add the Calendar Year field to the Rows field well of a matrix visual.

Any of the answers will solve the problem.

Which of the following is a requirement for a user with a Power BI Pro license to share a dashboard with users who have the Power BI Free license? ​ A. The dashboard must be created in a workspace that is running within the Shared capacity. ​ B .The dashboard must be created in a workspace that is running within a Premium capacity. ​ C. This is a trick question - A user with a Pro license can never share content with users who have the Free license. ​ D. Nothing is required - A user with a Pro license can always share content with users who have the Free license.

B .The dashboard must be created in a workspace that is running within a Premium capacity. Explanation Without premium capacity, dashboard cannot be shared with the users who have free license.

What is the difference between "Choose Columns" and "Go to column" features? ​ A. Both provide same functionality but with different name. ​ B. "Choose columns" removes deselected column, "Go to Column" helps to navigate to specific column in large dataset. ​ C. "Choose Columns" helps to select a column. "Go to Column" removes deselected columns.

B. "Choose columns" removes deselected column, "Go to Column" helps to navigate to specific column in large dataset. Explanation 2nd option is correct.

The DAX FORMAT function accepts a number of different strings format, some of which can be constructed to create a custom formatter for your exact needs. Study the DAX expression below and choose the right result: FORMAT(-5, "$#,##0.00;($#,##0.00)") ​ A. $5.00 ​ B. ($5.00) ​ C. ($500.00) ​ D. $5,000.00

B. ($5.00)

What is the difference between COUNT and COUNTA? ​ A. COUNT counts distinct rows and COUNTA counts all rows. ​ B. COUNT counts non-blank values but COUNTA counts all values including blanks. ​ C. Both are same but different names

B. COUNT counts non-blank values but COUNTA counts all values including blanks.

When designing a query in Power BI Desktop to clean up data, what operation can be used to remove non-printable characters? ​ A. Trim ​ B. Clean ​ C. Sanitize ​ D. Scrub

B. Clean Explanation Clean function removes Non-Printable characters where TRIM removed whitespace.

Which of the following is not a valid privacy level for a Power BI data source? ​ A. Public ​ B. Confidential ​ C. Private ​ D. Organizational

B. Confidential

What do you need to do to create many-to-many relationship between 2 tables? A. Join multiple columns of these tables. B. Create a bridge table that contains unique values C. No need to do anything. Create relation as normal.

B. Create a bridge table that contains unique values Explanation You need to create bridge table to create many to many relationship.

Which of the following is not a valid type when programming in the M language? ​ A. List ​ B. Dataframe ​ C. Function ​ D. Record

B. Dataframe Explanation Dataframe is not a valid type of M Language.

Which three options can be added as a group member? ​ A. Computer Name ​ B. Email addresses ​ C. Security groups ​ D. Distribution Lists

B. Email addresses ​ C. Security groups ​ D. Distribution Lists Explanation You can add email addresses, security groups, and distribution lists as a group member in Power BI.

If you multiply a column that has some values as string, number values are multiplied properly but what is the result of string values? ​ A. String will be repeat number of times. ​ B. Error ​ C. Blank Value

B. Error Explanation It will create error because strings can't be multiplied by number.

When writing the DAX expression for a measure, you can assume your DAX code automatically has row context for the table in which the measure is defined. Is this statement TRUE ? ​ A. True ​ B. False

B. False Explanation Measures use to have filter context.

From which two options can you customize your report page layout? (Select all that apply) ​ A. From the Report ribbon, New Page option ​ B. From the Report ribbon, Page View option ​ C. From the Visualizations, Format option ​ D. From the Visualizations, Field option

B. From the Report ribbon, Page View option ​ C. From the Visualizations, Format option ​ Explanation You can change your report page layout by setting the Page Size option in the Report ribbon, or by clicking in the report canvas and customizing the Format on the Visualizations.

How can you make sure that each category manager can see sales of their category only and CEO to see all sales in the same report? Your solution must involve minimal effort. ​ A. Create one report for each category manager, with a different category filter in each report, and a separate report for the CEO. ​ B. Implement Dynamic row-level security ​ C. Create a category slicer in the report.

B. Implement Dynamic row-level security Explanation The answer is B. Creating separate reports for each manager will duplicate the reports and make it difficult to maintain them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a separate role to view everything.

Which of the following visualization types support configuring dashboard alerts? (Select all that apply) A. Card B. KPI C. Gauge D. Waterfall

B. KPI C. Gauge Explanation Waterfall charts doesn't allow to configure alerts.

Auto-filter is helpful to hide or show rows but rows that are hidden will be loaded to data model. Is this statement correct ? ​ A. Yes ​ B. No

B. No Explanation No, When user apply Autofilter, a step is created in Applied Steps pane and filtered data won't be loaded into data model.

Which of the following DAX expressions are valid and can be used for table filters when configuring row-level security (RLS). ​ A. [State]="WA" OR [State]="OR" OR [State]="CA" ​ B. OR([State]="WA", OR([State]="OR", [State]="CA")) ​ C. [State]="WA" || [State]="OR" || [State]="CA" ​ D. [State] IN {"WA", "OR", "CA"}

B. OR([State]="WA", OR([State]="OR", [State]="CA")) ​ C. [State]="WA" || [State]="OR" || [State]="CA" ​ D. [State] IN {"WA", "OR", "CA"}

Which two options are available while giving access to a content pack? ​ A. Power BI User ​ B. Power BI Group ​ C. Entire Organizations ​ D. External Organizations

B. Power BI Group ​ C. Entire Organizations Explanation You can share content packs to either Power BI group or the entire organizations.

Which of the following types of real-time dataset in Power BI always store their data in Azure SQL Database? (Select all that apply) ​ A. Streaming Datasets ​ B. Push Datasets ​ C. Hybrid Datasets

B. Push Datasets ​ C. Hybrid Datasets Explanation Streaming dataset don't store data in Azure SQL database.

What is the effect of disabling load of a query ? ​ A. Query won't be used anymore. ​ B. Query will not load in data model but other queries that reference to this query will be loaded with complete data. ​ C. Query will load in data model but user cannot use it in visualization.

B. Query will not load in data model but other queries that reference to this query will be loaded with complete data.

Which three views are available in Power BI Desktop? A. Dashboard B. Report C. Data D. Relationship

B. Report C. Data D. Relationship Explanation Dashboards are not available in Power BI Desktop. It is a feature of Power BI Service.

Which of the following features are supported when distributing Power BI content using an organizational content pack but not yet supported by the new Power BI App model? ​ A. The ability to make a dashboard accessible through the Power BI native mobile applications for iOS and Android. ​ B. The ability of a report consumer to copy a report and then edit the report copy to make personalized changes. ​ C. The ability to publish a subset of the dashboards, reports and datasets that have been added to an app workspace. ​ D. The ability to share reports with users that have the Power BI Free license.

B. The ability of a report consumer to copy a report and then edit the report copy to make personalized changes. (Correct)

By default, where clicking on a tile in Power BI dashboard takes you? ​ A. To the latest opened report ​ B. To the report where the visual was pinned from ​ C. To the report that has the same data source ​ D. To the Power BI home page

B. To the report where the visual was pinned from Explanation By default, clicking a tile on a Power BI dashboard will take you to the report where the visual was pinned from.

Which option can be used to reverse the sort order of rows in Query Editor? ​ A. There is no option like that. ​ B. Transform > Table > Reverse Rows ​ C. Autofilter ​ D. Sort Descending

B. Transform > Table > Reverse Rows

Which shapes are available in Power BI Desktop Report View? ​ A. Flowchart ​ B. Triangle ​ C. Rectangle ​ D. Oval

B. Triangle ​ C. Rectangle ​ D. Oval Explanation Flowchart is not an option in Power BI Desktop's shapes.

Which of the following statements is FALSE with respect to writing DAX expressions that reference calculated columns and measures? ​ A. When referencing a calculated column in a DAX expression, you must include the table name. ​ B. When referencing a measure in a DAX expression, you must include the table name. ​ C. When referencing a measure in a DAX expression, you can optionally include the table name. ​ D. When referencing a measure in a DAX expression, you should prefer not to include the table name.

B. When referencing a measure in a DAX expression, you must include the table name. ​ Explanation It is not recommended to user Table name with measure. Because measures are not dependent to be called with table name.

Which of the following statements are true with respect to designing a Power BI Desktop project in DirectQuery mode? ​ A. All queries within the project must be from a single source database. B. You cannot convert column data types when editing a query. C. You cannot add calculated columns to the data model. D. You cannot add measures to the data model.

B. You cannot convert column data types when editing a query. Explanation Measure and calculated columns are not supported in direct query mode. Using multiple data sources is allowed now in Power BI.

UNION function in DAX works similar to which function in Query Editor? ​ A. JOIN ​ B. DUPLICATE ​ C. APPEND ​ D. MERGE

C. APPEND

Which DAX function removes filters from a table? ​ A. Remove ​ B. Except ​ C. All ​ D. AllExcept

C. All

When using the "Split Column by Delimiter" transformation, which option may result in more than two new columns? ​ A. At the left-most delimiter ​ B. At the right-most delimiter ​ C. At each occurrence of the delimiter. ​ D. None of the above

C. At each occurrence of the delimiter. Explanation By using "At each occurrence of the delimiter" number of columns will depend on number of times a delimiter is used in text.

Which of the following DAX functions does not return a table? ​ A. Filter ​ B. AllExcept ​ C. Calculate ​ D. Values

C. Calculate ​ Explanation Calculate table doesn't return any table. It's only used for Columns and measures.

Which of the following actions can you take to get advantage of Power BI Premium? ​ A. Modify the Premium Enabled setting of a report or dashboard. ​ B. Modify the Premium Enabled setting of a dataset. ​ C. Configure one or more app workspaces to run within the scope of a Premium capacity. ​ D. Configure one or more app workspaces to run within the scope of a Shared capacity.

C. Configure one or more app workspaces to run within the scope of a Premium capacity. Explanation If you configure a workspace by using premium capacity then you can configure multiple apps to run in the same workspace. You can also share it with users who have free license.

Which one is not a time intelligence function? ​ A. DATESYTD ​ B. DATEMTD ​ C. DATEDTD ​ D. DATEQTD

C. DATEDTD

What do you need to do to prepare an Excel workbook before uploading it to Power BI? ​ A. Format all numeric data with two decimal points. ​ B. Ensure that the data is following the star schema. ​ C. Format the data as an Excel table. ​ D. Name the Excel worksheet appropriately.

C. Format the data as an Excel table. ​ Explanation Before you upload data in Excel to Power BI, you need to format the data as an Excel table.

You need to append Query B to query A. But there is one extra column in query B. What should you do ? ​ A. Delete extra column in Query B. ​ B. Create column with same name in Query A. ​ C. No need to do anything. Appending query will create that column where null will be the value for all the rows that are from query A.

C. No need to do anything. Appending query will create that column where null will be the value for all the rows that are from query A.

You publish a report from Power BI Desktop to Power BI service. You then make changes to your local report in Power BI Desktop by adding some visualizations. When do these changes synchronize to Power BI service? ​ A. On saving the Power BI Desktop file ​ B. On clicking REFRESH NOW in Power BI service ​ C. On Re-publishing the Power BI Desktop report ​ D. On scheduling refresh is run on Power BI service

C. On Re-publishing the Power BI Desktop report Explanation If you make changes to your local Power BI Desktop file, you will need to re-publish the file in order to view your changes in the Power BI service.

You need to filter out totals from target figures. Which function does that? ​ A. Table.Filter ​ B. CALCULATETABLE ​ C. Table.SelectRows D. Table.FilterRows

C. Table.SelectRows Explanation Table.FilterRows is the function of M Language to filter rows.

What happens when you connect to an Excel workbook that is hosted at OneDrive for Business from Power BI? ​ A. The Excel workbook will be uploaded to Power BI. ​ B. The Excel data model will be uploaded to Power BI. ​ C. The Excel Report will be created in Power BI. ​ D. The Excel Power View report will be converted to a Power BI report.

C. The Excel Report will be created in Power BI. Explanation When you connect an Excel workbook hosted at OneDrive for Business from Power BI service, Power BI will create an Excel report from the Excel workbook.

A business user reports that Q&A does not work on a certain dashboard. Which of the following is NOT a possible reason for this? ​ A. Q&A is disabled for this dashboard. ​ B. The only data source uses DirectQuery. ​ C. There is a custom visual in one of the tiles. ​ D. Row-level security is enabled for all datasets used in the dashboard.

C. There is a custom visual in one of the tiles. Explanation The answer is C. Custom visuals do not interfere with the Q&A feature. On the otherhand, Q&A box might disappear if it is disabled, the data source uses DirectQuery, orthere is row-level security configured.

What is the purpose of Power BI Personal Gateway? ​ A. To enable publishing reports to Power BI service. ​ B. To provide a platform for easily consuming and sharing reports. ​ C. To provide quick and secure data transfer between Power BI service and on-premises data sources that support refresh. ​ D. To connect and shape data, build robust models, and author well-structured reports.

C. To provide quick and secure data transfer between Power BI service and on-premises data sources that support refresh. Explanation Power BI Personal Gateway provide quick and secure data transfer between Power BI service and on-premises data sources that support refresh.

Which programming language is used in creating custom visuals? ​ A. C# ​ B. Java ​ C. TypeScript. ​ D. Python

C. TypeScript. Explanation You can add email addresses, security groups, and distribution lists as a group member in Power BI.

The CEO wants to share the environmental report created in Power BI with external users. The report does not contain any sensitive data. How can this be achieved? Your solution must involve minimal effort. ​ A. Invite the external users in Adventure Works Active Directory. ​ B. Add the external users into an app workspace. ​ C. Use Publish To Web feature.

C. Use Publish To Web feature. Explanation The answer is C. Because the users with whom the report should be shared with mightchange over time, it is best to publish the report to web. Adding external users to ActiveDirectory or an app workspace would involve extra costs.

Which of the following is true for creating a column from example? A. You can create column from the examples that you have defined already. B. It will list the examples defined by Power Bl and you can select anyone to create new column. C. When you type 1 or more values in a column, Power Bl analyzes if that value matches the data in other columns then it will fill remaining column values according to the matched criteria.

C. When you type 1 or more values in a column, Power Bl analyzes if that value matches the data in other columns then it will fill remaining column values according to the matched criteria. Explanation: You need to feed some data to let Power Bl Machine learning algorithm to understand and process data from existing columns.

You want to write a measure that calculates the ratio of a month of sales in a year. Which of the following function do you need to use? ​ A. FILTER ​ B. ENDOFYEAR ​ C. WHOLEYEAR ​ D. ALL

D. ALL Explanation The answer is D. With the ALL function, you can remove filter on month, allowing you tocalculate the desired ratio. Neither FILTER nor ENDOFYEAR are required for the formula,so options A and B are incorrect. Option C is wrong because there is no such function asWHOLEYEAR in DAX.

When can you update a published content pack? ​ A. After the content pack is unpublished ​ B. If no one has used the content pack ​ C. During refresh period of the content pack ​ D. Anytime after you make changes to the published content pack.

D. Anytime after you make changes to the published content pack. Explanation You can update a published content pack anytime after you made changes to it.

How does data refresh work when your data source is a CSV file stored on OneDrive(Business/Personal) ? ​ A. Refresh as configured on Enterprise gateway ​ B. Manually Triggered via Power BI Desktop ​ C. Refresh Schedule as per that configured on Power BI portal ​ D. Automatic Refresh (Approx Hourly) ​ E. Automatic Refresh (Approx every 15 min)

D. Automatic Refresh (Approx Hourly)

With DAX, there are many functions available to shape, form, or otherwise analyze your data. These functions can be grouped into a handful of categories including aggregation, counting, logical etc. The Union DAX command creates a union (join) table from a pair of tables but which statement below is FALSE about Union? ​ A. The two tables must have the same number of columns ​ B. The column names in the return table will match the column names in table_expression1 ​ C. Columns are combined by position in their respective tables ​ D. Duplicate rows are removed

D. Duplicate rows are removed Explanation Duplicate rows are NOT removed

Which of the following option modifies the interaction between visuals in a Power BI report? ​ A. Edit Queries ​ B. Arrange ​ C. Page Size ​ D. Edit Interactions

D. Edit Interactions Explanation You can modify the interactions flow by editing the visual interactions.

Which of the following statement best describes the use case for Power Bi embedded? ​ A. Embedding Power BI tiles/ reports onto dashboards which can be shared by others in your organization ​ B. Embedding Power BI tiles/ reports onto Power BI service for internal users ​ C. Embedding Power Bi tiles/ reports into e-mail messages ​ D. Embedding Power BI tiles/ reports into your company portal/external facing website customers/external users to access

D. Embedding Power BI tiles/ reports into your company portal/external facing website customers/external users to access

When designing a query in Power BI Desktop, what is the best data type to use for a column that contain currency values? ​ A. Whole Number ​ B. Money ​ C. Decimal number ​ D. Fixed decimal number

D. Fixed decimal number Explanation Fixed Decimal number format is best fit for currency columns.

Which visual shows the progress toward a particular target? ​ A. Bar chart ​ B. Scatter chart ​ C. Waterfall ​ D. Gauge

D. Gauge Explanation Gauges are a great choice to show progress toward a goal, represent a percentile measure, like a KPI, show the health of a single measure, or display information that can be quickly scanned and understood.

What is the function of Row Level Security in Power BI? ​ A. Assignment of security permissions on the underlying Power BI Azure SQL database ​ B. Ability to link Power BI log-in to your organizational Active Directory/Windows login via Single Sign on ​ C. Restriction to particular measures within Power BI reports to particular users ​ D. Restrict data access for given users (by assigning users to roles)

D. Restrict data access for given users (by assigning users to roles)

Which of the following is not an option for Default Summarization? ​ A. Sum ​ B. Average ​ C. Count ​ D. Standard deviation

D. Standard deviation Explanation The options for Default Summarization are Sum, Average, Minimum, Maximum, Count, and Count (Distinct).

When you connect to a model in SQL Server Analysis Service, what is shown in the Navigator window? ​ A. List of tables in the model ​ B. List of tables and columns in the model ​ C. List of tables, columns, and fields in the model ​ D. Summary showing the available dimensions and measures.

D. Summary showing the available dimensions and measures. Explanation When you connect to a SQL Server Analysis Service and explore the models in the Navigator window, instead of seeing all the tables available in the models, you are shown summaries of what dimensions and measures the models contain.

To which dashboard a visual created by the natural language query is pinned? ​ A. The last dashboard you visited ​ B. The last dashboard you created ​ C. A new dashboard will be created ​ D. The dashboard you selected in the Pin to dashboard window

D. The dashboard you selected in the Pin to dashboard window Explanation You can select the target dashboard in the Pin to dashboard window.

Assume you have just completed designing a report in Power BI Desktop in which you have imported a custom visual such as the Hierarchy Slicer. What are the extra steps required when publishing the PBIX file containing the Power BI Desktop report to an app workspace to ensure that your report can properly display the custom visual in the browser? ​ A. You must import the custom visual into the target workspace before publishing the Power BI Desktop project. ​ B. The tenant administrator must install the custom visual at tenant-level scope. ​ C. The tenant administrator must mark the custom visual as Safe within the current tenant using the GUID-based ID of the custom visual. ​ D. There are no extra steps because custom visual distribution is transparent once you have imported the custom visual into a Power BI Desktop project.

D. There are no extra steps because custom visual distribution is transparent once you have imported the custom visual into a Power BI Desktop project.

Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report. Is this statement correct? ​ TRUE ​ FALSE

FALSE Explanation False, Because you are allowed to create multiple bookmarks.

You need a Power BI Pro license to share your dashboard but those you share it with do not need a license. When you share a dashboard, they can view it and interact with it, but can't edit it. They see the same data that you see in the dashboard and reports unless row-level security (RLS) is applied to the underlying dataset. The colleagues you share it with can share the dashboard with their colleagues, if you allow them to. Is this statement true? ​ TRUE ​ FALSE

FALSE Explanation The first sentence is in fact FALSE. You need a Power BI Pro license to share your dashboard, and those you share it with do, too.

Moving a query into group increases the performance of the query. Is this statement correct? ​ Yes No

No Explanation Groups are just to organize queries.

You want to create a line chart showing Quantity by the invoice date. You notice that there is a relationship between the Date from the Date table and the Invoice Date Key from the Sale table, but the relationship is inactive. All other visuals in your report will be analyzing values by delivery date. How should you approach this problem? A. Create the following measure: Quantity by Invoice Date = CALCULATE ( SUM ( Sale[Quantity] ), USERELATIONSHIP ( 'Date'[Date], Sale[Invoice Date Key]) ) B. Delete the relationship based on the delivery date and activate the relationship based on the invoice date. C. Activate the relationship based on invoice ate, keeping the other relationship as is. D. Use the TREATAS function.

The answer is A. Because this is going to be a one-off visual, creating a measure that activates the relationship at query time solves the problem and involves the least effort. If you delete the relationship based on delivery date, as option B suggests, other visuals that use the Date table will display the wrong values. Following option C is not possible because no more than one relationship can be active at a time. Using TREATAS as per option D will result in the wrong figures.

How can you make sure that each category manager can see sales of their category only and allow the CEO to see all in a single report? Your solution must involve minimal effort. A. Create one report for each category manager with a different category filter in each report and a separate report for the CEO. B. Configure dynamic row-level security and a separate role for the CEO. C. Create a category slicer in the report

The answer is B. Creating separate reports for each manager will duplicate the reports and make it difficult to maintain them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a separate role to view everything.

After connecting to all the target Excel files, which of the following is going to transform data into a tabular shape that Power Bl works best with? A. Select first column, then click Pivot Column B. Select first column, then Unpivot Other Columns. C. Select first column, then Unpivot D. Transpose table

The answer is B. Option A requires a values column to be selected, and there is more than one-one for each product category. Option C will keep all the values columns in place. Option D will put customers on columns and product categories on rows. Option B will correctly transform the table into a table with three columns, which will contain Customer, Product Category, and Target values.

Is the following statement true? "The account you use for registering an app for embedding Power Bl content does not need a Power Bl Pro license allocated to it." A. Yes B. No

The answer is B. You need to have a Power Bl Pro user to register an app and embed Power Bl content with Power Bl Embedded.

The CEO wants to share the environmental report created in Power BI with external users. The report does not contain any sensitive data. How can this be achieved?.Your solution must involve minimal effort. A. Invite the external users in Adventure Works Active Directory. B. Add the external users into an app workspace. C. Use the Publish To Web feature.

The answer is C. Because the users with whom the report should be shared with might change over time, it is best to publish the report to web. Adding external users to Active Directory or an app workspace would involve extra costs.

A business user report s that Q&A does not work on a certain dashboard. Which of the following is NOT a possible reason for this? A. Q&A is disabled for this dashboard. B. The only data source uses DirectQuery. C. There is a custom visual in one of the tiles. D. Row-level security is enabled for all datasets used in the dashboard.

The answer is C. Custom visuals do not interfere with the Q&A feature. On the other hand, Q&A box might disappear if it is disabled, the data source uses DirectQuery , or there is row-level security configured.

The management requested two Power Bl reports to be produced one that shows all historical data, including transactions that happened in the past 10 minutes, and another report, that tracks sales targets versus actual figures or the past 12 months. Based on background information and business requirements, answer the following questions. Which data connectivity mode should you use for each report? A. Direct Query for both B. Import data for both C. DirectQuery for the historical data report, Import data for the sales targets report D. DirectQuery for the sales targets report, Import data for the historical data report

The answer is C. For the historical data report; you need to select the DirectQuery connectivity mode because the report needs to show the latest data, as well as all the available historical data, which is too large to fit into memory. Azure SQL Data Warehouse supports DirectQuery, and other data sources are not required, making DirectQuery a viable option. For the sales targets report, you need to combine actual data From Azure SQL Data Warehouse with Excel files. Furthermore, you will need to do transformations on Excel files, which leaves importing data as the only available option.

You create a line chart that shows Quantity by Month. You notice that month values are sorted alphabetically. How can you remedy this? Your solution should involve minimal effort. A. Use the ellipsis menu in the visual to change the sort order. B. Create a new column that has a month number in front of month name. C. Use the Sort by Column feature and sort Month by Calendar Month Number. D. Create a measure for each month and place them in the right order.

The answer is C. When you sort Month by Calendar Month Number, the month names will appear in the right order in any visual where you use the Month column. The ellipsis menu discussed in answer A only allows you to change the sort order from ascending to descending or sort by Quantity instead of Month. The approach described in answer B may put month names in the right order, but it requires more effort and will add unnecessary clutter. Creating a measure for each month, like in answer D, will not solve the problem, because using multiple measures is like using a legend-you will see multiple dots instead of a sequence of values.

A business user want s to distribute a set of reports with certain users. The reports were created in an app workspace. What is the best way to share t he reports? Your solution must involve minimal effort for all parties involved. A. Share each report with each user. B. Create a security group containing all necessary users and share reports with the security group. C. Invite all users in the app workspace with the reports. D. Create an app and install it automatically

The answer is D. Having an app installed automatically adds it to the Apps section of Power Bl service, which is an advantage compared to sharing the reports individually. Sharing reports with each user individually can take time and be error-prone because the user who shares will need to type all emails. A security group is preferred over typing email individually, because it can be maintained separately from Power Bl service but each report will still need to be shared individually. Inviting users to app workspaces should be done for collaboration purposes; it is not required when users need to only view reports.

After transforming the targets table, you have selected Fixed Decimal Number for the target figures column. Now there is one error in the column. Which of the following is NOT going to remove it in any way? A. Right-click on the header of the column and select Remove Errors B. Right-click on the header of the column, select Replace Errors, specify null C. Click Home> Remove Rows> Remove Errors. D. Click on the AutoFilter button of the column and de-select the error

The answer is D. When you have an error in a column, it is not possible to filter it out using AutoFilter because the error does not show in the results. All other options will work.

You want to write a measure that calculates the ratio of a month of sales in a year. Which one of the following functions will you need to use? A. FILTER B. ENDOFYEAR C. WHOLEYEAR D. ALL

The answer is D. With the ALL function, you can remove filter on month, allowing you to calculate the desired ratio. Neither FILTER nor ENDOFYEAR are required for the formula so options A and B are incorrect. Option C is wrong because there is no such function as WHOLEYEAR in DAX.

Duplicating a query increases the size of dataset and referencing a query doesn't increase. Is this statement correct ? ​ Yes No

Yes Explanation Yes, because duplicate query creates a new query with same steps applied but reference query creates a new query with only one step which reference to original query.

A dataset is available in Power BI service online. Would you be able to import data from Power BI Service online using Get Data --> Power BI dataset ? ​ Yes ​ No

Yes Explanation Yes, if you select this option it will show you all workspace you are member of. You can import dataset from any workspace.

In Query Editor, blank values are zero-length text string, while nulls are empty values. Is this statement correct ? ​ Yes ​ No

Yes ​ Explanation Yes

What is the file size limit to publish a .PBIX file to Power BI Service Free? A. 1 GB B. 3 GB C. 10 GB D. No Limit

1 GB

What are the types of values in query parameter?(Select All that Apply) ​ A. Any value ​ B. Dataset ​ C. List of Values ​ D. Query

A. Any value ​ C. List of Values ​ D. Query

Which types of datasets can be used to create a dashboard with streaming data tiles? ​ A. DirectQuery Datasets ​ B. Streaming Datasets ​ C. Push Datsets ​ D. Hybrid Datasets

B. Streaming Datasets ​ D. Hybrid Datasets

Select the feature that allows you to navigate through HTML tags to get the data from website? ​ A. Get JSON Data ​ B. Scaffolding ​ C. Web Scraping

C. Web Scraping Explanation Web Scraping is the new feature of Power bi that allows to navigate through HTML tags to get data from website.

In Query Editor, what will be the result if you combine a text string with null value? ​ A. Text String ​ B. Text String + null ​ C. null ​ D. Blank Value

C. null Explanation If you combine a text string it will result in Null value.

Many data modeling and data transformations are available when using DirectQuery, though with some limitations. Which of the following is NOT a limitation of using DirectQuery? ​ A. All tables must come from a single database ​ B. There is a 1 million row limit for returning data ​ C. Relationship filtering is limited to a single direction, rather than both directions ​ D. 1 GB dataset limitation

D. 1 GB dataset limitation Explanation With direct query, there no limitation of dataset because dataset is not imported in Power BI. Only schema of dataset is imported.

After you have pinned a report visual to create a dashboard tile, you can later modify the visual's properties and the Power BI service will automatically update the dashboard tile with the new visual property values. True False

False Explanation If you change anything after pinning the visual to dashboard. You need to delete the visual and add it again to see the change in the visual.

Say you and your teammates want to distribute your Power BI insights to your organization. The best way to do that is to create an app. An app is a collection of dashboards and reports built to deliver key metrics for your organization. To create an app, you need an app workspace, with your teammates as members. Think of the app workspace as a staging area where you and they can collaborate on your Power BI dashboards and reports. All of you can create reports in Power BI Desktop and publish those reports to the app workspace, and all of you need Power BI Pro licenses. If you just want to share a finished dashboard with colleagues should you add those colleagues to the app workspace? ​ Yes ​ No

No Explanation If you just want to share a finished dashboard with colleagues, don't add those colleagues to the app workspace. Instead, create the dashboard in an app workspace, and distribute the app to them.

The account you use for registering an app for embedding Power BI content doesn't need a Power BI Pro license allocated to it. Is this statement true? ​ Yes ​ No

No Explanation The answer is B. You need to have a Power BI Pro user to register an app and embedPower BI content with Power BI Embedded.

Do reports publish to Power BI server need to be built in a special edition of Power Bi Desktop? ​ TRUE ​ FALSE

TRUE

Business users ask your guidance on how they should configure automatic refresh. Which gateway installation mode is appropriate for Adventure Works? A. On-Premises Data Gateway. B. On-Premises Data Gateway (Personal Mode).

The Answer is A. Because users need to lock their laptops away each night, a personal gateway is not a good choice. Furthermore, because the users need to use the same data sources, installing gateways in personal mode is going to create extra work compared to installing a single data gateway.

How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created. A. Connect to the files with Folder connector and use the Combine Binaries functionality B. Connect to a new file each month, perform transformations, and use the Append function in Power Query Editor to combine all targets in the same table

The answer is A. The Folder connector performs transformations on files that have the same format automatically. You need to define the transformations only once; then you can only refresh data when new files are created. This option is much less laborious than connecting to each file individually and performing transformations every time.

You need to filter out totals from target figures. Which function does that? A. Table.Filter B. CALCULATETABLE C. Table.SelectRows D. Table.FilterRows

The answer is C. Options A and D do not exist. Option B is a DAX function.

You need to create a column chart that displays Quantity by Color and can bee drilled down to show Quantity by Stock Item. Which of the following solves the problem? More than one answer can be correct. A. Put Color and Stock Item on axis. B. Put Color on axis and Stock Item on legend. C. Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. D. Put Color on Axis and Stock Item on Tooltips.

The correct answers are A and C. With either option, you will be able to drill down in the hierarchy. Answer B is wrong because you cannot use the legend to drill down. If you follow the option D, you will not see stock item names in the visual.

All office 365 Global admins and Power Bi admins are automatically capacity admins of both Power Bi premium capacity and Power BI embedded capacity ​ True ​ False

True

Power BI comes with a range of visualizations to portray any data story you wish. There is one particular visual that's perfect to help users understand and analyze cash-flow during the ups and downs of all months in a financial year. Which visualization is this? ​ A. Waterfall chart ​ B. Treemap ​ C. Scatter chart ​ D. Stacked column chart

Waterfall chart Explanation A waterfall chart shows a running total as values are added or subtracted. It's useful for understanding how an initial value (for example, net income) is affected by a series of positive and negative changes.

You want to get population data from a website. To get population data: Select Get Data -> Web -> Paste Website Link -> Click connect in Anonymous tab Then in the navigation pane select table that you want to import to Power BI. Do these steps fulfill the requirement to import data from a website to Power BI ? Yes No

Yes