DA-100 Exam Topic 1 Question Set 1
52 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What should you do to ensure users can get a useful result for 'subscriber count' by using Q&A while minimizing the size of the model?

  • Add a synonym of 'subscriberID' to the CustomerID column.
  • Add a description of 'subscriber count' to the Customer Count measure.
  • Add a synonym of 'subscriber' to the Customer table. (correct)
  • Set Summarize By to None for the CustomerID column.

    • What is the cause of users only seeing some of the customers when a map of 500,000 customers is visualized in Power BI on powerbi.com?

  • The data comes from a Microsoft SQL Server source.
  • The visual was built by using a different version of R.
  • The data is deduplicated.
  • Too many records were sent to the visual. (correct)

    • How should the visual interactions be set on the column chart when a segment is selected in the bar chart?

  • Filter
  • No impact
  • Highlight (correct)

    • You need to keep only the last modified row for each customer ID. What should you do?

    <p>Sort files by customer ID and keep the last row</p> Signup and view all the answers

    In a Power BI model containing employee information by state, how can you view the employees by region as quickly as possible?

    <p>Create a new group on the state column and set the Group type to List</p> Signup and view all the answers

    In Power BI, when creating a measure that returns the year-to-date total sales from the same date of the previous calendar year, which DAX functions should you use?

    <p>LASTYEAR and TOTALYTD</p> Signup and view all the answers

    Which of the following are two possible recommendations to ensure that users can select a value once to filter the results on all pages?

    <p>Sync the slicers across the pages.</p> Signup and view all the answers

    What type of visualization should you use to identify outliers in a table with sales data containing approximately 1,000 rows?

    <p>Scatter plot</p> Signup and view all the answers

    Which type of visualization should you use to compare revenue and cost over time?

    <p>Line chart</p> Signup and view all the answers

    Which type of visualization should you use to show historic employee counts and predict trends for the next six months for the HR department?

    <p>Line chart</p> Signup and view all the answers

    What should you include on the menu page to ensure that users can click each business question and be directed to the corresponding page?

    <p>Create a button for each business question and set the action type to Bookmark.</p> Signup and view all the answers

    What should you configure in Microsoft Power BI Desktop to ensure users can consume the content on a report page in a logical order?

    <p>The tab order</p> Signup and view all the answers

    To ensure a sales manager can see correct sales data after changing regions, what should you do?

    <p>Edit the Row-Level Security setting for the reports from Power BI Desktop.</p> Signup and view all the answers

    Which data modeling design should you use to analyze sales data by both purchase and ship dates independently and together?

    <p>Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.</p> Signup and view all the answers

    Which relationship should you use to link the Customer and Transaction tables for analyzing customer transactions?

    <p>One-to-many from Transaction to Customer</p> Signup and view all the answers

    If a user is a member of both Role1 and Role2, what data will they see in a report using the model with row-level security?

    <p>Data for which the State Province value is Kentucky and the Calendar Year is 2020.</p> Signup and view all the answers

    When configuring scheduled refresh in Microsoft Power BI, which two actions should you perform to ensure data is updated every morning with minimal configuration effort? (Select two)

    <p>Set the refresh frequency to Daily</p> Signup and view all the answers

    When providing a user with the ability to add members to a workspace in Microsoft Power BI, which role should you assign to the user to use the principle of least privilege?

    <p>Member</p> Signup and view all the answers

    What is a possible cause for a Microsoft Power BI dataset refresh failure when the dataset runs out of resources after deployment to Power BI Premium capacity? The refresh fails because _ is not occurring.

    <p>Query folding</p> Signup and view all the answers

    In Power BI service, you deploy a dataset and related reports to Microsoft Power BI Premium capacity from Azure Blob storage. After deploying, the dataset refresh fails due to resource shortages. What is a possible cause of this issue?

    <p>Query folding is not occurring</p> Signup and view all the answers

    To grant all organizational users read access to dashboards and reports in a Microsoft Power BI workspace, what solution should you enable for all assets?

    <p>Included in app</p> Signup and view all the answers

    In Power BI Desktop, what action allows you to combine data retrieved from tables named Customers and _Customers that have the same columns from different databases?

    <p>Append Queries</p> Signup and view all the answers

    Using the Column Profile Data Preview option in Power Query Editor allows you to ascertain the percentage of empty values in each column.

    <p>False</p> Signup and view all the answers

    When the step 'Table.ReplaceValue(SalesLT_Address, '1318', '1319', Replacer.ReplaceText, {'AddressLine1'})' is applied, what will the value be in the AddressLine1 column?

    <p>1319</p> Signup and view all the answers

    What should you recommend to improve the performance of a slow-loading Microsoft Power BI report with a large dataset and multiple visuals?

    <p>Change the imported dataset to DirectQuery.</p> Signup and view all the answers

    How can you automate daily notifications for a user in the Microsoft Power BI Service?

    <p>Create a subscription.</p> Signup and view all the answers

    Does importing a sample of data from a large SQL Server table in Microsoft Power BI by adding a filter step to the query meet the goal?

    <p>Yes</p> Signup and view all the answers

    Does adding a WHERE clause to the SQL statement to import a sample of data from a large SQL Server table in Microsoft Power BI meet the goal?

    <p>Yes</p> Signup and view all the answers

    When creating a parameter in Microsoft Power BI to reference a file name and location, if you modify the source step of the queries to use the parameter as the file path, does it meet the goal?

    <p>Yes</p> Signup and view all the answers

    When creating a parameter in Microsoft Power BI to reference a file name and location, if you create a new query that references the parameter, does it meet the goal?

    <p>No</p> Signup and view all the answers

    Does adding a report-level filter that filters based on the order date in Microsoft Power BI to import a sample of data from a large SQL Server table meet the goal?

    <p>Yes</p> Signup and view all the answers

    When writing a DAX expression that uses the FILTER function in Microsoft Power BI to import a sample of data from a large SQL Server table, does it meet the goal?

    <p>Yes</p> Signup and view all the answers

    In a Power BI dashboard monitoring manufacturing processes, to be notified when the daily percentage of defective products manufactured exceeds 3%, what should you create?

    <p>a subscription</p> Signup and view all the answers

    You are building a report analyzing the internal networks of employees based on whom they send emails to. How can you prevent report recipients from reading the analyzed emails while minimizing the model size?

    <p>Remove the Subject and Body columns during the import.</p> Signup and view all the answers

    What should you do to create an ad analytics system that presents ad impression counts for the day, campaign, and Site_name while minimizing the data model size?

    <p>Create a calculated table that contains Ad_id, Site_name, and Impression_date.</p> Signup and view all the answers

    To surface training videos directly in a Microsoft Power BI dashboard, which type of tile should you add?

    <p>Video</p> Signup and view all the answers

    When identifying the percentage of empty values in each column in Power Query Editor, which Data Preview option should you select?

    <p>Column profile</p> Signup and view all the answers

    When importing a prospective customer list into Power Query Editor, what actions should you perform to ensure records for each State/Region are included?

    <p>Open the Advanced Editor.</p> Signup and view all the answers

    You plan to include only a subset of columns and need to remove any columns that have a suffix of ______. How should you complete the Power Query M code?

    <p>sourceid</p> Signup and view all the answers

    Match the following actions in sequence to import attributes as columns from a JSON file while ensuring date attributes can be used as hierarchies in Power BI reports:

    <p>Create a new query from a JSON file. = Step 1 Expand the JSON column with list values. = Step 2 Select and use the 'Use original column name as prefix' option in Column headers. = Step 3</p> Signup and view all the answers

    To create a query with one row per customer, with each row containing City, State/Region, and Country, what should you do?

    <p>Merge the Customer and Address tables.</p> Signup and view all the answers

    What should you do to configure a dataset to easily change the data source between different Azure SQL database servers from powerbi.com?

    <p>Create a parameter and update the queries to use the parameter.</p> Signup and view all the answers

    To analyze user complaints by the logged date with a built-in date hierarchy, what should you do to ensure proper data analysis?

    <p>Change the data type of the Logged column to Date.</p> Signup and view all the answers

    You are creating a Power BI report that connects to a Microsoft Excel data source. How can you use a parameter named DS instead of a hard-coded copy of the location within your query definitions?

    <p>In the Power Query M code, replace references to the Excel file with the DS parameter.</p> Signup and view all the answers

    In a Power BI model with tables named Sales and Date, where the active relationship is on Sales[Due_Date], what actions could you take to calculate the number of orders by Ship_Date and Order_Date without duplicated data or additional loading?

    <p>Create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.</p> Signup and view all the answers

    You want to provide users with a sample of questions they can ask when using Q&A in a Power BI dashboard. What should you do?

    <p>Configure Datasets in Power BI Settings.</p> Signup and view all the answers

    In a Power BI model with tables named Sales and Customers, you run the RANKX(ALL(Customers), SUMX(RELATEDTABLE(Sales), [Sales_amount])) DAX formula. Does this action produce the desired outcome?

    <p>Yes, it does</p> Signup and view all the answers

    In a Power BI model with tables named Sales and Customers, if you run the RANK.EQ(Sales[Sales_amount], Customers[Customer_ID]) DAX formula, will this action produce the desired outcome?

    <p>No, it does not</p> Signup and view all the answers

    In a Power BI model with tables named Sales and Customers, if you run the RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customers), [Sales_amount])) DAX formula, will this action produce the desired outcome?

    <p>Yes, it does</p> Signup and view all the answers

    In a Microsoft Excel workbook with a Power Pivot model having relationships between Sales to Product and Sales to Salesperson, to create a report showing the count of products sold by each salesperson, what should you do?

    <p>Create a many-to-one relationship between Product and Salesperson.</p> Signup and view all the answers

    In a Power BI model for sales data, if you want to compare year-to-date sales with the previous year for the same time period, which DAX function should you use?

    <p>SAMEPERIODLASTYEAR</p> Signup and view all the answers

    When you have run two queries producing two different result sets that you want to concatenate into one query with all combined rows, what operation should you perform?

    <p>Append</p> Signup and view all the answers

    Study Notes

    Power BI Queries and Data Modeling

    • To prevent report recipients from reading analyzed emails, implement row-level security (RLS) or remove the Subject and Body columns during import, or set the Subject and Body columns to Hidden.
    • To create an ad analytics system, group impressions by Ad_id, Site_name, and Impression_date, and aggregate by using the CountRows function.
    • To surface training videos directly in a Microsoft Power BI dashboard, add a video tile.
    • To identify the percentage of empty values in each column, select the Column profile or Column quality option in Power Query Editor.
    • To ensure a prospective customer list contains records for each State/Region, select Column quality or Column distribution in Power Query Editor.

    Power Query and Data Transformation

    • To remove columns with a suffix of sourceid, use the Power Query M code to select the correct options.
    • To import attributes as columns from a JSON file, import the JSON file, then expand the JSON content, and finally select the required columns.
    • To merge two tables, use the Merge Queries option in Power Query Editor.
    • To create a query with one row per customer, merge the Customer and Address tables.

    Data Sources and Connections

    • To configure a dataset to easily change the data source between development, test, and production database servers, create a parameter and update the queries to use the parameter.
    • To analyze complaints by the logged date, change the data type of the Logged column to Date or apply a transformation to extract the date part.

    Performance and Optimization

    • To minimize the use of RELATED and RELATEDTABLE functions, split the model into multiple models or hide unused columns in the model.
    • To reduce the size of a data model, round the hour of a datetime column or split the column into two columns.
    • To improve the performance of a report, split the visuals onto multiple pages or change the imported dataset to DirectQuery.

    Power BI Service and Dashboards

    • To automate daily notifications of the number shown on a card visual, create a data alert or a subscription.
    • To grant users access to a dashboard, use the Viewer role on the workspace.
    • To share a dashboard, share the dashboard to the user or tag the user in a comment.

    Data Sampling and Import

    • To import a sample of data from a large table, add a filter step to the query in Power Query Editor or use a WHERE clause in the SQL statement.### Power BI Exam Questions

    Topic 1: Modeling Data

    • Creating a parameter named DataSourceExcel to hold the file name and location of a Microsoft Excel data source can meet the goal of updating the query to reference the parameter instead of multiple hard-coded copies of the location.
    • To import a sample of data from a large Microsoft SQL Server table named Order with more than 100 million records, adding a report-level filter that filters based on the order date can meet the goal.
    • Writing a DAX expression that uses the FILTER function can also meet the goal of importing a sample of data from the Order table.
    • To be notified when the daily percentage of defective products manufactured exceeds 3%, creating a subscription or an alert is the correct solution.

    Topic 2: Data Modeling

    • When creating a financial report in Power BI, preparing the data to support visualizations that include all measures in the data over time and year-over-year calculations for all measures requires several actions, including:
      • Unpivot the data
      • Create a date table
      • Create a relationship between the date table and the fact table
      • Add a measure for the year-over-year calculation
    • When implementing row-level security (RLS) in a data model, assigning the relevant distribution lists to each role and ensuring that the sales managers can view the sales records of their region and are prevented from viewing records from other regions is the correct configuration.
    • To write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents, using the FILTER function and respecting any slicers on ProductCategoryName is the correct solution.
    • When designing an imported dataset to support the analysis of sales data in a star schema, using the Auto Date/Time functionality in Microsoft Power BI and not importing the Date table is one possible solution.

    Topic 3: Visualization and Interactions

    • When using an R visual to produce a map of 500,000 customers, sending too many records to the visual can cause issues with the visual loading.
    • To see the total salary costs of the employees when hovering over a data point in a line chart, adding a salary to the tooltips or adding salary to the drillthrough fields are two possible ways to achieve this goal.
    • When setting visual interactions between a bar chart and a column chart, selecting filter as the interaction type can ensure that when a segment is selected in the bar chart, the column chart shows the corresponding portion of the total sales for the month.### Power BI Report Development
    • When building a dashboard for mobile phones, it's essential to consider the portrait mode and perform the following actions in sequence:
      • Create a custom CSS file to change the dashboard theme
      • Develop a report to help the sales team understand its performance and drivers of sales
      • Use a Key Influencers visualization to identify which factors affect success
      • Use a Funnel chart to show the sales process

    Visualization and Data Analysis

    • To create a visualization that shows the relationship between Unit Price and Quantity Ordered, use a scatter plot and the Cluster feature
    • To highlight orders that have a similar unit price and ordered quantity, use a scatter plot with the Cluster feature
    • To create a key influencers visualization, use the following configuration:
      • City as the Category
      • Total Sales as the Value
      • Occupation as the Filter
    • To show only the top 10 cities with the highest sales profit, add a Top N filter to the visual and configure the Sales Profit measure to use the RANKX function

    Reference Lines and Filtering

    • To create a reference line to show which employees are above the median salary, use a median line or a percentile line with the Salary measure
    • To create a reference line to show which employees are above the median salary, use a constant line and set the value to 0.5 (only applicable in certain scenarios)
    • To filter reports based on slicer selections, use report-level filters or sync the slicers across pages

    Data Visualization

    • To identify outliers in a table, use a scatter plot
    • To compare revenue and cost over time, use a line chart or a stacked area chart
    • To show a historic employee count and predict trends during the next six months, use a line chart or a ribbon chart

    Power BI Features and Navigation

    • To create a menu page that directs users to specific pages based on business questions, use a text box or button with a link or bookmark
    • To ensure that users can consume the content on a report page in a logical order, configure the tab order in Microsoft Power BI Desktop
    • To create a bookmark for each slicer value, use the bookmark feature in Power BI Desktop

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    DA-100 ExamTopics_Just Questions.pdf

    Description

    Practice questions for the DA-100 exam, covering custom connectors and data retrieval.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser