--> Sayadasite: Multiple Choice Questions Artificial Intelligence –AI-900

Multiple Ads

Search

Menu Bar

Multiple Choice Questions Artificial Intelligence –AI-900

 

1)                  What is the common flow of activity in Power BI?

a)                  Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

b)                 Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

c)                   Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI

mobile.

d)                 Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

 

2)                  Which of the following are building blocks of Power BI?

a)                  Tiles, dashboards, databases, mobile devices.

b)                 Visualizations, datasets, reports, dashboards, tiles.

c)                   Visual Studio, C#, and JSON files.

d)                 All of the above

 

53) A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?

a)                  The canvas.

b)                 Scheduled refresh.

c)                   An app.

d)                 All of the above

 

54) What type of expression do you use to extract data from Microsoft SQL Server?

a)                  DAX

b)                 T-SQL

c)                   MDX

d)                 All of the above

 

55) You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?

a)                  Import

b)                 T-SQL

c)                   Live connection

d)                 All of the above

 

56) What can you do to improve performance when you're getting data in Power BI?

a)                  Use query folding

b)                 Only pull data into the Power BI service, not Power BI Desktop

c)                   Use the Select SQL statement in your SQL queries when you're pulling data from a relational database.

d)                 Combine date and time columns into a single column

 

57) What is a risk of having null values in a numeric column?

a)                  That function SUM of data will be incorrect.

b)                 That function MAX of data will be incorrect.

c)                   That function AVERAGE of data will be incorrect.

d)                 All of the above

 

58) If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

a)                  Append

b)                 Merge

c)                   Combine Column

d)                 All of the above

 

59) Which of the following selections are not best practices for naming conventions in Power BI?

a)                  Rename columns to have spaces in them.

b)                 Abbreviate column names.

c)                   Replace values that have integers with human readable results.

d)                 All of the above

 

60) What does data granularity mean?

a)                  Data granularity is the filter direction that is associated with the relationship between two columns.

b)                 Data granularity is the level of detail that is represented in the data.

c)                   Data granularity is a many-to-many relationship.

d)                 Data granularity is a type of schema design.

 

61) What is the difference between a fact table and a dimension table?

a)                  Fact tables contain observational data while dimension tables contain information about specific entities within the data.

b)                 Fact tables contain information about specific entities while dimension tables contain information about observational data.

c)                   There is no difference.

d)                 Dimension tables tell you about specific roles in Power BI while fact tables tell you information about facts that are associated with those roles in Power BI.

 

62) What is cardinality?

a)                  Cardinality is the measure of unique values in a table.

b)                 Cardinality is the granularity of the data.

c)                   Cardinality is how long it takes for the data to load.

d)                 Cardinality is a type of visual element.

 

63) Which two functions will help you compare dates to the previous month?

a)                  CALCULATE and PREVIOUSMONTH

b)                 TOTALYTD and PREVIOUS MONTH

c)                   CALCULATE and TOTALTYD

d)                 All of the above

 

64) Why would you want to override the default context?

a)                  To create measures that behave according to your intentions, regardless of what the user selects.

b)                 To create measures that do not summarize or average.

c)                   To create new relationships.

d)                 All of the above

 

65) How do you use an inactive relationship in a single measure?

a)                  Change the active relationship in the Modeling tab.

b)                 Use the USERELATIONSHIP function.

c)                   Delete one relationship.

d)                 All of the above

 

66) What benefit do you get from analyzing the metadata?

a)                  The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

b)                 The benefit of analyzing the metadata is to get familiar with your data.

c)                   The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model.

d)                 All of the above

 

67) What can be achieved by removing unnecessary rows and columns?

a)                  It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

b)                 Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model.

c)                   Deleting unnecessary rows and columns can damage the structure of the data model.

d)                 All of the above

 

68) Is it possible to create a relationship between two columns if they are different DATA TYPE columns?

a)                  Yes, if cardinality of the relationship is set to Many-to-Many.

b)                 No, both columns in a relationship must be sharing the same DATA TYPE.

c)                   Yes, the above is fully supported in latest version of Power BI desktop.

d)                 All of the above

 

69) What is the benefit of using a report tooltip?

a)                  To give users additional information about a report visual, such as the author and date/time it was created.

b)                 To provide additional detail that is specific to the context of the data that is being hovered over.

c)                   To give users the ability to export data from the visual.

d)                 All of the above

 

70) Which of the following options isn't one of the four components in the Q&A visualization?

a)                  The question box, where users enter their question and are shown suggestions to help them complete their question.

b)                 Automatic creation of a custom tooltip

c)                   An icon that users can select to convert the Q&A visual into a standard visual.

d)                 An icon that users can select to open Q&A tooling, which allows designers to configure the underlying natural language engine.

 

71) Do you need to import custom visuals each time you want to use them when you're developing a new report, not an existing report?

a)                  No, custom visuals are always available for selection under the Visualization pane.

b)                 Yes, custom visuals must be imported from AppSource each time you start developing a new report.

c)                   No, custom visuals only need to be imported once and will always remain in Power BI for future

d)                 All of the above

 

72) Which of the following filters are not available in Power BI reports?

a)                  Drillthrough

b)                 Page type

c)                   Report level

d)                 Page level

 

73) How can you analyze performance of each of your report elements?

a)                  By analyzing your metadata

b)                 By using performance analyzer

c)                   By deleting unnecessary rows and columns to reduce your dataset size

d)                 All of the above

 

74) Can you use bookmarks to create a slide show in Power BI?

a)                  No, you cannot, because bookmarks are not dynamic.

b)                 Yes, you can, by adding buttons as navigation to go between saved bookmarks.

c)                   No, you will require a specific visual to achieve this task.

d)                 All of the above

 

75) What is a dashboard?

a)                  A canvas of report elements that can be built in Power BI Desktop

b)                 A canvas of report elements that can be built in Power BI service

c)                   Dashboards can be built by using visuals that are developed with an underlying data source.

d)                 The canvas in which you can view the data model of a report

e)                  What is one way that reports and dashboards differ?

 

76) They are the same

a)                  In reports, you can use the slicers and filter by selecting a data point on a visual; in dashboards, you cannot.

b)                 In reports, you can have multiple pages; in dashboards, you can have only one page.

c)                   You can only build reports and dashboards in Power BI service.

 

77) Where can you configure and set data alerts?

a)                  Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.

b)                 Data alerts can be set in both Power BI service and Power BI Desktop on any kind of visual.

c)                   Data alerts can be set in Power BI service on any kind of visual.

d)                 Data alerts can be set only in Power BI Desktop on specific kinds of visuals such as KPI cards and gauges.

 

78) Why are parameters important in Power BI paginated reports?

a)                  They allow the report developer to control the refresh interval of the report.

b)                 They allow the user to control aspects of how the report is rendered when the report is run.

c)                   They are required so that Power BI can call the paginated report.

d)                 All of the above

 

79) Power BI paginated reports are created by using which tool?

a)                  Power BI Desktop

b)                 Power BI service

c)                   Power BI Report Builder

d)                 All of the above

 

80) Power BI paginated reports is an evolved technology that was built from which original tool?

a)                  SQL Server Analysis Services

b)                 SQL Server Reporting Services

c)                   Microsoft SharePoint

d)                 All of the above

 

81) What Power BI feature can give an in-depth analysis of the distribution of data?

a)                  The Next Level of Hierarchy feature can give in-depth analysis because it will allow you to drill down for all subcategories and is not used to analyze the distribution.

b)                 The Analyze feature allows a user to understand why the distribution looks the way that it does.

c)                   Only time series analysis can provide in-depth analysis on the data.

d)                 All of the above

 

82) Where are time series charts located?

a)                  The filter pane is where all filters on visuals and pages are located.

b)                 Time series charts can be imported from AppSource.

c)                   The field’s pane is where all charts are located.

d)                 All of the above

 

83) What visual should be used to display outliers?

a)                  The line chart is best-suited to display outliers.

b)                 The scatter chart is best-suited to display outliers.

c)                   The clustered column chart is best-suited to display outliers.

d)                 All of the above

 

84) What does the AI splits feature do?

a)                  AI splits work by considering all available fields and determining which one to drill into and will only return the highest or lowest value within your dataset.

b)                 AI splits work by considering all available fields and determining which one to drill into to get the highest/lowest value of the measure that is being analyzed.

c)                   AI splits only display the difference between highest and lowest value of the measure that is being analyzed.

d)                 All of the above

 

85) Can you access the Q&A feature by using buttons?

a)                  No, to use the Q&A feature, you will need to add the Q&A visual to your reporting canvas.

b)                 Yes, you can access the Q&A feature by selecting Q&A button type.

c)                   Yes, you can, but you will need to add the Q&A visual to your reporting canvas and then link your button with the visual that you have added.

d)                 All of the above

 

86) Which of the following selections is NOT a feature of the Q&A visual?

a)                  Adding new synonyms to fields through Q&A tooling.

b)                 Converting a Q&A answer into a visual inside your report.

c)                   Searching for help topics about Power BI.

d)                 All of the above

 

87) How is the Admin workspace role different from other types of workspace roles?

a)                  Admin is the only role that can remove users.

b)       Admin is the only role that can publish or update apps.

c)                   Admin is the only role that can create, edit, or delete content in a workspace.

d)                 Admin is the only role that can publish content to a workspace.

 

88) Which one of the following options is the best description of a workspace?

a)                  A workspace is a feature in Power BI service that allows you to view reports only.

b)                 A workspace is a feature of Power BI Desktop that allows you to build reports only.

c)                   A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, and so on.

d)                 A workspace is a feature that allows you to view and edit the data model, build visualizations, and transform the data.

 

89) What feature in Power BI service can you use to troubleshoot the flow of data from its source to its destination?

a)                  Usage Metrics report

b)                 Query Caching

c)                   Quick Insights

d)                 Lineage view

 

90) Where are dataset-scheduled refreshes configured?

a)                  Power BI service

b)                 Power BI Desktop

c)                   AppSource

d)                 All of the above

 

91) What reserved parameters configure the start and end of where Incremental refresh should occur?

a)                  Start and End parameters

b)                 StartRange and EndRange

c)                   RangeStart and RangeEnd

d)                 All of the above

 

92) What is the difference between Promotion and Certification when you are endorsing a dataset?

a)                  Promotion requires write access while Certification requires permission from the dataset owner to access to the dataset.

b)                 Promotion is for broad usage while Certification needs permission granted on the Admin Tenant settings.

c)                   Promotion is for specific users while Certification needs permission granted on the Admin Tenant settings.

d)                 All of the above

 

93) Which function will tell you the username of the person who is signed in to Power BI service?

a)                  USERPRINCIPALNAME()

b)                 LOOKUPVALUE()

c)                   USEROBJECTID()

d)                 All of the above

 

94) Where can you test RLS by using different security roles?

a)                  Power BI Desktop only

b)                 Power BI service only

c)                   Both Power BI Desktop and Power BI service

d)                 All of the above

 

95) You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app. Which connector should you select?

a)                  Microsoft Teams Personal Analytics

b)                 SQL Server database

c)                   Dataverse

d)                 Dataflows

 

96) You are designing an AI system that empowers everyone, including people who have hearing, visual, and other impairments. This is an example of which Microsoft guiding principle for responsible AI?

a)                  fairness

b)                 inclusiveness

c)                   reliability and safety

d)                 accountability

 

97) You are building an AI system. Which task should you include to ensure that the service meets the Microsoft transparency principle for responsible AI?

a)                  Ensure that all visuals have an associated text that can be read by a screen reader.

b)                 Enable auto scaling to ensure that a service scales based on demand.

c)                   Provide documentation to help developers debug code.

d)                 Ensure that a training dataset is representative of the population.

 

98) A company employs a team of customer service agents to provide telephone and email support to customers. The company develops a webchat bot to provide automated answers to common customer queries. Which business benefit should the company expect as a result of creating the web chat bot solution?

a)                  increased sales

b)                 a reduced workload for the customer service agents

c)                   improved product reliability

d)                 Set Primary metric to accuracy

 

99) You build a machine learning model by using the automated machine learning user interface (UI). You need to ensure that the model meets the Microsoft transparency principle for responsible AI. What should you do?

a)                  Set Validation type to auto.

b)                 Enable Explain best model.

c)                   Set Primary metric to accuracy.

d)                 Set Max concurrent iterations to 0.

 

100) What are three Microsoft guiding principles for responsible AI? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

a)                  knowledgeability

b)                 decisiveness

c)                   inclusiveness

d)                 opinionatedness

 

101) Which two components can you drag onto a canvas in Azure Machine Learning designer? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

a)                  dataset

b)                 compute

c)                   pipeline

d)                 modeling

 

102) For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?

a)                  Power BI dataset

b)                 a SharePoint folder

c)                   Power BI dataflows

d)                 an Excel workbook

 

103) You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint 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 and use a built-in date hierarchy. What should you do?

a)                  Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

b)                 Change the data type of the Logged column to Date.

c)                   Split the Logged column by using at as the delimiter.

d)                 Apply a transformation to extract the first 11 characters of the Logged column.

 

104) You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset can be refreshed in powerbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

a)                  Web

b)                 Text/CSV

c)                   Folder

d)                 SharePoint folder

 

105) You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.How should you configure the data connection?

a)                  Add a SQL statement.

b)                 Set the Command timeout in minutes setting.

c)                   Set Data Connectivity mode to Import.

d)                 Set Data Connectivity mode to Direct Query.

 

106) 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?

a)                  video

b)                 custom streaming data

c)                   text box

d)                 web content

 

107) You open a query in Power Query Editor.You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

a)                  Show whitespace

b)                 Column profile

c)                   Column distribution

d)                 Column quality

 

108) For a machine learning progress, how should you split data for training and evaluation?

a)                  Use features for training and labels for evaluation.

b)                 Randomly split the data into rows for training and rows for evaluation. Most Voted

c)                   Use labels for training and features for evaluation.

d)                 Randomly split the data into columns for training and columns for evaluation.

 

109) You build a machine learning model by using the automated machine learning user interface (UI).You need to ensure that the model meets the Microsoft transparency principle for responsible AI. What should you do?

a)                  Set Validation type to Auto.

b)                 Enable Explain best model.

c)                   Set Primary metric to accuracy.

d)                 Set Max concurrent iterations to 0.

 

110) SQL Stand For

a)                  Structure Query Language

b)                 Simple Query Language

c)                   Stand Query Language

d)                 Stack Queue Language

 

111) AI stands for

a)                  Artificial Intelligence

b)                 All information

c)                   Art Information

No comments: