DA-100 Practice Questions
Prepare for DA-100 with more than an answer.
Unlock the full exam and previous versions
- v1Version 1 214 questions Locked
- DA-100Legacy Analyzing Data with Power BI 47 questions Current
- Exam fee
- $165 USD
- Level
- Associate
- Valid for
- 2 years
Domains covered on the exam 4
- Prepare the Data20%
- Model the Data35%
- Visualize the Data30%
- Deploy and Maintain Deliverables15%
- 1
You have the two Power Query M queries in Power BI Desktop. The one query retrieves a table named Customers from a Microsoft SQL Server database while the other query retrieves a table named _Customers from an Oracle database
Both the Customers and the _Customers tables have the same columns.
You need to combine the data from the two tables.
Which Power Query function should you use?
Show answer details
Correct answer: D
Append Queries is the correct method for combining tables with identical schema from different data sources. When you have Customers tables from SQL Server and Oracle with the same column structure, appending creates a union that stacks the rows from both tables. Merge Queries is for joining tables with related data, Combine Tables is not a Power Query operation, and Merge Columns combines column values within the same table, not separate tables from different sources.
- 2
You have a table named Sales. Sales has a column named CustomerID. The CustomerID column contains a few non-numeric values.
You want to replace the non-numeric values in the CustomerID column with the number 0.
Show answer details
Correct answer: A
Using Replace Values in Query Editor is the most direct method for handling non-numeric values in the CustomerID column. Selecting the column and using Replace Values allows you to specify finding null or non-numeric values and replacing them with 0. The Table.ReplaceNullValues function only handles null values, not all non-numeric values. Sort ascending does not replace values, and Fill Down propagates existing values rather than replacing invalid ones with a specific number.
- 3
You have a Microsoft Excel workbook with a spreadsheet named Sales.
You want to use the Sales spreadsheet in a Power BI dashboard report.
How should you prepare the data on Sales spreadsheet?
Show answer details
Correct answer: C
Converting data to a flat table in Excel is the essential first step before importing into Power BI. A flat table ensures each column contains the same data type (text, date, number, or currency) and includes a header row without total or summary rows. This structure allows Power BI to properly recognize data types and establish relationships. Simply importing the data, publishing the spreadsheet, or uploading the workbook without proper table formatting will result in data import errors and poor data model performance in Power BI.
- 4
You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.
You want to be able to use Microsoft R scripts in your visualization.
You install SQL Server R Services on SQL01.
Does this action allow you to use Microsoft R scripts in your visualization?
Show answer details
Correct answer: B
Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/sql/machine-learning/install/sql-r-services-windows-install?view=sql-server-2016
