Skill cert 2 Flashcards
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.
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
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.
- Yes
- No
- Yes
- No
- Yes
- No
- Yes
- No
- 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
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
Pin the report to a dashboard
Share the dashboard.
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
Power Automate
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
- Canvas
- Control
- Theme
- Model-Driven
- Control
- Theme
- Portal
- Canvas
- Control
- Model-Driven
- Control
- Theme
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
Power Virtual Agent
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
connector
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
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.
Join action
Join action is to join an array of strings into a single string
Select action
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
Filter array
Filter Array action is for array size reduction based on provided filter criteria.
Create CSV table
Create CSV table action is for converting JSON array into a CSV table.
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.
- Yes
- Yes
- Yes
- No
- No
- No
- Yes
- Yes
- Yes
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.
- Yes
- No
- Yes
- No
2.yes - Yes
- No
2.yes - Yes
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
Field-level security feature to allow more granular control of security at the field level
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
Power Apps canvas apps
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
Prompt a user for consent to use their personal data and record the date consented
Block users who are identified as minors
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
Improve customer satisfaction
Enpower your team by creating Bots with no coding
educe support costs by automating Q&A
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
loop to check the directory on auto for file scanning and
IF conditions to check the new file add.
What is default environment
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.
What is sandbox environment
non production environment
features copy and reset
developing a testing
restricted to admin
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
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.
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
Trigger Phrases
Authoring a topic means creating a new PVA topic and setting the trigger phrases which will be used to trigger the topic.
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
Analyze
Automate
Act
Select below two types of objects Power Platform Connectors provides
Function-based
Tables
Notification
Power BI
Actions
Sending email
tables
actions
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
Azure Analysis Services
Azure API Management
Azure Bot Service
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
NO
only model-driven apps can show or hide, enable or disable form fields based on business rules
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
Manual
URL
Pass-Through
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
Forms
Views
Charts
