Skill cert 2 Flashcards

1
Q

You are a district manager for a large retail organization. You train each store manager to use Power BI to track sales and daily sales targets. A store manager remembers learning about the Analyze in Excel option but cannot find the option in their Power BI dashboard. You need to help the user resolve the issue. How should you advise the user?Install the

Power BI Desktop app.
Select the Spotlight button on the dashboard tile.
Subscribe to the dashboard and follow the email link.
Navigate to the report used by the dashboard.

A

Navigate to the report used by the dashboard.

In power service look for the report and search for analyze in excel, it downloads the semantic model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You have a Power BI report.
For the following statements, select the correct combination of Yes and No‘s from the answers.
1. You can export from visualization in a Power BI report.
2. You can show a data behind the visual report on your screen without exporting the data.
3. You can export data to view supporting data for a KPI.

  1. Yes
  2. No
  3. Yes
  4. No
  5. Yes
  6. No
A
  1. Yes
  2. No
  3. Yes

If you‘d like to see the data that Power BI uses to create a visualization, you can display that data in Power BI. You can also export that data to Excel as a .xlsx or .csv file. The option to export the data requires a Pro or Premium license and edit permissions to the dataset and report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel workbook. Users need to be able to view and share the report. Which two actions should you perform?

Pin the report to a dashboard
Export the data.
Publish the dashboard.
Share the dashboard

A

Pin the report to a dashboard

Share the dashboard.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You manage the support team at a rapidly growing company. Support technicians need a better experience when logging and responding to support requests. You need to recommend tools to help the company‘s needs. Which tools should you recommend?
Support technicians must be notified when a new support request is entered ________

Power Apps
Power Automate
Power BI
Microsoft Dataverse

A

Power Automate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You are a retail director for a large clothing company. Each week you use the corporate YouTube channel to create a video that highlights new initiatives, and goals for retail operations. You need to design a Power Apps app that streams the videos to internal users. Which objects should you use?
1. Implement the Power Apps app
2. Use drag and drop the Video to the app
3. Apply consistent company colors to the app

  1. Canvas
  2. Control
  3. Theme
  4. Model-Driven
  5. Control
  6. Theme
  7. Portal
  8. Canvas
  9. Control
A
  1. Model-Driven
  2. Control
  3. Theme
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Your company wants to create a help desk system and implement Dynamics 365 Customer Service. The company has the following requirements:
Provide an application to allow support team staff to chat live with a customer.
Automatically import data from a Microsoft Excel spreadsheet once a day.
Provide a chatbot that can assist customers who need support.
You need to determine which applications to use to meet the requirements. Which applications should you use?
1. Automatically import data from a Microsoft Excel spreadsheet once a day
2. Provide a chatbot that can assist customers who need support

Custom Connector
Azure Data Lake
Power Automate
Power Virtual Agent
Power BI
Power Virtual Agent

A

Power Virtual Agent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You are learning about Power Apps and how to use triggers. Which objects should you use?
When a condition is met, Power Apps app can trigger a ________

Connector
Power automate flow
gateway
solution

A

connector

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You create a Power Automate Process and need to enter the same data several times. What action should you select to store and reuse this data in your workflow?

Join
Compose
Select
Filter array
Create CSV Table

A

Compose

because when you create a automated process in Power Automate, you select the next step and search for Data Operation Compose action and action Compose helps to store and reuse the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Join action

A

Join action is to join an array of strings into a single string

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Select action

A

Select action is transform data by mapping from the input to the output.
This action can be used to rename an element in each object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Filter array

A

Filter Array action is for array size reduction based on provided filter criteria.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Create CSV table

A

Create CSV table action is for converting JSON array into a CSV table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A company plans to build Power Apps portals.
For the following statements, select the correct combination of Yes and No‘s from the answers.
1. You must use standard templates for-building portals.
2. You can test portals in non-production environments and then migrate the portals into production environments.
3. When transitioning to, the new version of a-portal, you can display a customizable maintenance page until the new portal is ready to be used.

  1. Yes
  2. Yes
  3. Yes
  4. No
  5. No
  6. No
A
  1. Yes
  2. Yes
  3. Yes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You are creating a model-driven app.
For the following statements, select the correct combination of Yes and No‘s from the answers.
1. To add entities to an app, entities are dragged onto the app canvas from the components area.
2. A view definition is created in the component area of the app designer.
3. You must save, validate, and publish your app for others to see the changes.

  1. Yes
  2. No
  3. Yes
  4. No
    2.yes
  5. Yes
A
  1. No
    2.yes
  2. Yes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You create a canvas app that allows contractors to submit the time they work against a project. Contractors must be able to use the canvas app to enter time. Contractors must not be able to perform any other actions in the app. You need to configure permissions for the contractors. Which type of permissions should you use?

application-level
task-level
record-level
field-level

A

Field-level security feature to allow more granular control of security at the field level

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A company uses Dynamics 365 Supply Chain Management.
The company wants to build custom user interfaces that add additional functionality.
You need to recommend a solution for the company.
What should you recommend?

Power BI
Power Apps canvas apps
AI Builder
Microsoft Flow

A

Power Apps canvas apps

17
Q

Company‘sCustomer-facing applications must comply with Global Data Protection Regulations (GDPR). You need to recommend actions to help ensure GDPR compliance.
Which two features should the company use?

Force a user to update security questions after a specific amount of time
Prompt a user for consent to use their personal data and record the date consented
Block users who are identified as minors
Automatically deactivate a user who has not used the portal in six months

A

Prompt a user for consent to use their personal data and record the date consented
Block users who are identified as minors

18
Q

Explain to the Senior management team, how can Power Virtual Agent help the organization and its customers.
Select three items from the options.

Improve customer satisfaction
PVA can be used to create Power Apps quicker
Empower your team by creating Bots with no coding
Deliver dashboards and reports to the end user
Reduce support costs by automating Q&A
Create powerful visuals for model-driven apps

A

Improve customer satisfaction

Enpower your team by creating Bots with no coding

educe support costs by automating Q&A

19
Q

You create a Power Automate Desktop Flow which monitors a directory with files. When an Excel file with the name “new-file-1“ is added to this directory, the flow opens it in Excel.
What two actions will you use for this flow?

Loop
Switch
If

A

loop to check the directory on auto for file scanning and

IF conditions to check the new file add.

20
Q

What is default environment

A

Special type of production environment. Each tenant has a default environment created automatically

All users have environmental maker role

1T of storage capacity

Users are able to create and edit Power Apps canvas apps.

21
Q

What is sandbox environment

A

non production environment
features copy and reset
developing a testing
restricted to admin

22
Q

You updated your chatbot and published it again within the Power Virtual Agents app. The bot has already been exposed to five channels. Do you need to reconnect a new version of the bot with each channel?

Yes
No

A

Yes

When you publish a new version of the existing chatbot connected to several channels, you don‘t need to reconnect a new version with each channel. Power Virtual Agents app will do this automatically after publishing.

23
Q

What does authoring a topic mean for the Power Virtual Agents (PVA) Bot?
Select from below what are you actually creating.

Entities
Intents
Trigger Phrases
Publishing a PVA Bot
Channels

A

Trigger Phrases

Authoring a topic means creating a new PVA topic and setting the trigger phrases which will be used to trigger the topic.

24
Q

What are the Power Platform key actions you can perform on data to help users to drive their business? Select three options.

Analyze
Integrate
Automate
Build
Act

A

Analyze
Automate
Act

25
Q

Select below two types of objects Power Platform Connectors provides

Function-based
Tables
Notification
Power BI
Actions
Sending email

A

tables
actions

26
Q

Select all the Azure services that Power Platform consumes.

Azure Advisor
Azure Analysis Services
Azure Monitor
Azure API Management
Azure Bot Service
Azure Security Cente

A

Azure Analysis Services
Azure API Management
Azure Bot Service

27
Q

You are trying to explain the benefits of the Dataverse (Common Data Service) business rules to your manager. He asked you about an application of the business rules to the Power Apps form. Can a canvas app show or hide form fields based on a business rule?

Yes
No

A

NO

only model-driven apps can show or hide, enable or disable form fields based on business rules

28
Q

You are editing a BI report with drill-down visualization. You want to remove all filters and some new ones.
Please select all filters that you can delete from the report.

Manual
Automatic
URL
Drill-down
Pass-Through

A

Manual
URL
Pass-Through

29
Q

You are creating a model-driven app. Select all entity assets that you can use for the building of your app.

Forms
Dashboards
Entities
Views
Business Process Flow
Charts

A

Forms
Views
Charts

30
Q
A