Microsoft Power BI 70-778 Certification Exam

Which of the following statements are true with regard to using the Slicer visual in a Power BI report? 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.

Which of the following resources are automatically provisioned whenever you create a new app workspace in the Power BI Service? a) A storage container for Power BI 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 BI resources including datasets, reports and dashboards c) An Office 365 Group which triggers the creation of a SharePoint team site*** ***As of Fall 2019 new app workspaces no longer automatically create an Office 365 group

The internal finance team needs a new dashboard creating to show projected revenue for the coming years so they can adequately plan for future budgets. All of the data for this dashboard will come from SQL Server 2005 that is running on the company's main SQL Server machine. The IT team has informed you that the SQL Server machine has many instances of SQL Server installed including 2005, 2008, 2012 and even 2016. If the server name was ACMESQL and the instance name provided by IT was SQL2005, what would you type into the Server name textbox when connecting through Power BI? a) ACMESQL\SQL2005 b) SQL2005\ACMESQL c) ACMESQL:SQL2005 d) ACMESQL(SQL2005)

a) ACMESQL\SQL2005 When connecting to an instance of the Database Engine you must specify the name of the instance of SQL Server. If the instance of SQL Server is the default instance (an unnamed instance), then specify the name of the computer where SQL Server is installed, or the IP address of the computer. If the instance of SQL Server is a named instance (such as SQLEXPRESS), then specify the name of the computer where SQL Server is installed, or the IP address of the computer, and add a slash and the instance name.

Which of the following visualization types supports configuring dashboard alerts? a) Card b) KPI c) Gauge d) Waterfall

a) Card b) KPI c) Gauge You can set alerts on tiles if you have a Power BI Pro license. You can also set alerts if someone shares a dashboard that's in a Premium capacity. Alerts can only be set on tiles pinned from report visuals, and only on gauges, KPIs, and cards.

Which of the following operations can be accomplished by a developer using the Power BI Service API (aka Power BI REST API)? 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

The DAX FORMAT function is used to convert a value to text according to the specified format that you provide as the second argument to the function. Which DAX expression below would format the number so that it's displayed as 20.00%? a) FORMAT( 0.2, "Percent" ) b) FORMAT( 0.2, "p" ) c) FORMAT( 0.2, "%" ) d) FORMAT( 20, "Percent" )

a) FORMAT( 0.2, "Percent" ) 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 if the argument does not match any defined format strings. For example, "p" as an abbreviation for "Percent" is not supported.

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" )

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? 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

a) IF(OR((([HireDate]-[TermDate])*-1) >= 61,ISBLANK([TermDate])),0,1)

What are the advantages of installing Power BI Desktop from the Microsoft Store instead of installing it using the standard MSI download? a) Installation does not require administrative privileges. b) It provides Power BI Desktop with greater access to content in Office 365 and Microsoft Azure. c) Monthly updates for Power BI 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 BI Desktop to a large audience.

a) Installation does not require administrative privileges. c) Monthly updates for Power BI 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 BI 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 BI 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 BI Desktop project

You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data. Which data source you should use? a) Microsoft Azure Data Lake Store b) Microsoft Azure Table Storage c) Microsoft Azure HD lnsight d) Microsoft Azure SQL Database

a) Microsoft Azure Data Lake Store

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 a 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? a) NO b) YES

a) NO 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.

If you want to combine data from multiple sources into a single model, for example, to join some data from a corporate SQL Server database with some local data maintained in an Excel file. Is DirectQuery a good choice for this scenario rather than Import? a) No b) Yes

a) No It's a bad choice because it is not possible when using DirectQuery. When selecting DirectQuery for a source, it is then only possible to use data from that single source (such as a single SQL Server database).

In the main Power BI Desktop window, which views can be used to create a new dimensional hierarchy? a) Report View b) Data View c) Relationships View

a) Report View b) Data View

Which type of Power BI visualisation is being described below?Always has two value axes to show one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. These data points may be distributed evenly or unevenly across the horizontal axis, depending on the data. a) Scatter chart b) Treemap c) Funnel chart d) None of these

a) Scatter chart

When you import multiple tables, chances are you're going to do some analysis using data from all those tables. Relationships between those tables are necessary in order to accurately calculate results and display the correct information in your reports.Imagine an example of a model that has a Sales actuals table with a lookup table for department and also a budget sales table that records target budget for each department. The department table is connected to both the sales and the budget table.Which kind of Cross Filter Direction would you use in this example? a) Single b) Both

a) Single Although both is the most common, this means for filtering purposes, both tables are treated as if they're a single table. This works well with a single table that has a number of lookup tables that surround it. An example is a Sales actuals table with a lookup table for department. This is often called a Star schema configuration (a central table with several Lookup tables.) However, if you have two or more tables that also have lookup tables (with some in common) then you wouldn't want to use the Both setting. To continue the previous example, in this case, you also have a budget sales table that records target budget for each department. And, the department table is connected to both the sales and the budget table. Avoid the Both setting for this kind of configuration.

A retail analysis dashboard contains a small collection of datasets including Sales, Items and Stores. You have dragged the Category field from the Item dataset onto the report canvas. You now want to give users the option to select one, many or all Categories to filter the visuals on the report.Which element should you pick from the visualizations pane? a) Slicer b) Multi-row card c) Funnel d) Card

a) Slicer The Slicer is an interaction selection tool that allows users to view an entire list of items and then select the items they want to include.

Which of the following statements are true with regard to designing Power BI content for mobile devices? a) The Power BI Desktop report designer provides Phone Layout View to design reports which target mobile devices. b) The Power BI Service report designer provides Phone Layout View in the browser to design reports which target mobile devices. c) The Power BI Desktop dashboard designer provides Phone view to design dashboards which target mobile devices. d) The Power BI service dashboard designer provides Phone view in the browser to design dashboards which target mobile devices.

a) The Power BI Desktop report designer provides Phone Layout View to design reports which target mobile devices. b) The Power BI Service report designer provides Phone Layout View in the browser to design reports which target mobile devices. d) The Power BI service dashboard designer provides Phone view in the browser to design dashboards which target mobile devices.

Which of the following report page details are recorded when you create a bookmark? 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 When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object

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? a) VAR.P b) VAR.S

a) VAR.P 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.

In which of the following scenarios does refreshing an imported dataset in the Power BI Service require either the an on-premises gateway or a personal gateway? a) When refreshing a dataset which imports its data from an on-premises SQL Server database. b) When refreshing a dataset which imports its data from an Azure SQL database. c) When refreshing an imported dataset which relies on an R input script as its source. d) When refreshing a dataset which imports its data from a list in SharePoint Online.

a) When refreshing a dataset which imports its data from an on-premises SQL Server database. c) When refreshing an imported dataset which relies on an R input script as its source. There are two different types of gateways, each for a different scenario: - On-premises data gateway allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources. - On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others. Personal Mode does not support DirectQuery or live connections to SSAS.

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? 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 DAX FORMAT function accepts a number of different format strings, 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) -$5.00 d) $5,000.00

b) ($5.00)

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 prefiltered 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 = NC b) ?filter=Store/Territory eq NC c) ?filter=Store/Territory == NC d) ?filter=Store[Territory] eq NC

b) ?filter=Store/Territory eq NC 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 type of visualisation would you choose if you wanted to show relationships between 3 numerical values and turn the horizontal axis into a logarithmic scale? The worksheet data would include grouped sets of values and you wanted to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers? a) Scatter chart b) Bubble chart c) Treemap d) Pie chart

b) Bubble chart Bubble charts are a good choice when your data has 3 data series that each contain a set of values. Particularly to present financial data when you want different bubble sizes to visually emphasize specific values. Bubble charts are also great for use with quadrants.

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 embed 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%

You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category. You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged. What should you do? a) Set a visual level filter on the bar chart. b) Edit the interactions form the Format menu. c) Set a visual level filter on the donut chart. d) Add a slicer to the page that uses the year column.

b) Edit the interactions form the Format menu.

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. a) TRUE b) FALSE

b) FALSE 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.

Using the new bookmarking features in the report designer in Power BI Desktop, you are limited to creating only one bookmark per page in a report. a) True b) False

b) False

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. a) True b) False

b) False For a pinned tile, if the original visualization used to create the tile changes, the tile doesn't change. For example, if the designer pinned a line chart from a report and then changed the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not. An entire report page can be pinned to a dashboard, which is called pinning a live tile. It's called a live tile because you can interact with the tile on the dashboard. Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard.

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. a) True b) False

b) False Two ways to grant access to reports published to SharePoint Online: 1. If you're using an Office 365 Group to build your SharePoint Online team site, list the user as a member of the workspace within the Power BI service and the SharePoint page. 2. Embed a report within an app and share it directly with users. The author, who must be a Pro user, creates a report in a workspace. To share with Power BI free users, the workspace needs to be set as a Premium workspace.

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) Donut d) Stacked Area

b) Histogram

As part of a large HR project you are working with a dataset of company employees, both past and present. The data includes columns for EthnicGroup, PayTypeID, HireDate (the date they started work), TermDate (the date they left) and several other columns. You want to create a new Calculated Column that determines if the person was a bad hire based on a set of rules. If they were a bad hire then the result is 1, otherwise the Calculated Column displays a zero. The bad hire rule is: BadHire = If the person stayed at the company less than 61 days Example: If a person joined the company on 27th June 2013 and left on 21st August 2013, then they would be a bad hire. Which DAX expression would you use for this Calculated Column? a) Slicer b) IF(OR((([HireDate]-[TermDate])) >= 61,ISBLANK([TermDate])),0,1) c) IF(((([HireDate]-[TermDate])*-1) < 61),1,0) d) IF((([TermDate]-[HireDate])*-1) >= 61,0,1)

b) IF(OR((([HireDate]-[TermDate])) >= 61,ISBLANK([TermDate])),0,1) For this expression you must use a combination of IF, OR and ISBLANK. If you forget to use ISBLANK then the difference between a date and a blank date is always 0, causing problems with the numeric comparison and potentially always showing BadHire as 1. Remember some employees won't have left the company and hence have no TermDate value.

Information Functions (DAX) look at a table or column provided as an argument to another function and tells you whether the value matches the expected type. What is the result of the following DAX expression? =IF(ISLOGICAL("true"), "Is Boolean type or Logical", "Is different type") a) Is Boolean type or Logical b) Is different type

b) Is different type ISLOGICIAL returns TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE. The value "true" is a text value and not a logical (boolean) value.

With Power BI Publish to web, you can easily embed interactive Power BI visualizations online, such as in blog posts, websites, through emails or social media, on any device.You have published a visualization but unfortunately changes to the underlying data are not immediately visible to users. What might be wrong? a) You must refresh the data manually after publishing to the web b) It takes up to an hour for data to refresh c) You cannot refresh data after publishing to the web, the visuals are static d) The user does not have the appropriate row level security permissions

b) It takes up to an hour for data to refresh

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 drilldown.

b) It's used to hide and show visuals on a page before recording a bookmark.

You want to create a DAX formula that automatically calculates the previous month number. So if the month was June then the formula would return 5. You have already created the DAX formula below: Today Month = MONTH (Sales[Todays Date]) Which of the DAX formulas below would be the right choice next? a) Previous Month = Sales[Today Month]-1 b) Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) c) Previous Month = PREVIOUSMONTH(Sales[Today Month]) d) Previous Month = STARTOFMONTH(Sales[Today Month])-1

b) Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) 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.

Which of the following types of real-time datasets in Power BI always store their data in an Azure SQL Database? a) Streaming Datasets b) Push Datasets c) Hybrid Datasets

b) Push Datasets c) Hybrid Datasets With a push dataset, data is pushed into the Power BI service. When the dataset is created, the Power BI service automatically creates a new database in the service to store the data. With a streaming dataset, data is also pushed into the Power BI service, with an important difference: Power BI only stores the data into a temporary cache, which quickly expires. The temporary cache is only used to display visuals which have some transient sense of history, such as a line chart that has a time window of one hour. The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data data source. Hybrid datasets send data to both the "push" and "streaming" endpoints, thereby getting the benefits of both at the expense of duplicate storage.

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 dataset tables and fields and values? a) Dashboard b) Report

b) Report 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

A CurrentSales dataset contains a large number of product codes for items that the company have sold in the last 12 months. Due to the nature of the business and the wide variety of suppliers, the product codes come in a variety of formats, including mixed case characters. You want to write a DAX expression that checks if the product code contains the letters "ex". Which DAX function below is the right one to use? a) FIND( "ex", [ProductCode] ) b) SEARCH( "ex", [ProductCode] )

b) SEARCH( "ex", [ProductCode] ) SEARCH returns the number of the character at which a specific character or text string is first found, reading left to right. Search is case-insensitive and accent sensitive, whilst FIND is case-sensitive.

As part of a large data project you want to create a dashboard using the Power BI Service. Data will come from a variety of different sources. Do you know which of the following sources would require a Power BI Enterprise Gateway? a) Spark on Azure HD Insight b) SQL Server Analysis Services (on-premise) c) Azure SQL Data Warehouse d) CSV file saved on OneDrive for Business

b) SQL Server Analysis Services (on-premise) For databases in the cloud, connections from Power BI to these databases are live, that is, when you've connected to say an Azure SQL Database, and you begin exploring its data by creating reports in Power BI, anytime you slice your data or add another field to a visualization, a query is made right to the database.For databases on-premises, a Power BI Enterprise Gateway is required.If you save your files on OneDrive for Business or SharePoint - Team Sites, and then connect to or import them into Power BI, your dataset, reports, and dashboard will always be up-to-date. Because both OneDrive and Power BI are in the cloud, Power BI can connect directly to your saved file, about once every hour, and check for updates.

When you share with people outside your organization, they get an email with a link to the shared dashboard. They need a Power BI Pro license, and they have to sign in to Power BI to see 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 visualizations outside of your organisation? a) They can't edit any content in this dashboard or report b) They can change any filters/slicers available on the reports connected to the dashboard and save their changes c) People outside your organization can't see any data if role- or row-level security is implemented on on-premises Analysis Services tabular models d) 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

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

Which of the following Power BI report settings can be customized using a report theme? 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

You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? a) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR

c) DATESYTD

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings? a) Subscriptions b) Dashboards c) Dataset d) Workbooks

c) Dataset

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)

You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and to publish the report to the report server. Which data source should the report use? a) Microsoft Azure SQL Database b) a Microsoft SQL Server database c) a Microsoft SQL Server Analysis Services (SSAS) database d) Microsoft Excel

c) a Microsoft SQL Server Analysis Services (SSAS) database

You have a Power BI report in an app workspace. You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded. Which information should you provide to the application developers? a) the application token and the report URL b) the report URL and a user name c) the app workspace name and the access key d) the access key and the report ID

c) the app workspace name and the access key

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source? a) Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode. b) Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode. c) Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode. d) Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

d) Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

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 regarding 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 Duplicate rows are NOT removed

You have an app workspace named Retail Store Analysis in the Power BI service. You need to manage the members that have access to the app workspace using the least amount of administrative effort. What should you do? a) From the Power BI Admin portal, click Usage metrics b) From the Office 365 Admin center, click Users c) From the Power BI Admin portal, click Tenant settings d) From the Office 365 Admin center, click Groups

d) From the Office 365 Admin center, click Groups

You can easily add a new custom column of data to your Power BI Desktop model. You can create and rename your custom column using easy buttons to create M formulas that define your custom column.How would you add a custom column? a) Home ribbon - Query Editor - Datasource Settings b) Home ribbon - External Data - Enter Data c) Home ribbon - Relationships - Manage Relationships d) Home ribbon - Query Editor - Edit Queries

d) Home ribbon - Query Editor - Edit Queries Once Query Editor is launched and you have some data loaded, you can add a custom column by selecting the Add Column tab on the ribbon, and then selecting Custom Column.

In the Power BI service, you create an app workplace that contains several dashboards. You need to provide a user named [email protected] with the ability to edit and publish dashboards What should you do? a) From the app workspace, click Update app, and then configure the Access settings. b) Share the dashboard, and then modify the Access settings of the dashboard. c) Configure security for the dataset used by the app. d) Modify the members of the app workspace.

d) Modify the members of the app workspace.

Power BI Desktop comes with a large collection of different data connections, allowing you to pull in data from a wide variety of sources. One particular category of data connection is Azure, Microsoft's cloud computing platform.Which of the following is NOT part of the Azure collection of data connections available in Power BI desktop? a) Blob Storage b) HDInsight c) Table Storage d) Redshift

d) Redshift Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It is owned by Amazon and is not part of Microsoft's Azure platform.

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 ties 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 intact c) Blanks the cell values which have errors d) Removes any rows with errors

d) Removes any rows with errors 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. energy.batch1453.xmlWhich Transform function would you use to 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 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).

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the visualization in the report can be consumed by users. Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution. a) funnel charts b) custom visuals c) bubble maps d) breadcrumbs e) R visuals

d) breadcrumbs e) R visuals

Having created a new blank model you want to load in data from a 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 you enter in the Server textbox? a) local b) [blank] c) host d) localhost

d) localhost On most computer systems, localhost resolves to the IP address 127.0.0.1, which is the most commonly used IPv4 loopback address. This will instruct Power BI to use the SQL Server on your machine.

When you enable Snap objects to grid, all visuals on the Power BI Desktop canvas that you move (or resize) are automatically aligned to the nearest grid axis, making it much easier to ensure two or more visuals align to the same horizontal or vertical location or size.You can also manage the overlap of each element on the design surface, often referred to as? a) Vertical stacking b) Stack-order c) a-order d) z-order

d) z-order You can manage the front-to-back order of visuals in a report, often referred to as the z-order of elements. This allows you to overlap visuals in any way you want, then adjust the front-to-back order of each visual.