DA-100 exam

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...

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")View AnswerAnswer: D Explanation: Scenario: In the Date...

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?A . scatter chartB . ribbon chartC...

Topic 3, Misc. Questions Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a...

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?A . area chartB . donut chartC . scatter plotD . pie chartView AnswerAnswer: C

HOTSPOT You are creating a column chart visualization. You configure groups as shown in the Groups exhibit. {Click the Groups tab.) The visualization appears as shown in the Chart exhibit. (Click the Chart tab.) For each of the following statements, select Yes if the statement is true. Otherwise, select No....

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?A . In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to...

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant 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...

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to...