DA-100 practice questions
You plan to run a script as an experiment using a Script Run Configuration. The script uses modules from the scipy library as well as several Python packages that are not typically installed in a default conda environment. You plan to run the experiment on your local workstation for small datasets and scale out the experiment by running it on more powerful remote compute clusters for larger datasets. You need to ensure that the experiment runs successfully on local and remote compute with the least administrative effort. What should you do?
A. Do not specify an environment in the run configuration for the experiment. Run the experiment by using the default environment.
B. Create a virtual machine (VM) with the required Python configuration and attach the VM as a compute target. Use this compute target for all experiment runs.
C. Create and register an Environment that includes the required packages. Use this Environment for all experiment runs.
D. Create a config.yaml file defining the conda packages that are required and save the file in the experiment folder.
E. Always run the experiment with an Estimator by using the default packages.
Discussion forum
Question
This question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the recommendation satisfies the requirements. You are in the process of carrying out feature engineering on a dataset. You want to add a feature to the dataset and fill the column value. Recommendation: You must make use of the Group Categorical Values Azure Machine Learning Studio module. Will the requirements be satisfied?
A. Yes
B. No
Discussion forum
Question
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
Discussion forum
Question
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?
A. no impact
B. highlight
C. filter
Discussion forum
Question
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.
Discussion forum
Question
You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue?
A. The visual was built by using a different version of R.
B. The data comes from a Microsoft SQL Server source.
C. The data is deduplicated.
D. Too many records were sent to the visual.
Discussion forum
Question
You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers. You need to ensure that the users can get a useful result for “subscriber count” by using Q&A. The solution must minimize the size of the model. What should you do?
A. Set Summarize By to None for the CustomerID column.
B. Add a synonym of “subscriber” to the Customer table.
C. Add a synonym of “subscriberID” to the CustomerID column.
D. Add a description of “subscriber count” to the Customer Count measure.
Discussion forum
Question
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = “Kentucky” Role2 contains the following filter. Date[Calendar Year] = 2020 – If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
A. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
B. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
C. The user will see only data for which the State Province value is Kentucky.
D. The user will receive an error and will not be able to see the data in the report.
Discussion forum
Question
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.
Discussion forum
Question
You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do?
A. Change the Microsoft Power BI license type of the sales manager.
B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
C. Request that the sales manager be added to the correct Azure Active Directory group.
D. Manage the permissions of the underlying dataset.
Discussion forum
Question
✑ A KPI visual that shows the current daily percentage of defective products manufactured. You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create?
A. a Q&A visual
B. a subscription
C. a smart narrative visual
D. an alert
Discussion forum
Question
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You write a DAX expression that uses the FILTER function. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You create a new query that references DataSourceExcel. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You modify the source step of the queries to use DataSourceExcel as the file path. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question