DA-100 exam

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets. What should you recommend?A ....

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can...

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?A . Change the data type of Sales[region_id] to Whole Number.B . In the Sales table, add a measure for sum(sales_amount).C . Change the data type of sales[sales_id] to Text.D...

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model. What should you do?A . Round the hour of the Date column to startOfHour.B . Change the data type of...

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...

DRAG DROP Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them...

What are the major differences between distributed storage and centralized storage?A . The distributed architecture facilitates capacity expansion and reduction and eliminates data migration.B . Distributed storage is applicable to cloud storage resource pools. content repository, archiving. and big data storage.C . Distributed storage features high elasticity and scalability accelerating...

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: ✑ First name ✑ Last name ✑ Email address ✑ State/Region ✑ Phone number You import the list into Power Query Editor. You need to ensure that the list contains records for...

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...