70-778
Which of the following is not a valid type when programming in the M language? A. List B. Dataframe C. Function D. Record
B
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 ? A. Yes B. No
A
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
What is the difference between "Unpivot columns" and "Unpivot other columns" ? A. "Unpivot columns" will unpivot selected columns where "Unpivot other columns" will unpivot deselected columns. B. "Unpivot columns" will unpivot deselected columns where "Unpivot other columns" will unpivot selected columns. C. Both functions have similar effect.
A
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
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
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
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
What is the extension of a Power BI custom visual file downloaded from the Power BI visual's gallery? A. .pbix B. .pbivis C. .pbiv D. .pbiviz
D
Which of the following is not an option for Default Summarization? A. Sum B. Average C. Count D. Standard deviation
D
All office 365 Global admins and Power Bi admins are automatically capacity admins of both Power Bi premium capacity and Power BI embedded capacity A. True B. False
A
Custom functions in Query editor are useful when same transformation will be applied multiple times. Is this statement correct ? A. Yes B. No
A
Duplicating a query increases the size of dataset and referencing a query doesn't increase. Is this statement correct ? A. Yes B. No
A
In Query Editor, blank values are zero-length text string, while nulls are empty values. Is this statement correct ? A. Yes B. No
A
Is Q&A, Cortana and External Sharing is disabled for Power BI Reports that use Row Level Security (RLS)? A. TRUE B. FALSE
A
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
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? A. Yes B. No
A
Which of the following report page details are recorded when you create a bookmark? (Choose multiple) A. The sort order of rows in a Table visual B. The current selections 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, B, D
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
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 ? A. TRUE B. FALSE
A
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
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
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
Which transformation option converts rows to columns and columns to rows? A. Transpose B. Pivot Column C. Unpivot Columns D. Unpivot Other Columns
A
You created a Power BI report using Power BI desktop and uploaded the .pbix file to OneDrive for Business then you connected that file to Power BI Service Online. What happens when you update the .pbix file on OneDrive for Business? A. The corresponding report in Power BI service also gets updated automatically. B. The corresponding report in Power BI service needs to be refreshed manually. C. The corresponding report in Power BI service does not get updated. You need to reconnect to the file hosted at OneDrive for Business. D. The corresponding report in Power BI service gets deleted.
A
You have a list of salesmen, you want to merge queries to display list of salesmen who has sales records only. Which join kind should be used? A. Inner B. Full Outer C. Right Anti D. Left Anti
A
Which three data sources allow you to use direct connection? (Choose multiple) A. Azure SQL Database B. Azure SQL Data Warehouse C. Microsoft Access D. SQL Server Analysis Services
A, B, D
How to create a chart by "Asking Question" feature? (Choose multiple) A. Home -> Ask Question B. Double Click on Report View C. Modeling -> Ask Question
A, B
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? (Choose multiple 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, B, C
Which of the following versions of the Windows operating system support installing Power BI Desktop? (Choose multiple) A. Windows 10 B. Windows 8.1 C. Windows 7 D. Windows Vista
A, B, C
Which four options modify the Z order of a visualization? (Choose multiple) A. Send to Back B. Bring to Front C. Bring Forward D. Set Transparent E. Send Backward
A, B, C, E
What could be the reason of error "This content isn't available. Learn more about Power BI" in Power BI? (Choose multiple) 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, B, D
Which of the following Power BI subscriptions provides licensing which allows user to view Power BI content through the Power BI mobile apps? (Choose multiple) 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, B, D
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? (Choose multiple) 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, B, D
Which of the following field types can be added to the Field well of a Slicer visual? (Choose multiple) 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, B, D
What is true about VALUES and DISTINCT functions? (Choose multiple) 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, C
Which two functions are used to get username of current user? (Choose multiple) A. USERNAME B. USEREMAILADDRESS C. USERPRINCIPALNAME
A, C
What are the limitations of publishing a report to website? (Choose Multiple) 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, C, D
What are the types of values in query parameter? (Choose Multiple) A. Any value B. Dataset C. List of Values D. Query
A, C, D
When designing a data model in Power BI Desktop, which of the following statements are true regarding the rules for creating table relationships? (Choose multiple) 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, D
Which two privacy levels can be assigned to a user group? (Choose multiple) A. Public B. Internal C. External D. Private
A, D
Which of the following will help to optimize a Power Bi Data Model for Quick Insights? (Choose multiple) 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, D, E, F
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 ? A. True B. False
B
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
Q&A can be used against a Direct Query data source connected to Azure SQL Database. Is this statement TRUE ? A. TRUE B. FALSE
B
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
What is the difference between "Appending queries" and "Merging queries"? A. Nothing, Both are same but different names. B. Appending queries is combining queries vertically and merging queries is combining them horizontally. C. Appending queries is combining queries horizontally and merging queries is combining them vertically.
B
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
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
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
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
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
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
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
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
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? A. TRUE B. FALSE
B
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
Which of the following DAX expressions are valid and can be used for table filters when configuring row-level security (RLS). (Choose multiple) 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, C, D
Which three options can be added as a group member? (Choose multiple) A. Computer Name B. Email addresses C. Security groups D. Distribution Lists
B, C, D
Which types of datasets can be used to create a dashboard with streaming data tiles? (Choose multiple) A. DirectQuery Datasets B. Streaming Datasets C. Push Datsets D. Hybrid Datasets
B, D
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
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
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
UNION function in DAX works similar to which function in Query Editor? A. JOIN B. DUPLICATE C. APPEND D. MERGE
C
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
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
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
Which function can be used in inactive relationship? A. RELATED B. RELATEDRELATIONSHIP C. USERELATIONSHIP
C
Which is the primary programming language is used to develop a custom data connector for Power BI? A. C# B. JavaScript C. M D. R
C
Which of the following DAX functions does not return a table? A. Filter B. AllExcept C. Calculate D. Values
C
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
Which one is not a time intelligence function? A. DATESYTD B. DATEMTD C. DATEDTD D. DATEQTD
C
Which programming language is used in creating custom visuals? A. C# B. Java C. TypeScript. D. Python
C
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
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
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
From which two options can you customize your report page layout? (Choose multiple) 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
C, D
A business user wants to distribute a set of reports with certain users. The reports were created in an app workspace. What is the best way to share the 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.
D
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 deselect the error
D
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
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
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 steps 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
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
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
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
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
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
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
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
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
Which visual shows the progress toward a particular target? A. Bar chart B. Scatter chart C. Waterfall D. Gauge
D
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
You have a list of salesmen, you want to merge sales queries to display items sales by salesman. Some salesmen don't have any sales. Which join kind should be used? A. Inner B. Full Outer C. Right Outer D. Left Outer
D
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 delimeter B. Split Column - Split at each occurrence of the delimeter C. Extract - Text after delimeter D. Split Column - Split at right-most delimeter
D
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
Which two field options are available when creating a waterfall chart? (Choose multiple) A. Category B. X Axis C. Y Axis D. Size
A, C
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
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
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
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
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
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
A
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 ? A. True B. False
A
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(20, "Percent")
A
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([Registration Date], "MM yyyy") C. FORMAT([Registration Date], "mm yyyy") D. FORMAT([Registration Date], "M yyyy")
A
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 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
A
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 BI desktop file gets download D. The Power BI desktop file opens
A
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
A
When connecting to an Access database, which entities are shown in the Navigator window? A. Users B. Tables C. Rows D. Columns
B
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
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 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 invoice date C. Activate the relationship based on invoiced date, keeping the other relationship as is D. Use the TREATAS function
A
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 ? A. Yes B. No
A
Which of the following resources are automatically provisioned when you create a new app workspace in the Power BI Service? (Choose multiple) 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, C
Which of the following statements are true with regard to using the Slicer visual in a Power BI report? (Choose multiple) 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, C
What are the possible options to share a dashboard with other users? (Choose multiple) A. Click the ellipsis next to the dashboard name on the Dashboards list, and then click Share B. Click Share from the 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, B
Which views can be used in Power BI Desktop Data Model to create a new dimensional hierarchy? (Choose multiple) A. Report View B. Data View C. Relationships View
A, B
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? (Choose multiple) A. The formula creates a calculated column named UnitPrice B. The value of the calculated column is dependant 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, B, C
In Power BI Desktop Report view, which three options will create a measure in the Sales table? (Choose multiple) A. Select the Sales tables 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 an field in the sales table, then click new measure D. Click New Measure, and then type in the formula Home Table = Sales
A, B, C
Which of the following visualization types support configuring dashboard alerts? (Choose multiple) A. Card B. KPI C. Guage D. Waterfall
A, B, C
Which three properties of a tile can be edited in the Power BI dashboard from the Tile details window? (Choose Multiple) A. Tile B. Subtitle C. Destination link D. Color scheme
A, B, C
Which three transformations are available when you right-click a column header in the Query Editor window? (Choose multiple) A. Remove B. Change Type C. Duplicate Column D. Count Rows
A, B, C
Which of the following cardinalities are available in Power BI table relationships? (Choose multiple) A. Many to One B. One to One C. One to Many D. Many to Many
A, B, C, D
Which language can be used when designing a query in Power BI Desktop? (Choose multiple) A. M B. SQL C. Python D. MDX
A, B, D
Which of the following are advantages that Power BI reports have over Power BI dashboards? (Choose multiple) 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, B, D
Which of the following operations can be accomplished by a developer using the Power BI Service API (aka Power BI REST API)? (Choose multiple) 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, B, D
Why query parameters are used ? (Choose multiple A. Refine a dataset B. Add dynamic values C. Transform data D. Reduce the size of a dataset
A, B, D
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? (Choose multiple) A. Refreshing a dataset which imports its data 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 SharePoint Online
A, C
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? (Choose multiple) A. Put Color and Stock Item on axis B. Put Color and Stock Item on legen 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, C
What are the limitations of live connection? (Choose multiple) A. It is not possible to define a 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 BI license
A, C
Which two cross filter directions are available in Power BI table relationships? (Choose Multiple) A. Single B. Double C. Both D. Multiple
A, C
What are the advantages of installing Power BI Desktop from the Microsoft Store instead of installing it using the standard MSI download? (Choose multiple) A. Installation does not require admin privileges B. It provides PowerBI Desktop with greater access to content in Office 365 and Azure C. Monthly updates for PowerBI Desktop are automatically installed in the background when they're available. D. It lowers total cost of ownership for an org's IT dept. when distributing PowerBI Desktop to a large audience
A, C, D
What are the three reasons for which you might use calculated tables? (Choose multiple) 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, C, D
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? (Choose multiple) 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, C, D
Which page view types are available in Power BI Report View? (Choose multiple) A. Fit to page B. Full screen C. Fit to Width D. Actual Size
A, C, D
Which three fields are available when creating a Pie chart visualization? (Choose multiple) A. Legend B. Group C. Details D. Value
A, C, D
Which three statements describe the Applied Step's area in the Query Editor window? (Choose multiple) A. It records the list of steps from connecting to the data source to 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 datasorce C. The recorded list follows the sequence of steps applied to the datasource D. You can modify the connection to the data source by modifying the Source step settings
A, C, D
Which of the following platforms are R visuals supported? (Choose multiple) A. Power BI Portal B. Publish to Web C. Reports hosted on Power BI Embedded(V2) D. Power BI Mobile APP (for reports hosted on app.powerbi.com) E. Power BI Desktop F. Power BI Report Server
A, C, D, E
Which of the following statements are true with regard to designing Power BI content for mobile devices? (Choose multiple) 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 Dashboard designer provides Phone Layout View to design dashboards which target mobile devices D. The Power BI service dashboard designer provides Phone View in the browser to deisgn dashboards which target mobile devices
A, D
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
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
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
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 each CEO B. Implement Dynamic row-level security C. Create a category slicer in the report
B
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
Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number? A. Click on the ellipsis on the top-right corner of the visual -> Sort by -> MonthNumber B. Modelng -> Select Month Column -> Sort by -> MonthNumber C. Right-click on a field in report view and select sort by, then select MonthNumber
B
Moving a query into group increases the performance of the query. Is this statement correct? A. Yes B. No
B
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
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? A. Yes B. No
B
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
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? A. True B. False
B
What can you accomplish with data gateway? A. Report Publish B. Refresh Data C. Download Report D. View Report
B
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
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 the data model
B
What is the difference between "Choose Columns" and "Go to column" features? A. Both provide the same functionality but with a different name B. "Choose columns" removes deselected columns, "Go to column" helps to navigate to a specific column in a large dataset C. "Choose columns" helps to select a column, "Go to column" removes deselected columns
B
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
What is the use of "Select Related Table" option while importing data from SQL Server? A. It will import the tables that have similar schemas B. it will import tables that have physical relationships with the selected table C. It won't import any extra table or view D. It will also import views related to selected tables
B
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? A. Yes B. No
B
Which of the following types of real-time dataset in Power BI always store their data in Azure SQL Database? (Choose multiple) A. Streaming dataset B. Push dataset C. Hybrid dataset
B, C
Which shapes are available in Power BI Desktop Report View? (Choose multiple) A. Flowchart B. Triangle C. Rectangle D. Oval
B, C, D
Which three options allow you to hide a field from the Report view in Power BI Desktop? A. In Power BI Desktop Report view, right-click the field on the Fields list, and click Delete B. In Power BI Desktop Data view, right-click the column header on the respective table, and click Hide in Report View C. In Power BI Desktop Relationships view, right-click the field on the respective table, and Hide in Report View D. In Power BI Desktop Report View, right-click the field on the Fields list, and click Hide
B, C, D
Which three views are available in Power BI Desktop? (Choose multiple) A. Dashboard B. Report C. Data D. Relationships
B, C, D
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. (Choose multiple) Which of the below is TRUE regarding measures in Power BI? (Choose multiple) A. IF (OR (((([Hire Date] - [Term Date]) * -1) >= 61, ISBLANK([Term Date]])), 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, D
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? (Choose multiple) 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, D
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
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 Scaping
C
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 for the historical data report
C
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
What is the file format used to define a theme for a Power BI report? A. Cascading Style Sheets (CSS) B. Extensible Markup Language (XML) C. JavaScript Object Notation (JSON) D. Power BI Markup Language (PBIML)
C
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 the start and end of a string
C
When using the "Split Column by Delimiter" transformation, which option may result in more than two new columns? A. Left-most delimiter B. Right-most delimiter C. Each occurrence of the deilimter D. None of the above
C
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
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
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
Which feature of query editor splits a query into parts? A. Split Query B. Format Query C. Extract Previous
C
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 BI and you select anyone to create new column C. When you type 1 or more values in a column, Power BI analyzes if that value matches the data in other columns then it will fill remaining column values according to the matched criteria
C
Which view shows the graphical representation of data tables structure in query editor? A. Manage Datasource B. Advance Editor C. Query Dependency
C
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 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
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 and Query 4 B. Query 1 and Query 5 C. Query 3 and Query 5 D. Query 5
C
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". A. Database is named wrong B. Access database is password protection C. Provider is not installed in the system D. Privacy is set to access database
C
Which of the following Power BI report settings can be customized using a report theme? (Choose multiple) 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, D
Which of the following are advantages that Power BI dashboards have over Power BI reports? (Choose multiple) 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. Dashboards provide support for data-driven alerts
C, D
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
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