Practice Set 1

Question 1

Data Import Methods

Q: In Power BI, how should you import 45 Excel files with the same structure from a folder into one table?

A. Use a Folder data source, then Combine Files

B. Manually append each file using Append Queries

C. Connect to each file individually and use Merge Queries

D. Use an Excel data source and select all files

Answer 1

Answer: A – Use a Folder data source, then Combine Files.

Key Point: One-click solution for many identical files.

Example: You have 45 monthly sales reports (Jan.xlsx, Feb.xlsx, etc.) all with columns: Date, Product, Amount. Folder source + Combine Files automatically stacks them into one table.

Why it works: Power BI applies the same transformation to all files automatically.

Question 2

Data Import Methods

Q: Why is the Combine Files command the most efficient approach for importing many same-structure Excel files?

A. It requires manual configuration for each file

B. It automatically applies transformations uniformly across all files

C. It only works with CSV files

D. It creates separate tables for each file

Answer 2

Answer: B – It automatically applies transformations uniformly across all files.

Key Point: Set it once, applies to all.

Example: If you rename a column or filter data in the first file, those same steps apply to all 45 files automatically.

Remember: “Combine Files = Consistency across files.”

Question 3

Data Import Methods

Q: What is the main drawback of using Append Queries to combine 45 Excel files?

A. It doesn’t work with Excel files

B. It combines files horizontally instead of vertically

C. It requires 45 separate append steps, which is time-consuming and error-prone

D. It cannot handle files with the same structure

Answer 3

Answer: C – It requires 45 separate append steps, which is time-consuming and error-prone.

Key Point: Manual work = mistakes + time waste.

Example: With Append Queries, you’d manually select File1, append File2, append File3… 45 times. Miss one file? Data’s incomplete.

Remember: “Append = Manual labor. Combine Files = Automation.”

Question 4

Power Platform Tools

Q: Which tool should you use to create a data model with multiple tables in Power Platform?

A. Power BI

B. Power Automate

C. Power Apps

D. Power Query

Answer 4

Answer: A – Power BI.

Key Point: Power BI = Data modeling + relationships.

Example: Connect Sales table to Customer table using CustomerID. Power BI creates the relationship and lets you analyze sales by customer demographics.

Remember: “Need tables with relationships? Use Power BI.”

Question 5

Power Platform Tools

Q: What is the primary purpose of Power Automate?

A. Creating data models with multiple tables

B. Building custom business applications

C. Creating automated workflows between different applications and services

D. Data transformation and cleaning (ETL)

Answer 5

Answer: C – Creating automated workflows between different applications and services.

Key Point: Power Automate = Task automation.

Example: When a file is added to SharePoint, automatically send an email notification and create a Planner task.

Remember: “Automate = Workflows, not data models.”

Question 6

Power Platform Tools

Q: What is Power Apps primarily used for?

A. Creating data models with relationships

B. Building custom business applications with a low-code platform

C. Data transformation and ETL processes

D. Automated workflows between systems

Answer 6

Answer: B – Building custom business applications with a low-code platform.

Key Point: Power Apps = Custom apps with UI.

Example: Build a mobile app where field technicians can submit work orders with photos, dropdowns, and signatures—no coding required.

Remember: “Apps = User interface, not data modeling.”

Question 7

Power Platform Tools

Q: What is the primary function of Power Query?

A. Creating complete data models with relationships

B. Building automated workflows

C. Data transformation and cleaning (ETL)

D. Creating custom business applications

Answer 7

Answer: C – Data transformation and cleaning (ETL).

Key Point: Power Query = Clean and transform data.

Example: Remove duplicates, split “Full Name” into “First” and “Last,” convert text dates to proper date format, filter out null values.

Remember: “Query = Clean the mess before modeling.”

Question 8

Q: What is the primary purpose of the Power BI Gateway?

A. To allow users to create custom visuals

B. To allow users to share reports with others

C. To allow users to connect to on-premises data sources

D. To allow users to create dashboards

Answer 8

Answer: C – To allow users to connect to on-premises data sources.

Key Point: Gateway = Bridge between on-premises and cloud.

Example: Your SQL Server database sits on a company server (not in the cloud). The Gateway lets Power BI service refresh data from that server automatically.

Remember: “Gateway = On-prem to cloud tunnel.”

Question 9

Power BI Gateway

Q: Can the Power BI Gateway be used to create custom visuals?

A. Yes, it’s the primary tool for creating custom visuals

B. No, custom visuals are created using Power BI itself, not the Gateway

C. Yes, but only for on-premises data

D. No, custom visuals require Power Apps

Answer 9

Answer: B – No, custom visuals are created using Power BI itself, not the Gateway.

Key Point: Gateway = Data connectivity only, not visualization.

Example: You create visuals in Power BI Desktop or Service. Gateway just refreshes the data behind those visuals.

Remember: “Gateway doesn’t touch visuals—only data.”

Question 10

Power BI Gateway

Q: Is sharing reports with others a primary function of the Power BI Gateway?

A. Yes, it’s the main way to share reports

B. No, sharing reports is done through the Power BI service itself

C. Yes, but only for on-premises reports

D. No, you need Power Automate to share reports

Answer 10

Answer: B – No, sharing reports is done through the Power BI service itself.

Key Point: Gateway refreshes data; Power BI Service shares reports.

Example: You share a report by publishing to Power BI Service and giving colleagues access. Gateway just keeps the data fresh.

Remember: “Gateway = Data pipe. Sharing = Power BI Service feature.”

Question 11

Data Visualization

Q: Which chart type is best to show the relationship between two variables in a dataset?

A. Scatter chart

B. Bar chart

C. Line chart

D. Pie chart

Answer 11

Answer: A – Scatter chart.

Key Point: Scatter chart = See correlation and patterns.

Example: Plot “Hours Studied” (x-axis) vs “Test Score” (y-axis). You’ll see if more study time correlates with higher scores. Each dot = one student.

Remember: “Scatter = Spot the relationship between X and Y.”

Question 12

Data Visualization

Q: Why is a bar chart NOT suitable for showing the relationship between two continuous variables?

A. Bar charts can only display one variable

B. Bar charts are used to compare categories or groups, not show correlations

C. Bar charts don’t support numeric data

D. Bar charts are only for time-series data

Answer 12

Answer: B – Bar charts are used to compare categories or groups, not show correlations.

Key Point: Bar chart = Compare categories, not relationships.

Example: Bar chart shows Sales by Region (North, South, East, West). It compares groups but doesn’t show how two variables relate to each other.

Remember: “Bar = Compare groups. Scatter = Show correlation.”

Question 13

Data Visualization

Q: When should you use a line chart instead of a scatter chart?

A. To show relationships between two variables

B. To show the proportion of parts to a whole

C. To show trends over time or continuous data

D. To compare different categories

Answer 13

Answer: C – To show trends over time or continuous data.

Key Point: Line chart = Trends over time.

Example: Plot daily website traffic over 30 days. The line shows whether traffic is increasing, decreasing, or stable.

Remember: “Line = Time trends. Scatter = Variable relationships.”

Question 14

Data Visualization

Q: What is the primary use case for a pie chart?

A. Showing relationships between two variables

B. Showing trends over time

C. Showing the proportion of different categories or parts of a whole

D. Identifying outliers in a dataset

Answer 14

Answer: C – Showing the proportion of different categories or parts of a whole.

Key Point: Pie chart = Part-to-whole percentage.

Example: Show market share: Company A (40%), Company B (35%), Company C (25%). The whole pie = 100% of the market.

Remember: “Pie = Slices of the whole (percentages).”

Question 15

Row-Level Security (RLS)

Q: A sales manager changes to a different region. You have RLS implemented with mail-enabled security groups assigned to each role. What should you do to ensure the manager sees the correct sales data?

A. Change the Microsoft Power BI license type of the sales manager

B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports

C. Manage the permissions of the underlying dataset

D. Request that the sales manager be added to the correct Azure Active Directory group

Answer 15

Answer: D – Request that the sales manager be added to the correct Azure Active Directory group.

Key Point: RLS roles are assigned at the Azure AD group level, not in Power BI Desktop.

Example: Manager moves from East region to West region. Remove them from “East Sales Managers” Azure AD group and add them to “West Sales Managers” group. RLS automatically updates their access.

Remember: “Role changed? Update the Azure AD group, not the Power BI report.”

Question 16

Anomaly Detection

Q: You have a Power BI report showing gross sales by date with anomaly detection enabled. No anomalies are detected. What should you do to increase the likelihood that anomaly detection will identify anomalies?

A. Increase the Expected range transparency setting

B. Add a data field to the Legend field well

C. Increase the Sensitivity setting

D. Add a data field to the Secondary values field well

Answer 16

Answer: C – Increase the Sensitivity setting.

Key Point: Sensitivity controls how strict the anomaly detection is.

Example: Sales are normally $10K–$12K daily. At low sensitivity, only a $20K day triggers an alert. At high sensitivity, even a $14K day gets flagged as unusual.

Remember: “More sensitivity = More anomalies detected. Less sensitivity = Only extreme outliers.”

Question 17

Anomaly Detection

Q: What do the other settings control in anomaly detection?

A. Expected range transparency affects the visual appearance of the confidence band

B. Legend field well groups data by categories

C. Secondary values field well adds a secondary measure

D. All of the above

Answer 17

Answer: D – All of the above, but none affect anomaly detection itself.

Key Point: Only Sensitivity affects detection; other settings are for display/grouping.

Example: Expected range transparency makes the gray confidence band lighter or darker. Legend splits the chart by Product. Neither changes what’s flagged as an anomaly.

Remember: “Sensitivity = Detection power. Other settings = Visual/grouping options.”

Question 18

Slicers vs Filters

Q: What is the difference between a slicer and a filter in Power BI?

A. A slicer is a visual control that allows users to filter data, while a filter is a data manipulation tool that allows users to filter data

B. A slicer is a data manipulation tool that allows users to filter data, while a filter is a visual control that allows users to filter data

C. A slicer and a filter are the same thing

D. A slicer and a filter are not available in Power BI

Answer 18

Answer: A – A slicer is a visual control that allows users to filter data, while a filter is a data manipulation tool that allows users to filter data.

Key Point: Slicer = Visible on report page (users interact). Filter = Behind-the-scenes (set by report designer).

Example: Slicer: Dropdown on the report where users can select “North” or “South” region. Filter: Pre-filtered to only show data from 2024 (users don’t see this control).

Remember: “Slicer = User sees and clicks. Filter = Hidden, automatic.”

Question 19

Slicers vs Filters

Q: Where do slicers and filters apply their filtering?

A. Slicers filter based on specific criteria, filters filter by selecting values from a list

B. Both filter data, but slicers are interactive visual controls and filters are applied in the Filters pane

C. Slicers are only for dates, filters are for all data types

D. Filters are more powerful than slicers

Answer 19

Answer: B – Both filter data, but slicers are interactive visual controls and filters are applied in the Filters pane.

Key Point: Same end result (filtered data), different interface.

Example: You can filter to “Year = 2024” using either a Year slicer (dropdown on page) or a filter in the Filters pane (hidden from users). Both achieve the same filtered dataset.

Remember: “Slicers = User-facing. Filters = Designer-controlled.”

Question 20

Power BI Q&A Feature

Q: What is the purpose of the Power BI Q&A feature?

A. To allow users to ask natural language questions and receive visual answers

B. To provide a way to export data to Excel

C. To create custom visuals for reports and dashboards

D. To schedule data refreshes for reports and dashboards

Answer 20

Answer: A – To allow users to ask natural language questions and receive visual answers.

Key Point: Q&A = Natural language queries that generate visuals automatically.

Example: User types “What were total sales by region last year?” and Power BI automatically creates a bar chart showing the answer.

Remember: “Q&A = Ask in plain English, get instant visuals.”

Question 21

Power BI Q&A Feature

Q: Is exporting data to Excel the primary purpose of the Q&A feature?

A. Yes, Q&A is mainly for exporting data

B. No, Q&A is for asking questions and getting visual answers, not exporting

C. Yes, but only for certain data types

D. Q&A doesn’t work with Excel at all

Answer 21

Answer: B – No, Q&A is for asking questions and getting visual answers, not exporting.

Key Point: Q&A creates insights, not exports.

Example: Q&A shows you “Top 5 products by revenue” as a visual. If you want to export, that’s a different Power BI feature (Analyze in Excel).

Remember: “Q&A = Insights. Export = Different feature.”

Question 22

Data Normalization

Q: What is the purpose of data normalization?

A. To scale data to a common range

B. To remove outliers from the data

C. To replace missing data with estimated values

D. To transform data into a different format

Answer 22

Answer: A – To scale data to a common range.

Key Point: Normalization puts all variables on the same scale to avoid bias.

Example: You’re comparing Age (0-100) and Income ($20K-$200K). Without normalization, income dominates because its numbers are bigger. Normalize both to 0-1 scale for fair comparison.

Remember: “Normalize = Level the playing field (same scale).”

Question 23

Data Normalization

Q: How does normalization help with machine learning algorithms?

A. It removes bad data

B. It prevents variables with larger ranges from dominating the analysis

C. It fills in missing values

D. It changes data types

Answer 23

Answer: B – It prevents variables with larger ranges from dominating the analysis.

Key Point: Larger numbers ≠ more important. Normalization ensures equal weight.

Example: Predicting house prices using square footage (500-5000) and # of bedrooms (1-5). Without normalization, square footage dominates because its scale is 1000x larger.

Remember: “Normalization stops big numbers from bullying small numbers.”

Question 24

Data Normalization

Q: Is removing outliers the same as data normalization?

A. Yes, they’re the same thing

B. No, removing outliers is data cleaning; normalization is scaling to a common range

C. Yes, but only for numeric data

D. They’re unrelated concepts

Answer 24

Answer: B – No, removing outliers is data cleaning; normalization is scaling to a common range.

Key Point: Different techniques with different purposes.

Example: Outlier removal: Delete the data point where someone is 200 years old (error). Normalization: Scale valid ages 18-65 to range 0-1.

Remember: “Outlier removal = Delete bad data. Normalization = Scale good data.”

Question 25

# Data Modeling - Entities Q: You are creating a data model for a retail company. Which entity should you use to store information about customer orders? A. Order B. Product C. Customer D. Salesperson

Answer 25

Answer: A – Order. ## Footnote **Key Point:** Order entity stores transaction details (what was purchased, when, by whom). **Example:** Order table has: OrderID, OrderDate, CustomerID, ProductID, Quantity, Price. Each row = one order transaction. **Remember:** "Order = The transaction itself (who bought what, when)."

Question 26

# Data Modeling - Entities Q: Why is the Customer entity NOT the correct choice for storing order information? A. Customer stores demographic data, not transaction data B. Customer and Order are the same thing C. Customer can only store names and addresses D. Customer entity doesn't exist in retail models

Answer 26

Answer: A – Customer stores demographic data, not transaction data. ## Footnote **Key Point:** Customer = Who they are. Order = What they bought. **Example:** **Customer table:** CustomerID, Name, Email, Address, Phone. **Order table:** OrderID, CustomerID (reference), OrderDate, TotalAmount. **Remember:** "Customer = Person details. Order = Purchase details."

Question 27

# Data Modeling - Entities Q: In a retail data model, what should the Product entity contain? A. Customer order history B. Product attributes like ID, name, description, and price C. Salesperson information D. Order transaction details

Answer 27

Answer: B – Product attributes like ID, name, description, and price. ## Footnote **Key Point:** Product entity describes the items being sold. **Example:** Product table: ProductID, ProductName, Category, Description, UnitPrice, Supplier. **Remember:** "Product = What's for sale (item details)."

Question 28

# Data Modeling - Entities Q: What is the relationship between Order, Customer, and Product entities? A. They're all the same table B. Order references both Customer (who bought) and Product (what was bought) C. Customer contains all order and product information D. There's no relationship between them

Answer 28

Answer: B – Order references both Customer (who bought) and Product (what was bought). ## Footnote **Key Point:** Order is the fact table connecting dimensions (Customer, Product). **Example:** Order contains CustomerID (links to Customer table) and ProductID (links to Product table). This creates a star schema. **Remember:** "Order sits in the middle, connecting Customer and Product."

Question 29

# CRM Data Modeling Q: You are designing a data model for a customer relationship management system. Which entity should you use to store information about customer interactions? A. Account B. Contact C. Opportunity D. Activity

Answer 29

Answer: D – Activity. ## Footnote **Key Point:** Activity entity tracks each individual interaction (calls, emails, meetings, tasks). **Example:** Activity table: ActivityID, ActivityType ("Phone Call"), Date, Time, CustomerID, Notes ("Discussed pricing for Q1 contract"). **Remember:** "Activity = Every touchpoint with the customer (the interaction log)."

Question 30

# CRM Data Modeling Q: What is the purpose of the Account entity in a CRM system? A. To store customer interaction details B. To store company/organization information you do business with C. To track sales opportunities D. To log individual customer contacts

Answer 30

Answer: B – To store company/organization information you do business with. ## Footnote **Key Point:** Account = The company/organization (not individual people). **Example:** Account: Acme Corporation, Address: 123 Main St, Industry: Manufacturing, Annual Revenue: $50M. **Remember:** "Account = The business entity (company level)."

Question 31

# CRM Data Modeling Q: What is the difference between Contact and Activity entities in CRM? A. Contact stores person information; Activity stores interactions with that person B. They're the same thing C. Contact is for companies; Activity is for people D. Activity stores demographics; Contact stores interactions

Answer 31

Answer: A – Contact stores person information; Activity stores interactions with that person. ## Footnote **Key Point:** Contact = Who they are. Activity = What you did with them. **Example:** **Contact:** John Smith, Title: Purchasing Manager, Email: [john@acme.com](mailto:john@acme.com). **Activity:** Called John Smith on 2/10/2026 at 2pm about renewal. **Remember:** "Contact = The person. Activity = The conversation/meeting/email."

Question 32

# CRM Data Modeling Q: What does the Opportunity entity represent in a CRM data model? A. Customer interactions like calls and emails B. Potential sales deals with deal amount and close date C. Company account information D. Individual person contact details

Answer 32

Answer: B – Potential sales deals with deal amount and close date. ## Footnote **Key Point:** Opportunity = A potential sale in the pipeline. **Example:** Opportunity: "Acme Q1 Software License," Amount: $100K, Expected Close: March 31, Stage: Proposal Sent, Probability: 60%. **Remember:** "Opportunity = The deal you're trying to close (sales pipeline)."

Question 33

# Data Security & Encryption Q: You have reports with financial datasets exported as PDFs. What should you implement to ensure the reports are encrypted? A. Microsoft Intune policies B. Row-level security (RLS) C. Sensitivity labels D. Dataset certifications

Answer 33

Answer: C – Sensitivity labels. ## Footnote **Key Point:** Sensitivity labels classify data and enforce encryption/protection policies. **Example:** Apply "Confidential - Finance" label to financial reports. This automatically encrypts PDFs and restricts who can open them. **Remember:** "Sensitivity labels = Auto-encrypt based on data classification."

Question 34

# Data Security & Encryption Q: Why is Row-level security (RLS) NOT the solution for encrypting exported PDF reports? A. RLS controls who sees what data, not PDF encryption B. RLS only works with Excel files C. RLS is for mobile devices only D. RLS doesn't work with financial data

Answer 34

Answer: A – RLS controls who sees what data, not PDF encryption. ## Footnote **Key Point:** RLS = Access control inside Power BI, not file encryption. **Example:** RLS lets East region managers see only East data. But when they export to PDF, RLS doesn't encrypt the PDF file itself. **Remember:** "RLS = Who sees what. Sensitivity labels = Encrypt the output."

Question 35

# Data Security & Encryption Q: What are Microsoft Intune policies used for? A. Encrypting Power BI reports B. Managing and securing mobile devices and applications C. Setting up row-level security D. Certifying datasets

Answer 35

Answer: B – Managing and securing mobile devices and applications. ## Footnote **Key Point:** Intune = Mobile device management (MDM), not Power BI encryption. **Example:** Intune enforces "Must use PIN to unlock phone" or "Encrypt all company data on tablets." Not specific to Power BI reports. **Remember:** "Intune = Device security. Sensitivity labels = Content security."

Question 36

# Data Security & Encryption Q: What do dataset certifications indicate in Power BI? A. The dataset is encrypted B. The dataset has been reviewed and approved as accurate/reliable C. The dataset uses row-level security D. The dataset is automatically backed up

Answer 36

Answer: B – The dataset has been reviewed and approved as accurate/reliable. ## Footnote **Key Point:** Certification = Quality stamp of approval, not encryption. **Example:** IT certifies the "Sales Revenue" dataset as accurate and trusted. Users see a badge showing it's approved, but this doesn't encrypt reports. **Remember:** "Certification = Trust/quality badge. Sensitivity = Encryption/protection."

Question 37

# Dataset Refresh Troubleshooting Q: A dataset refreshes hourly but the refresh was disabled due to inactivity. Which two actions will cause the scheduled refresh to resume? (Choose two) A. Enable query caching for the dataset B. Import the dataset to Microsoft Excel C. From the Power BI service, open a dashboard that uses the dataset D. From the Power BI service, open a report that uses the dataset E. From PowerShell, run the get-powerbireport cmdlet

Answer 37

Answer: C and D – Open a dashboard or report that uses the dataset. ## Footnote **Key Point:** Inactivity pause = No one's viewing the content. Resume by accessing it. **Example:** Dataset stopped refreshing after 30 days of no views. Open the "Sales Dashboard" or "Revenue Report" in Power BI Service → refresh schedule resumes. **Remember:** "Inactive = Nobody looked at it. Fix = View the dashboard/report."

Question 38

# Dataset Refresh Troubleshooting Q: Why doesn't enabling query caching resume a paused scheduled refresh? A. Query caching only affects query performance, not refresh schedules B. Query caching is only for Excel C. Query caching disables all refreshes D. Query caching requires PowerShell

Answer 38

Answer: A – Query caching only affects query performance, not refresh schedules. ## Footnote **Key Point:** Query caching speeds up repeated queries but doesn't trigger dependency checks. **Example:** Query caching stores results of "Show me total sales" so the next person gets instant results. It doesn't wake up a sleeping refresh schedule. **Remember:** "Query cache = Speed boost. Opening content = Dependency trigger."

Question 39

# Dataset Refresh Troubleshooting Q: Why doesn't importing the dataset to Excel resume the scheduled refresh? A. Excel import only analyzes data locally, doesn't trigger Power BI dependency checks B. Excel isn't compatible with Power BI C. Excel import deletes the refresh schedule D. Excel can only import dashboards, not datasets

Answer 39

Answer: A – Excel import only analyzes data locally, doesn't trigger Power BI dependency checks. ## Footnote **Key Point:** Analyze in Excel downloads a copy; doesn't count as "using" the dataset in Power BI. **Example:** You export data to Excel to make a pivot table locally. Power BI doesn't see this as activity on the dashboard/report. **Remember:** "Excel export = Offline copy. Dashboard/report view = Online activity."

Question 40

# Data Visualization - Distribution Charts Q: You want to show the distribution of customer ages in a survey. Which chart type would be best to use? A. Histogram B. Line chart C. Pie chart D. Scatter chart

Answer 40

Answer: A – Histogram. ## Footnote **Key Point:** Histogram shows frequency distribution of continuous numerical data. **Example:** Survey has 1000 customers. Histogram shows: 150 people aged 18-25, 300 aged 26-35, 400 aged 36-50, 150 aged 51-65. You see the age distribution visually. **Remember:** "Histogram = See how data is distributed across ranges (frequency bars)."

Question 41

# Data Visualization - Distribution Charts Q: Why is a line chart NOT appropriate for showing age distribution? A. Line charts are for trends over time, not frequency distributions B. Line charts can't display age data C. Line charts are only for categorical data D. Line charts require two variables

Answer 41

Answer: A – Line charts are for trends over time, not frequency distributions. ## Footnote **Key Point:** Line chart = Change over time. Histogram = Distribution at one point in time. **Example:** **Line chart:** Show how average customer age changed from 2020 to 2025. **Histogram:** Show how many customers fall into each age bracket right now. **Remember:** "Line = Time trend. Histogram = Snapshot distribution."

Question 42

# Data Visualization - Distribution Charts Q: Why would a pie chart be inappropriate for showing age distribution? A. Pie charts show proportion of categories, not continuous data distribution B. Pie charts can't display numeric data C. Pie charts are only for financial data D. Pie charts require exactly 3 categories

Answer 42

Answer: A – Pie charts show proportion of categories, not continuous data distribution. ## Footnote **Key Point:** Pie = Part-to-whole for categories. Histogram = Frequency across ranges. **Example:** **Pie chart:** 40% Male, 60% Female (2 distinct categories). **Histogram:** Age distribution across many ranges (18-25, 26-35, etc.). **Remember:** "Pie = Categorical slices. Histogram = Continuous distribution."

Question 43

# Data Visualization - Distribution Charts Q: When would you use a scatter chart instead of a histogram? A. To show relationship between two variables, not distribution of one variable B. Scatter charts and histograms are the same C. To show distribution of ages D. To show proportions

Answer 43

Answer: A – To show relationship between two variables, not distribution of one variable. ## Footnote **Key Point:** Scatter = Correlation between X and Y. Histogram = Frequency of one variable. **Example:** **Scatter:** Age (x-axis) vs Income (y-axis) to see correlation. **Histogram:** Just age distribution (one variable). **Remember:** "Scatter = Two-variable relationship. Histogram = One-variable distribution."

Question 44

# Data Modeling - Transportation Company Q: You are creating a data model for a transportation company. Which entity should you use to store information about vehicles? A. Vehicle B. Driver C. Route D. Shipment

Answer 44

Answer: A – Vehicle. ## Footnote **Key Point:** Vehicle entity stores attributes of the physical transportation assets. **Example:** Vehicle table: VehicleID, Make, Model, Year, License Plate, VIN, Capacity, Maintenance Schedule. **Remember:** "Vehicle = The truck/van/car itself (the asset)."

Question 45

# Data Modeling - Transportation Company Q: What is the purpose of the Driver entity in a transportation data model? A. To store vehicle specifications B. To link drivers to vehicles but not store driver information C. To store driver information like name, license number, and certifications D. To track shipment details

Answer 45

Answer: C – To store driver information like name, license number, and certifications. ## Footnote **Key Point:** Driver entity stores information about the people operating vehicles. **Example:** Driver table: DriverID, Name, License Number, CDL Class, Certifications, Hire Date, Phone. **Remember:** "Driver = The person operating the vehicle (the employee)."

Question 46

# Data Modeling - Transportation Company Q: What does the Route entity represent in a transportation data model? A. Vehicle information B. The planned movement path of vehicles between locations C. Driver assignments D. Vehicle specifications

Answer 46

Answer: B – The planned movement path of vehicles between locations. ## Footnote **Key Point:** Route defines the path/plan for vehicle movement. **Example:** Route table: RouteID, Origin, Destination, Distance, Estimated Time, Waypoints. Route can link to Vehicle through a relationship. **Remember:** "Route = The path from A to B (the travel plan)."

Question 47

# Data Modeling - Transportation Company Q: What is the Shipment entity used for in transportation data modeling? A. To store vehicle maintenance records B. To store information about goods/products being transported C. To track driver certifications D. To define travel routes

Answer 47

Answer: B – To store information about goods/products being transported. ## Footnote **Key Point:** Shipment represents the cargo/goods being moved. **Example:** Shipment table: ShipmentID, Origin, Destination, Weight, Customer, DeliveryDate, Status. Links to Vehicle (which vehicle carries it). **Remember:** "Shipment = The cargo being moved (the goods)."

Question 48

# Data Modeling - Transportation Company Q: How do Vehicle, Driver, Route, and Shipment entities relate in a transportation model? A. They're all independent with no relationships B. Vehicle is the central entity linking to Driver (who operates), Route (path taken), and Shipment (cargo carried) C. Only Driver and Vehicle are related D. Shipment contains all other entity data

Answer 48

Answer: B – Vehicle is the central entity linking to Driver (who operates), Route (path taken), and Shipment (cargo carried). ## Footnote **Key Point:** Vehicle connects the who (Driver), where (Route), and what (Shipment). **Example:** Vehicle #123 → operated by Driver John Smith → following Route A-to-B → carrying Shipment #456. **Remember:** "Vehicle in the middle: Driver operates it, Route guides it, Shipment fills it."

Question 49

# Data Modeling - Marketing Agency Q: You are creating a data model for a marketing agency. Which entity should you use to store information about campaigns? A. Campaign B. Lead C. Opportunity D. Contact

Answer 49

Answer: A – Campaign. ## Footnote **Key Point:** Campaign entity stores marketing initiative details. **Example:** Campaign table: CampaignID, Name, Start Date, End Date, Budget, Target Audience, Channel (Email/Social/TV). **Remember:** "Campaign = The marketing initiative (the promotion effort)."

Question 50

# Data Modeling - Marketing Agency Q: What is the purpose of the Lead entity in a marketing agency data model? A. To store campaign details B. To store information about potential customers who have shown interest C. To track confirmed sales opportunities D. To store contact information for existing clients

Answer 50

Answer: B – To store information about potential customers who have shown interest. **Key Point:** Lead = Unqualified prospect (early stage interest). **Example:** Lead table: LeadID, Name, Email, Source ("Downloaded whitepaper"), Interest Level, CampaignID. Not yet a customer. **Remember:** "Lead = Early interest (not yet qualified/customer)."

Question 51

# Data Modeling - Marketing Agency Q: How is a Lead different from an Opportunity in marketing? A. They're the same thing B. Lead is early-stage interest; Opportunity is qualified potential sale C. Lead is for products; Opportunity is for services D. Lead is for B2B; Opportunity is for B2C

Answer 51

Answer: B – Lead is early-stage interest; Opportunity is qualified potential sale. ## Footnote **Key Point:** Lead → qualify → becomes Opportunity. **Example:** **Lead:** Someone filled out "Request Info" form. **Opportunity:** After qualification call, they want a proposal for $50K project. **Remember:** "Lead = Maybe interested. Opportunity = Qualified sales prospect."

Question 52

# Data Modeling - Marketing Agency Q: Why is Contact entity NOT suitable for storing campaign information? A. Contact stores individual/company details, not campaign/initiative details B. Contact can only store email addresses C. Contact is only for phone numbers D. Contact and Campaign are the same

Answer 52

Answer: A – Contact stores individual/company details, not campaign/initiative details.

Question 53

# Workspace Permissions & Access Control Q: A user wants to create a report using data in DS1 and publish to another workspace. What should you do to minimize access permissions? A. Add the user as a Viewer of Workspace1 B. Grant the Build permission for DS1 to the user C. Share RPT1 with the user D. Add the user as a member of Workspace1

Answer 53

Answer: B – Grant the Build permission for DS1 to the user. ## Footnote **Key Point:** Build permission on dataset = Create reports using that data in any workspace. **Example:** User needs dataset DS1 to build a new report in Workspace2. Grant Build on DS1 → they can create reports anywhere, publish to Workspace2. No unnecessary workspace access. **Remember:** "Build permission = Access to data, not entire workspace (most granular)."

Question 54

# Workspace Permissions & Access Control Q: Why is adding the user as a Viewer of Workspace1 NOT the best solution? A. Viewer only allows viewing, not creating or publishing reports B. Viewer gives too much access to everything in the workspace C. Viewer permission doesn't exist D. Viewer is only for dashboards

Answer 54

Answer: A – Viewer only allows viewing, not creating or publishing reports. ## Footnote **Key Point:** Viewer = Read-only access. Can't create or publish new content. **Example:** User with Viewer role can view RPT1 and DS1 but cannot create a new report or publish to another workspace. **Remember:** "Viewer = Look, don't touch (read-only)."

Question 55

# Workspace Permissions & Access Control Q: Why is sharing RPT1 with the user NOT sufficient? A. Sharing RPT1 only gives access to that one report, not the ability to create new reports B. Sharing is the same as Build permission C. RPT1 cannot be shared D. Sharing only works within the same workspace

Answer 55

Answer: A – Sharing RPT1 only gives access to that one report, not the ability to create new reports. ## Footnote **Key Point:** Share = View existing content. Build = Create new content. **Example:** Share RPT1 → user can view that report. But they need Build on DS1 to create their own new report. **Remember:** "Share = See existing. Build = Make new."

Question 56

# Workspace Permissions & Access Control Q: Why does adding the user as a member of Workspace1 grant too many permissions? A. Member gives access to all content in Workspace1, more than necessary B. Member is read-only like Viewer C. Member doesn't allow creating reports D. Member permission doesn't exist

Answer 56

Answer: A – Member gives access to all content in Workspace1, more than necessary. ## Footnote **Key Point:** Minimize permissions = Grant only what's needed (principle of least privilege). **Example:** Workspace1 has 50 reports and 20 datasets. User only needs DS1. Member gives access to everything → violates least privilege. **Remember:** "Member = All workspace content. Build on dataset = Just that dataset (minimal)."

Question 57

# Calculated Tables & Formula Languages Q: How can you create a calculated table in Power BI? A. Use the DAX formula language B. Use the M formula language C. Use the SQL formula language D. Use the Python formula language

Answer 57

Answer: A – Use the DAX formula language. ## Footnote **Key Point:** DAX = Data Analysis Expressions, used for calculated tables, columns, and measures. **Example:** Create calculated Date table: `DateTable = CALENDAR(DATE(2020,1,1), DATE(2025,12,31))` creates a table with all dates in that range. **Remember:** "DAX = Calculated tables/columns/measures in Power BI."

Question 58

# Calculated Tables & Formula Languages Q: What is M formula language used for in Power BI? A. Creating calculated tables B. Data transformation and shaping (ETL) in Power Query C. Creating visuals D. Managing workspace permissions

Answer 58

Answer: B – Data transformation and shaping (ETL) in Power Query. ## Footnote **Key Point:** M = Power Query language for Extract, Transform, Load. **Example:** In Power Query: `= Table.RemoveColumns(Source, {"Column1"})` removes a column. This is M code, happens before data loads into model. **Remember:** "M = Power Query (clean/shape). DAX = Data model (calculate)."

Question 59

# Calculated Tables & Formula Languages Q: Can you use SQL to create calculated tables in Power BI? A. No, SQL is for databases; DAX is for Power BI calculated tables B. Yes, SQL is the primary language C. Yes, but only for cloud datasets D. SQL and DAX are the same

Answer 59

Answer: A – No, SQL is for databases; DAX is for Power BI calculated tables. ## Footnote **Key Point:** SQL queries databases. DAX calculates within Power BI model. **Example:** You can use SQL to import data from SQL Server (data source), but calculated tables inside Power BI use DAX. **Remember:** "SQL = Query external databases. DAX = Calculate inside Power BI."

Question 60

# Calculated Tables & Formula Languages Q: Can you use Python to create calculated tables in Power BI? A. Yes, but it's not the most efficient method; DAX is designed for this B. Yes, Python is the primary method C. No, Python isn't supported in Power BI D. Python is only for visuals

Answer 60

Answer: A – Yes, but it's not the most efficient method; DAX is designed for this. ## Footnote **Key Point:** Python can create custom visuals and advanced analytics, but DAX is optimized for calculated tables. **Example:** You can use Python script to manipulate data and output a table, but it's slower and less integrated than native DAX calculated tables. **Remember:** "Python = Advanced analytics/custom visuals. DAX = Native calculated tables (faster)."

Question 61

# Data Visualization - Category Comparison Q: You want to show the comparison of sales performance between different product categories. Which chart type would be best? A. Stacked bar chart B. Line chart C. Scatter chart D. Dual-axis chart

Answer 61

Answer: A – Stacked bar chart. ## Footnote **Key Point:** Stacked bar = Compare categories with subcategory breakdown. **Example:** Bar for Electronics ($100K total): Desktop $40K, Laptop $35K, Tablet $25K. Easy to compare total category and see subcategory contribution. **Remember:** "Stacked bar = Category comparison + subcategory breakdown."

Question 62

# Data Visualization - Category Comparison Q: Why is a line chart NOT best for comparing product categories? A. Line charts show trends over time, not category comparisons B. Line charts can't display sales data C. Line charts are only for scatter plots D. Line charts require three dimensions

Answer 62

Answer: A – Line charts show trends over time, not category comparisons. ## Footnote **Key Point:** Line = Time series. Bar = Category comparison. **Example:** **Line chart:** Sales trend Jan-Dec 2024. **Stacked bar:** Compare Electronics vs Clothing vs Home Goods (categories, not time). **Remember:** "Line = Over time. Bar = Between categories."

Question 63

# Data Visualization - Category Comparison Q: Why is a scatter chart NOT appropriate for comparing product categories? A. Scatter shows relationship between two variables, not category performance B. Scatter charts don't support sales data C. Scatter charts are only for time series D. Scatter charts can't display categories

Answer 63

Answer: A – Scatter shows relationship between two variables, not category performance. ## Footnote **Key Point:** Scatter = Correlation (X vs Y). Stacked bar = Category totals. **Example:** **Scatter:** Plot Price vs Units Sold to see correlation. **Stacked bar:** Show total sales by category. **Remember:** "Scatter = Variable relationship. Stacked bar = Category totals."

Question 64

# Data Visualization - Category Comparison Q: What is a dual-axis chart best used for? A. Comparing categories B. Showing two different measures with different scales on the same chart C. Showing distribution D. Showing proportions

Answer 64

Answer: B – Showing two different measures with different scales on the same chart. ## Footnote **Key Point:** Dual-axis = Two different scales (e.g., revenue + units sold). **Example:** Left axis: Revenue ($0-$1M). Right axis: Units Sold (0-10,000). Both plotted by month. Different scales, same timeline. **Remember:** "Dual-axis = Two measures, different scales, same chart."

Question 65

# Data Connectors - OneDrive/SharePoint Q: You have an Excel file in OneDrive that must be imported to Power BI and refreshed in [powerbi.com](http://powerbi.com). Which TWO connectors can you use? (Choose two) A. Excel Workbook B. Text/CSV C. Folder D. SharePoint folder E. Web

Answer 65

Answer: A and D – Excel Workbook and SharePoint folder. ## Footnote **Key Point:** OneDrive for Business is built on SharePoint Online, so both connectors support scheduled refresh in Power BI service. **Example:** Excel file at [`https://mycompany-my.sharepoint.com/personal/user/Documents/Sales.xlsx`](https://mycompany-my.sharepoint.com/personal/user/Documents/Sales.xlsx) can connect via Excel Workbook connector OR SharePoint folder connector. **Remember:** "OneDrive file = Use Excel Workbook OR SharePoint folder (both support refresh)."

Question 66

# Data Connectors - OneDrive/SharePoint Q: Why is Text/CSV connector NOT appropriate for an Excel file? A. Text/CSV only works for CSV files, not Excel workbooks B. Text/CSV is the same as Excel Workbook C. Text/CSV doesn't support OneDrive D. Text/CSV can only read text files, not any data

Answer 66

Answer: A – Text/CSV only works for CSV files, not Excel workbooks. ## Footnote **Key Point:** Connector must match file type. **Example:** If file is `Sales.xlsx` (Excel), use Excel Workbook connector. If file is `Sales.csv` (CSV), use Text/CSV connector. **Remember:** "File type determines connector: .xlsx = Excel, .csv = Text/CSV."

Question 67

# Data Connectors - OneDrive/SharePoint Q: Why is the Folder connector NOT suitable for OneDrive files with scheduled refresh? A. Folder is for local/network folders, not cloud OneDrive; doesn't support [powerbi.com](http://powerbi.com) refresh B. Folder connector doesn't work with Excel files C. Folder is only for PDFs D. Folder is the same as SharePoint folder

Answer 67

Answer: A – Folder is for local/network folders, not cloud OneDrive; doesn't support powerbi.com refresh. ## Footnote **Key Point:** Folder = Local file system. SharePoint folder = Cloud (supports refresh). **Example:** **Folder:** `C:\Users\Jeff\Documents\Sales\` on your PC (no cloud refresh). **SharePoint folder:** OneDrive path (supports refresh). **Remember:** "Folder = Local only. SharePoint folder = Cloud with refresh."

Question 68

# Data Connectors - OneDrive/SharePoint Q: Why is the Web connector NOT recommended for OneDrive Excel files? A. Web can technically connect via URL but doesn't provide seamless integration or reliable refresh B. Web connector is the best option C. Web connector can't access URLs D. Web is only for HTML pages

Answer 68

Answer: A – Web can technically connect via URL but doesn't provide seamless integration or reliable refresh. ## Footnote **Key Point:** Web connector lacks native OneDrive/SharePoint integration. **Example:** You could use a direct download URL, but authentication and refresh are unreliable compared to Excel Workbook or SharePoint folder connectors. **Remember:** "Web = Can work but unreliable. Excel/SharePoint connectors = Built for this."

Question 69

# Custom Themes Q: How can you create a custom theme in Power BI? A. Use the Power BI Desktop B. Use the Power BI Service C. Use the Power BI Mobile App D. Use the Power BI Developer Tools

Answer 69

Answer: A – Use the Power BI Desktop. ## Footnote **Key Point:** Custom themes are created in Desktop, then can be applied to other reports. **Example:** In Desktop: View tab → Themes → Customize Current Theme. Modify colors (brand blue #0078D4), fonts (corporate font), visuals. Save as .json theme file. **Remember:** "Desktop = Create themes. Service/Mobile = View only."

Question 70

# Custom Themes Q: What can you customize in a Power BI theme? A. Only colors B. Colors, fonts, and visual styles (background colors, borders, font styles) C. Only fonts D. Only page backgrounds

Answer 70

Answer: B – Colors, fonts, and visual styles (background colors, borders, font styles). ## Footnote **Key Point:** Themes control comprehensive visual appearance. **Example:** Customize: Primary color (blue), secondary color (orange), title font (Arial Bold 14pt), background (light gray), visual borders (rounded), page background (company logo watermark). **Remember:** "Theme = Colors + Fonts + Visual styles (comprehensive branding)."

Question 71

# Custom Themes Q: Why would you create a custom theme? A. To ensure consistent branding across all Power BI reports B. To make reports load faster C. To add more data to reports D. To enable row-level security

Answer 71

Answer: A – To ensure consistent branding across all Power BI reports. ## Footnote **Key Point:** Themes enforce visual consistency aligned with organizational branding. **Example:** All company reports use brand colors (blue/orange), corporate font (Segoe UI), same visual styles. Users immediately recognize it's an official company report. **Remember:** "Custom theme = Brand consistency (professional look)."

Question 72

# Custom Themes Q: Can you create custom themes in Power BI Service? A. No, themes are created in Desktop and imported to Service B. Yes, Service has more theme options than Desktop C. Yes, but only for dashboards D. Themes don't exist in Service

Answer 72

Answer: A – No, themes are created in Desktop and imported to Service. ## Footnote **Key Point:** Desktop = Theme authoring. Service = Theme consumption. **Example:** Create theme in Desktop, save as `CompanyTheme.json`. Publish report to Service → theme is applied. You can't edit the theme in Service. **Remember:** "Desktop = Make themes. Service = Use themes."

Question 73

# Data Modeling - Time Intelligence Best Practices Q: You have a date table with Due Date, Order Date, and Delivery Date foreign keys. You rename the date table to "Due Date" and use DAX to create Order Date and Delivery Date as calculated tables. Does this meet the goal? A. Yes B. No

Answer 73

Answer: B – No. ## Footnote **Key Point:** Creating calculated tables for multiple date relationships is inefficient. Use relationships instead. **Example:** **Bad approach:** 3 separate date tables (Due Date, Order Date, Delivery Date) = performance hit, complex DAX. **Better:** 1 Date table with 3 relationships to Sales (inactive relationships activated with USERELATIONSHIP in DAX). **Remember:** "Multiple date roles = Use relationships, NOT calculated tables."

Question 74

# Data Modeling - Time Intelligence Best Practices Q: What are the drawbacks of creating multiple calculated date tables? A. Performance impact, complexity, and limited flexibility B. It's the best practice C. Calculated tables are always faster D. No drawbacks

Answer 74

Answer: A – Performance impact, complexity, and limited flexibility. ## Footnote **Key Point:** Multiple tables = 3x the memory, complex DAX, static data. **Example:** **Performance:** 3 date tables with 10 years each = 30K rows vs 1 table with 10K rows. **Complexity:** Managing 3 separate tables vs 1. **Flexibility:** Calculated tables are static, relationships are dynamic. **Remember:** "More tables = More problems (memory, complexity, inflexibility)."

Question 74

# Data Modeling - Time Intelligence Best Practices Q: What is the better approach for handling multiple date relationships? A. Create calculated tables for each date role B. Create relationships between one Date table and the fact table, using inactive relationships C. Don't use a date table at all D. Use Python to manage dates

Answer 74

Answer: B – Create relationships between one Date table and the fact table, using inactive relationships. ## Footnote **Key Point:** One Date table, multiple relationships (one active, others inactive). **Example:** Date table relates to Sales on: OrderDate (active), DueDate (inactive), DeliveryDate (inactive). Use `CALCULATE([Sales], USERELATIONSHIP(Sales[DueDate], Date[Date]))` to activate specific relationship. **Remember:** "One Date table + USERELATIONSHIP = Better performance."

Question 75

# Data Modeling - Time Intelligence Best Practices Q: What DAX function activates inactive relationships for time intelligence? A. USERELATIONSHIP B. RELATED C. RELATEDTABLE D. ACTIVATE

Answer 75

Answer: A – USERELATIONSHIP. ## Footnote **Key Point:** USERELATIONSHIP temporarily activates an inactive relationship. **Example:** `Sales by Due Date = CALCULATE([Total Sales], USERELATIONSHIP(Sales[DueDate], Date[Date]))` activates the DueDate relationship to calculate sales by due date instead of order date. **Remember:** "USERELATIONSHIP = Switch to different date role in calculation."