This page was exported from Exams Labs Braindumps [ http://blog.examslabs.com ] Export date:Sat Sep 21 7:28:02 2024 / +0000 GMT ___________________________________________________ Title: Get Started DA-100 Exam [year] Dumps Microsoft PDF Questions [Q18-Q34] --------------------------------------------------- Get Started: DA-100 Exam [year] Dumps Microsoft PDF Questions DA-100 Premium Exam Engine pdf Download Exam Topics Microsoft expects that the successful candidates get the passing score of 720 points on a scale of 100-1000. This mark is achievable if you put your mind to it. To succeed, you must understand the Microsoft DA-100 exam topics that are as follows: 1. Data Preparation (20-25%): This part includes the following areas: Collecting data from various data sources: The candidates must be able to connect and identify data sources, alternate data source settings, and choose storage mode and shared datasets, or build local datasets. They also need the capacity to select the relevant query type, utilize parameters, Microsoft Dataverse, create or use PBIDS files, and data flow.Data profile: The test takers should have competence in interrogating data statistics and column properties as well as identifying data anomalies and evaluating data structures.Cleaning, loading, & transforming data: This subject area requires that the students understand how to combine queries, utilize user-friendly value substitutions, solve data import errors, transform and measure column data types, and configure the data loading. It also covers their skills in applying data shape transformations for table structures and user-friendly conventional naming for queries and columns. The individuals should also have the expertise in leveraging Advanced Editor or modifying Power Query M-code. Conclusion: Getting Microsoft Certified Is Challenging But Possible! The Microsoft Certified: Data Analyst Associate certificate will help secure a career as a data analyst, which will come with it a high paycheck and different career opportunities. However, achieving this certification won't be easy as one needs to overcome DA-100 (Analyzing Data with Microsoft Power BI) exam. But, with a huge number of study guides available on Amazon and the official MS training course, passing this test is going to be that much easier. Skills measured Visualize the data (20-25%)Prepare the data (20-25%)The content of this exam was updated on July 29, 2021. Please download the exam skills outline below to see what changed.   NO.18 You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.You need to build the dashboard.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. ExplanationWhen you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.Step 1: Open the Dashboard.Step 2: Change the dashboard view to Phone viewStep 3: Pin items from the reports to the dashboard.Step 4: Rearrange, resize, or remote items from the Phone view.Create a phone view of a dashboard1. In the Power BI service, open a dashboard (Step 1)2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step 2)The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view.The web version of the dashboard doesn’t change.3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.4. If you change your mind, select Reset tiles to put them back in the size and order they were before.5. When you’re satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.Power BI saves the phone layout automatically.Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/service-create-dashboard-mobile-phone-viewNO.19 You are preparing a financial report in Power BI.You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.You need to prepare the data to support the following:Visualizations that include all measures in the data over timeYear-over-year calculations for all the measuresWhich four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 1 – Transpose the table2 – Unpivot all the columns other than Measure3 – Rename the Measure column as year4 – Change the data type of the year column to DateReference:https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098NO.20 You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:CustomerIDCustomer CityCustomer StateCustomer NameCustomer Address 1Customer Address 2Customer Postal CodeThe Invoice table contains the following fields:Order IDInvoice IDInvoice DateCustomer IDTotal AmountTotal Item CountThe Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.The Power BI model must provide the following information:The number of customers invoiced in each state last monthThe average invoice amount per customer in each postal codeYou need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understandNO.21 You have a folder of monthly transaction extracts.You plan to create a report to analyze the transaction data.You receive the following email message: “Hi. I’ve put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions.” You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. NO.22 You have the visual shown in the exhibit. (Click the Exhibit tab.)You need to show the relationship between Total Cost and Total Sales over time.What should you do?  Add a play axis.  Add a slicer for the year.  From the Analytics pane, add an Average line.  Create a DAX measure that calculates year-over-year growth. NO.23 You are creating an analytics report that will consume data from the tables shown in the following table.There is a relationship between the tables.There are no reporting requirements on employeejd and employee_photo.You need to optimize the data modelWhat should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area. NO.24 You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.You need to load only the manufacturing reports to a table for analysis.What should you do in Microsoft Power Bl Desktop?  Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.  Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.  Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.  Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load. Example:My SharePoint site root url is https://powerbipanama.sharepoint.com/, but all of my files are actually in another site that starts with https://powerbipanama.sharepoint.com/sites/externalsales/ URL.In order to use the correct URL, we need to be in the folder of the data that we’re trying to get and check the url that our browser shows. If it has the if it starts with the format of Error! Hyperlink reference not valid. address>/sites/<sitename>/ then we need to use that url, otherwise we use the much simpler Error! Hyperlink reference not valid. address> In my own case, I’ll be using the https://powerbipanama.sharepoint.com/sites/externalsales url in order to connect to my site.Reference:https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/NO.25 You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customers.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. NO.26 Your company has training videos that are published to Microsoft Stream.You need to surface the videos directly in a Microsoft Power BI dashboard.Which type of tile should you add?  video  custom streaming data  text box  web content Copy Embed code from Microsoft Stream and add a Web Content tile in power bi dashboardhttps://docs.microsoft.com/en-us/stream/portal-embed-videohttps://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add- web-contentNO.27 You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.You need to keep only the last modified row for each customer ID.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NO.28 You build a report to analyze customer transactions from a database that contains the tables shown in the following table.You import the tables.Which relationship should you use to link the tables?  one-to-many from Customer to Transaction  one-to-one between Customer and Transaction  one-to-many from Transaction to Customer  many-to-many between Customer and Transaction NO.29 You have a sales system that contains the tables shown in the following table.The Date table is marked as a date table.DatelD is the date data type. You need to create an annual sales growth percentage measure.Which DAX expression should you use?  SUM(sales[sales_amount]) – CALCULATE(SUM(sales[sales_amount]),SAMEPERIODLASTYEAR(‘Date'[DatelD])  CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date'[DatelD]))  (SUN(sales[sales_araount]) – CALCULATE(SUM(sales[sales_amount]),SAHEPERIOOLASTYEAR(‘Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR (‘Date'[DateID])  CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR(‘Date'[DatelD]) NO.30 You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.You need to load only the manufacturing reports to a table for analysis.What should you do in Microsoft Power Bl Desktop?  Get data from a SharePoint Online list, enter the site URL and then select Combine & Load.  Get data from a SharePoint Online folder and enter the site URL.Edit the query and filter by folder path.  Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.  Get data from a SharePoint Online list and enter the site URL.Edit the query and filter by folder path. NO.31 You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/dax/allselected-function-daxNO.32 You have two Azure SQL databases that contain the same tables and columns.For each database, you create a query that retrieves data from a table named Customers.You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/power-query/append-queriesNO.33 You are profiling data by using Power Query Editor.The AddressLine2 column in a table named Address is shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point. NO.34 You receive revenue data that must be included in Microsoft Power Bl reports.You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.You plan to create several visuals from the data, including a visual that shows revenue split by year and product.You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.  Loading … Pass Your Microsoft Exam with DA-100 Exam Dumps: https://www.examslabs.com/Microsoft/Microsoft-Certified-Data-Analyst-Associate/best-DA-100-exam-dumps.html --------------------------------------------------- Images: https://blog.examslabs.com/wp-content/plugins/watu/loading.gif https://blog.examslabs.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-06-17 08:02:59 Post date GMT: 2022-06-17 08:02:59 Post modified date: 2022-06-17 08:02:59 Post modified date GMT: 2022-06-17 08:02:59