Hello Readers. Here are some questions for the Microsoft Certification Exam DA100: Analyzing Data using Microsoft Power BI.
Here’s the Quiz:
Rita has training videos from her company that she wants to publish to Microsoft Stream. Rita needs to add the tiles to a Microsoft Power BI dashboard. Web contentb. Text Boxc. Custom streaming datad. video
You need to open a query in Power Query Editor. Show whitespaceb. Column profilec. Column distributiond. Column quality
A prospective customer list contains 1,500 rows. The list contains the following fields:First nameLast nameEmail addressState/RegionPhone numberYou 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 is worth one point. Open the Advanced Editor.b. Select Column quality.c. Allow Column profiling to be performed based on the entire dataset.d. Select Column distribution.e. Select Column distribution.e.
You have the following three versions of an Azure SQL database:TestProductionDevelopmentYou 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 containing the database server names. Import the JSON file into the dataset. Create a parameter, and update the queries to use it. Create a query for each server of the database and hide the development tables. Set the data source privacy to Organizational and use ReplaceValue Power Query M.
A CSV file contains user complaints. The file has a column called Logged. Logged is the date and time that each complaint was filed. What should you do?a. Change the data type to Dateb for the Logged column. Apply a transform and extract the last 11 characters from the Logged column. Then, set the date type of the new column as Date.c. To extract the first 11 characters from the Logged column, use a transform. Create a column named example that begins with 2018-12-31. Set the data type to Date.
An Azure SQL database contains sales transactions. To detect fraudulent transactions, the database must be updated regularly. How do you configure the data connection to your database? Add a SQL statement. Change the Data Connectivity mode from DirectQuery to Data Connectivity.c. The Command timeout setting is set to minutes. Set Data Connectivity mode for Import.
A data model contains many complex DAX statements. You have a data model that contains many complex DAX expressions. Using Power Query, merge tables. Split the model into multiple models.c. Retain any columns not used in the model.d. Transpose
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 reduce the size of t
