Free DA-100 Sample Questions — Analyzing Data with Microsoft Power BI

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities
• B. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters
• C. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities
• D. a pie chart that shows balances by account category without filters
• E. a ribbon chart that shows balances by quarter and accounts in the legend

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 build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

• A. Line and clustered column chart
• B. Key influencers
• C. Q&A
• D. Funnel chart

Which DAX expression should you use to get the ending balances in the balance sheet reports?

• A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )
• B. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )
• C. FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )
• D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )

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 transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date
• C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
• D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query. You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Configure the dataset to use the existing On-premises data gateway
• B. Deploy an On-premises data gateway in personal mode
• C. Set the refresh frequency to Daily
• D. Configure the dataset to use the personal gateway

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

• A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table
• B. Duplicate the Date query in Power Query and use active relationships between both Date tables
• C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view
• D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

• A. FORMAT('Date'[date], "MMM YYYY")
• B. FORMAT('Date' [date], "M YY")
• C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
• D. FORMAT('Date' [date_id], "MMM YYYY")

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. Add a salary to the tooltips
• B. Add a salary to the visual filters
• C. Add salary to the drillthrough fields

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

• A. comments
• B. tiles
• C. Microsoft Information Protection sensitivity labels
• D. Active Directory groups