Hello Readers. Here are some sample questions for the Microsoft Certification Exam DA-100: Analyzing Data with Microsoft Power BI.
Here goes the Quiz:
- Rita’s company has training videos that are published to Microsoft Stream.
She needs to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should Rita add?
a. Web content
b. Text Box
c. Custom streaming data
- You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
a. show whitespace
b. Column profile
c. Column distribution
d. Column quality
- You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
a. Open the Advanced Editor.
b. Select Column quality.
c. Enable Column profiling based on the entire dataset.
d. Select Column distribution.
e. Select Column profile.
- You have the following three versions of an Azure SQL database:
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
a. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
b. Create a parameter and update the queries to use the parameter.
c. Create a query for each database server and hide the development tables.
d. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
- You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
a. Change the data type of the Logged column to Date
b. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
c. Apply a transform to extract the first 11 characters of the Logged column.
d. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
- You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
a. Add a SQL statement.
b. Set Data Connectivity mode to DirectQuery.
c. Set the Command timeout in minutes setting.
d. Set Data Connectivity mode to Import.
- You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
a. Merge tables by using Power Query.
b. Split the model into multiple models.
c. Hide unused columns in the model.
- You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using Q&A.
You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for “subscriber count” by using Q&A. The solution must minimize the size of the model.
What should you do?
a. Set Summarize By to None for the CustomerID column.
b. Add a synonym of “subscriber” to the Customer table.
c. Add a synonym of “subscriberID” to the CustomerID column.
d. Add a description of “subscriber count” to the Customer Count measure.
- You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
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. Request that the sales manager be added to the correct Azure Active Directory group.
d. Manage the permissions of the underlying dataset.
- You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
a. stacked area chart
b. donut chart
c. line chart
d. waterfall chart.
Check if your answers are correct or not here:
Explanation: The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.
Explanation: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
- d & e.
Explanation: Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab Ã Data Preview Group Ã
Explanation: With privacy level settings, you can specify an isolation level that defines the degree that one data source must be isolated from other data sources.
An Organizational data source limits the visibility of a data source to a trusted group of people. An Organizational data source is isolated from all Public data sources but is visible to other Organizational data sources.
Explanation: With Power Query you can Split Date and Time into Separate Columns by using a transform
Explanation: With Power BI Desktop, when you connect to your data source, it’s always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
Explanation: Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you would like to add to another query, you merge the queries.
Explanation: You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
Explanation: Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.
Explanation: A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time “” a time series “” thus the line is often drawn chronologically.
More sample questions are coming up, so keep checking. Please share your feedback in the below comments section.
Disclaimer: These questions are NOT appearing in the certification exam. I personally or CloudThat do not have any official tie-up with Microsoft regarding the certification or the kind of questions asked. These are my best guesses for the kind of questions to expect with Microsoft in general and with the examination.
Enrol for the Microsoft Azure Data Analyst Associate Certification Exam: DA-100 grab your Microsoft Badge soon.
Feel free to drop any questions in the comment box, I would love to address them. I hope you enjoyed the article. Best of luck!