Practice test 1

1. When a selected visual is shown over the entire canvas, what is this feature called?
   1. Enhanced mode
   2. Expanded mode
   3. Focus mode
   4. Fullscreen mode
2. If a report has slicers and a clustered column chart with a trend line, how often will the trend line update?
   1. When data is refreshed
   2. When a new visual is added
   3. When a slicer or filter changes or when data is refreshed
   4. When a filter is applied
3. To understand the top key influencers of a specific amount, such as for the order quantity to be exactly 5, which analysis type would you need to use in the key influencers visual?
   1. Numeric
   2. Statistical
   3. Categorical
   4. Continuous
4. Power BI is used by:
   1. Only enterprise organizations
   2. Only university students
   3. A variety of enterprise and citizen developers
   4. Only cutting-edge developers
5. To sort records by a whole number-type column from lowest to highest, what operation do you need to use?
   1. Sort low to high
   2. Sort ascending
   3. Sort descending
   4. Sort alphabetical
6. What are the required parameters of the RANKX function?
   1. Table, expression
   2. Table, expression, order
   3. Value, order
   4. Table, order
7. To use responsive slicers, the slicer must contain:
   1. A date range
   2. A time range
   3. Relative dates
   4. A selection list of values
8. What four possible cardinalities does Power BI have?
   1. Many-to-one, one-to-many, many-to-some, and one-to-one
   2. Many-to-one, one-to-many, many-to-many, and one-to-one
   3. Many-to-one, one-to-many, many-to-many, and one-to-two
   4. Many-to-two, one-to-many, many-to-many, and one-to-one
9. Which visual is the most similar representation of tabular data to a database table?
   1. Stacked bar chart
   2. Clustered column chart
   3. Table visual
   4. Pie chart
10. Which page do you set drillthrough up on?
    1. The starting page
    2. The target page
    3. The Power BI admin portal
    4. The workspace settings
11. To implement row-level security, what needs to be applied to the table?
    1. M query
    2. WHERE clause
    3. DAX expression
    4. SQL query
12. What are the three stages supported by deployment pipelines?
    1. Training, test, and production
    2. Training, integration testing, and production
    3. Development, test, and production
    4. Development, UAT, and production
13. Using Power BI will be familiar for users of which service?
    1. Microsoft Word
    2. Adobe Photoshop
    3. Microsoft Edge
    4. Microsoft Excel
14. To bring data together from multiple queries where the structure is different but there are matching columns from both tables, we use:
    1. A left outer join query
    2. A right outer join query
    3. An append query
    4. A merge query
15. The three types of geographical map visuals are:
    1. Map, filled map, and GIS map
    2. Map, filled map, and ArcGIS map
    3. Map, colored map, and GIS map
    4. Google Maps, Apple Maps, and Bing Maps
16. To change the data type of a column in the Power Query Editor, what do you need to use?
    1. Type selector under the Files tab
    2. Data type selector under the Queries tab
    3. Type selector under the Data tab
    4. Data type selector under the Transform tab
17. Which option is a way to reduce the data size?
    1. Multiplication
    2. Aggregation
    3. Duplication
    4. Miniaturization
18. Why is it important to cleanse and transform data?
    1. Date representations in datasets might be different.
    2. Data types of the matching columns might be different in datasets you need to merge.
    3. Datasets you need to merge might require creating columns.
    4. All of the above.
19. If your data contains demographic data about customers and you want to understand buying habits for certain age ranges, what technique would you use to analyze your data?
    1. Merging
    2. Ranging
    3. Aging
    4. Binning
20. Power BI uses two engines. What are the names of these two engines?
    1. Calculation and storage
    2. Formula and persistence
    3. Formula and storage
    4. V8 and diesel
21. The auto date/time option in the data load options will do what?
    1. Automatically save the current date and time to your report.
    2. Automatically add dates to all tables loaded.
    3. Create a hidden date hierarchy table.
    4. Create a hidden timetable.
22. Visuals from published reports can be added to a dashboard with a process called:
    1. Glueing
    2. Pinning
    3. Copy and paste
    4. Sharing
23. What does DAX stand for?
    1. DatabAses for eXcel
    2. Data Advanced Expressions
    3. Data Analysis for "X"
    4. Data Analysis eXpressions
24. To view descriptive statistical information about each column of your data, which tool do you need to use?
    1. Column information under the Data tab
    2. Column statistics under the View tab
    3. Column profile under the View tab
    4. Column profile under the Data tab
25. By default, the Power Query Editor uses how many rows of data?
    1. All of the data
    2. The first 100 rows
    3. The first 500 rows
    4. The first 1,000 rows
26. Power BI content and datasets are published to what?
    1. A database
    2. A workspace
    3. An environment
    4. A workbench
27. Which sets of methods are valid ways the Power Query Editor can add columns?
    1. Column from Example, Custom Column, and Key Column
    2. Column from Example, Custom Column, and Index Column
    3. Column from Example, Invoke Custom Function, and IF/THEN Column
    4. Column from Example, Custom Column, and Column from Join
28. What methods can be used with AI to generate data using the Power Query Editor?
    1. Language detection, language translation, sentiment analysis, and image tagging
    2. Language detection, key phrase extraction, mind reading, and image tagging
    3. Language detection, key phrase extraction, sentiment analysis, and image tagging
    4. Language detection, key phrase extraction, sentiment analysis, and text to speech
29. Scheduled data refreshes take place within a time window you set in the service. What is the length of the time window?
    1. 5 minutes
    2. 10 minutes
    3. 15 minutes
    4. 30 minutes
30. Which data sources can Power BI can connect to?
    1. Databases
    2. Filesystems
    3. Software-as-a-service providers
    4. All of the above
31. Power BI is designed to work with:
    1. Many data sources
    2. Only one data source
    3. Only two data sources
    4. One or two data sources
32. Which is an example of a non-additive measure?
    1. Percent increase
    2. Unit price
    3. Sales amount
    4. Purchase order total
33. Direct query performance optimization often includes:
    1. Reducing the size of data in the data model and indexing data in the data model
    2. Indexes on the source data, dimension-to-fact table key integrity, materializing data and dates, and distributed tables for MPP databases
    3. Only considering distributed tables for MPP databases
    4. Indexing the source files in a search engine
34. The usage metrics report capability in Power BI includes pre-built reports with what information?
    1. Premium Per User and Per Capacity usage, report usage, report performance, and report list
    2. Premium Per User capacity usage, report usage, report performance, and report list
    3. Report usage, report performance, and report list
    4. Report usage and report performance
35. Which mode needs to be installed for multiple users to access on-premises data sources?
    1. Personal mode on-premises data gateway
    2. Multi-user mode on-premises data gateway
    3. Standard mode on-premises data gateway
    4. Enterprise mode on-premises data gateway
36. To change the colors used on a visual, which section do you need to change?
    1. Change your visual.
    2. Edit your visual.
    3. Format your visual.
    4. Color your visual.
37. What is the recommended tool for optimizing measures?
    1. Microsoft Edge
    2. Visual Studio Code
    3. DAX Studio
    4. Power Query Editor
38. Power BI supports what kind of visuals?
    1. Only built-in
    2. Only custom
    3. Built-in and open source
    4. Built-in and custom
39. It is often hard for businesses to do what?
    1. Know how much they will pay for Power BI.
    2. Use Power BI to understand their data.
    3. Pay their employees what they are worth.
    4. See a complete picture of what is happening across the enterprise.
40. When using sensitivity labels in Power BI, when does downstream inheritance happen?
    1. When downstream data becomes unusable
    2. When downstream data is made available for everyone to use
    3. When the same sensitivity labels are applied to downstream data products
    4. When the same sensitivity labels are applied to all data products
41. The filtering pane allows filtering by:
    1. Visual and page
    2. Visual, page, and all pages
    3. Visual, page, all pages, and reports
    4. Visual, page, all pages, and dashboards
42. To update data in a Power BI dataset, what capability must you use?
    1. Data reload
    2. Update dataset
    3. Update model
    4. Data refresh
43. What is the default canvas type for a report?
    1. 4:3
    2. 3:2
    3. 10:5
    4. 16:9
44. What are two common types of encoding used by Power BI to compress data?
    1. Value and distinct
    2. Value and hash
    3. Value and Snappy
    4. Snappy and ZIP
45. For advanced natural-language queries using domain-specific words, you may need to use what?
    1. The built-in, general-purpose linguistic model
    2. A custom linguistic model
    3. A custom theme
    4. A custom data model
46. When enabling column quality in Power Query Editor, what values are shown for each column?
    1. Number of valid, duplicate, and empty
    2. Percent of valid, duplicate, and empty
    3. Percent of valid, error, and empty
    4. Number of valid, error, and empty
47. What feature of Power BI reports allows you to capture the current state of a report page?
    1. Snapshot
    2. Favorites
    3. Bookmarks
    4. Freeze page
48. What does being "data-driven" mean?
    1. Using autonomous automobiles
    2. Business process improvement
    3. Using data to make business decisions
    4. Using the latest technology
49. What is Power BI?
    1. Software you download
    2. Software and a service
    3. Only a service
    4. Only a mobile app
50. DAX functions must return how many values?
    1. Two
    2. One or more
    3. One
    4. Minimum of one
51. When you create a report that allows end users to jump to a target page in your report that focuses on a selected data value, what feature are you using?
    1. Drillthrough
    2. Bookmarks
    3. Hyperlinks
    4. Favorites
52. What configuration should be changed to use a measure in a drillthrough?
    1. Cross-filter direction set to both.
    2. Cross-filter direction set from starting page to target page.
    3. Allow drillthrough when summarized.
    4. Allow drillthrough when used as a category.
53. What are the three layout options for the bookmark navigator?
    1. Grid, upright, and level
    2. Grid, vertical, and level
    3. Grid, upright, and horizontal
    4. Grid, vertical, and horizontal
54. Which transformation replaces empty or null values in a column with the value from the adjacent row, defined as either up or down methods?
    1. Fill
    2. Replace
    3. Generate
    4. Create data
55. The formula engine interacts with data stored where?
    1. It doesn't interact with data.
    2. The storage engine and directly with data sources.
    3. Directly with data sources.
    4. The storage engine.
56. Slicers can be used to remove data from a report visual:
    1. Permanently from Power BI
    2. Temporarily until the next refresh
    3. Only while selected in the slicer
    4. Permanently from the source
57. What does the "BI" in Power BI stand for?
    1. Business intelligence
    2. Better intelligence
    3. Business interactive
    4. Business information
58. XMLA is the protocol used by:
    1. Extensible Markup Analytics
    2. Microsoft Analytics Cloud
    3. Power BI Analytics Services
    4. Microsoft SQL Server Analysis Services
59. What Azure service is used for Bring Your Own Key (BYOK) encryption in Power BI?
    1. Azure Power BI Embedded
    2. Azure Private Link
    3. Azure ExpressRoute
    4. Azure Key Vault
60. When a calculated column is added to a query with 100 rows, how many values are added to the storage of the query?
    1. 0
    2. 100
    3. 50
    4. 25