DumpsFree provides high-quality dumps PDF & dumps VCE for candidates who are willing to pass exams and get certifications soon. We provide dumps free download before purchasing dumps VCE. 100% pass exam!

Verified MB-280 dumps Q&As 100% Pass in First Attempt Guaranteed Updated Dump from DumpsFree [Q33-Q57]

Share

Verified MB-280 dumps Q&As 100% Pass in First Attempt Guaranteed Updated Dump from DumpsFree

Pass Microsoft Certified MB-280 Exam With  123 Questions


Microsoft MB-280 Exam Syllabus Topics:

TopicDetails
Topic 1
  • Implement Dynamics 365 Sales: This section focuses on the essential processes for setting up and managing Dynamics 365 Sales effectively for Dynamics 365 Sales Professionals.
Topic 2
  • Demonstrate Dynamics 365 Customer Insights Capabilities: This section focuses on leveraging customer data to drive sales strategies through Dynamics 365 Customer Insights.
Topic 3
  • Implement Security and Customizations in Dynamics 365 Sales: This section addresses the implementation of security measures and customization options within Dynamics 365 Sales for Dynamics 365 Sales Professionals.

 

NEW QUESTION # 33
Hotspot Question
You are a Dynamics 365 Sales administrator. You set the fiscal year to begin in January.
A sales manager needs a monthly forecast for the next three years that starts in August of the next year.
You need to configure the forecast using the fewest number of forecasts.
How should you configure each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:
How many forecasts are needed? - 1
Since the requirement is for a continuous forecast spanning three years, a single forecast covering the entire period is the most efficient option.
What is the starting period for the forecast? - Next year
The forecast must start in August of the next year, so selecting "Next year" ensures that the forecast starts in the correct timeframe.
How many periods are needed? - 36
The forecast is monthly for three years. Since there are 12 months per year, the total number of periods required is 36 months.


NEW QUESTION # 34
Hotspot Question
You use opportunities in Dynamics 365 Sales.
Opportunities that were closed as lost frequently come back and are eventually won.
You need to be able to track these occurrences and have insight into the process.
What happens during the reopen and close process? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:
A lost opportunity is reopened - The Opportunity Close record changes status to In Progress.
When a lost opportunity is reopened, the system updates its status to In Progress rather than deleting or inactivating the existing Opportunity Close record. This allows tracking of re- engagement with the opportunity.
The same opportunity is closed as won - A new Opportunity Close record is created with the new close details and status of completed. When the opportunity is closed as won, a new Opportunity Close record is created to maintain historical tracking. This helps in tracking multiple closure attempts, ensuring past losses and final wins are recorded separately.


NEW QUESTION # 35
You are using a forecast template.
You must configure the forecast by territory.
You need to configure the forecast parameters.
Which parameter should you configure?

  • A. Hierarchy table
  • B. Rollup table
  • C. Top of hierarchy
  • D. Hierarchy relationship

Answer: D

Explanation:
Define a forecast model
Define the entities that must be used to generate the forecast.
1. In the General step of the Forecast configuration page, define the fields that should be used for the forecast.
[Steps 2 to 6 omitted]
7. Select a Rollup to hierarchy relationship.
This step establishes a relationship between the rollup and hierarchy entities. Each forecast template starts with a default rollup to hierarchy relationship:

Choose different values to support your organization's specific requirements if needed.
Note: Select a template
The fastest way to create a forecast is to use a template. The template that you select defines how the forecast groups data.
On the Forecast configurations page, select one of the following templates:
Org chart forecast: Rollup columns and projections are based on your organization's reporting structure. This template uses the Manager field of the User entity for the hierarchy.
Product forecast: Rollup columns and projections are based on the product hierarchy.
*-> Territory forecast: Rollup columns and projections are based on the sales territory hierarchy.
Reference:
https://learn.microsoft.com/en-us/dynamics365/sales/define-general-properties-scheduling-forecast


NEW QUESTION # 36
You have opportunities that have values in multiple currencies. You manually update currency exchange rates once per month. You need to ensure that currency values are accurately reported. When is the new currency exchange rate applied to the opportunity records?

  • A. When an opportunity changes the status reason.
  • B. When the calculate rollup field system job for the msdyn_projectteam table runs.
  • C. When an opportunity changes the status.
  • D. When the calculate rollup field system job for the account table runs.

Answer: A

Explanation:
* In Dynamics 365 Sales, currency exchange rates are applied to opportunity records when specific triggers occur. These exchange rates are updated manually on a periodic basis (e.g., once a month) to reflect current currency values.
* Exchange rates are recalculated for an opportunity when there is a change in the status reason (e.g., from open to won or lost). This trigger ensures that the most recent exchange rate is used when key changes occur in the opportunity lifecycle, maintaining accurate currency reporting.


NEW QUESTION # 37
A company created a new table named Locations.
The sales team needs your help to make the Locations table visible in the Sales Hub. What should you do?

  • A. Add Location to the App Designer.
  • B. Create a Location Group.
  • C. Add Location as an Area.
  • D. Create a Location Sub Area.

Answer: A

Explanation:
* To make a new table, like Locations, visible within the Sales Hub, you need to add it to the App Designer. This involves updating the Sales Hub app module to include the Locations table as a new entity that users can access.
* By adding the table in the App Designer, you ensure it becomes part of the navigation and is available within the Sales Hub application.


NEW QUESTION # 38
Your company wants to enable Al features in their systems and use Copilot for Sales to connect to Dynamics 365 Sales dat a. You need to ensure that all eligible users have access.
Which three actions should you perform? Each correct answer presents part of the solution. Choose three. NOTE: Each correct selection is worth one point.

  • A. Install Copilot for Sales in Microsoft Outlook.
  • B. Enable Copilot for Sales in Dynamics 365.
  • C. Assign users the correct privileges to use Copilot for Sales in Teams.
  • D. Create a policy in Teams to install and pin Copilot for Sales and enable meeting transcripts.
  • E. Verify server-side synchronization is enabled and users have the correct security roles in Dynamics 365.

Answer: B,C,E

Explanation:
Enable Copilot for Sales in Dynamics 365:
To make Copilot features available, you must enable Copilot for Sales within Dynamics 365. This involves setting up the environment so that Copilot can access and utilize the sales data effectively.
Verify Server-Side Synchronization and Security Roles:
Copilot for Sales relies on server-side synchronization to ensure data flow between Dynamics 365 and other services, such as Teams. Ensure that server-side synchronization is enabled and that users have the necessary security roles in Dynamics 365 to access and use Copilot.
Assign Privileges for Copilot in Teams:
Ensure that users have the correct privileges within Teams to access Copilot. This might involve configuring access policies and permissions so that eligible users can utilize Copilot features during their interactions within Teams.


NEW QUESTION # 39
Hotspot Question
Both your sales and marketing teams use Dynamics 365 applications to conduct campaigns with customers.
Leadership has asked for sales and marketing campaigns to have parent campaigns applied so the combined success of sales and marketing efforts can be measured, along with each division's own success. They want the campaign hierarchy to be clear to users so they can see a "Parent Campaign" relationship. Any actions taken on parent records should automatically be taken on child records.
You need to update table relationships to enable the requirements using the minimum amount of configuration steps.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct match is worth one point.

Answer:

Explanation:

Explanation:
Box 1: Campaign
Table, Related (Many)
Hierarchical relationships are self-referential one-to-many relationships.
In this case from the Campaign table, to the Campaign table.
Example:

Box 2: Child campaign
Lookup column display name
Self-referential means that the table is related to itself. For example, the account table has a lookup column to associate it with another account table row.
The Parent table is on the 1-side of the 1-M relation, and it refers to Child Campaign with the Lookup column.
Box 3: Configurable Cascading
Relationship behavior, Type of behavior
Any actions taken on parent records should automatically be taken on child records.
When a one-to-many entity relationship exists there are cascading behaviors that can be configured to preserve data integrity and automate business processes.
Note: Parental entity relationships
Each pair of entities that are eligible to have a 1:N relationship can have multiple 1:N relationships between them. Yet only one of those relationships can be considered a parental entity relationship.
A parental entity relationship is any 1:N entity relationship where one of the cascading options (defined in CascadeType) in the Parental column of the following table is true.


NEW QUESTION # 40
A company created a new table named Locations.
The sales team needs your help to make the Locations table visible in the Sales Hub.
What should you do?

  • A. Add Location to the App Designer.
  • B. Create a Location Group.
  • C. Add Location as an Area.
  • D. Create a Location Sub Area.

Answer: A

Explanation:
To make a new table, such as Locations, visible in the Sales Hub, you need to modify the app using the App Designer in Dynamics 365. By adding the Locations table to the Sales Hub via the App Designer, you ensure that users in the Sales Hub can access and interact with the Locations data directly within the application.


NEW QUESTION # 41
An organization is using Microsoft Power Query when connecting to data sources in Dynamics
365 Customer Insights - Data.
You need to load contacts to Customer Insights - Data using Power Query.
Which is an appropriate action to take when using Power Query to ingest data?

  • A. You can add additional tables to the data source using Get Data functionality in the Power Query.
  • B. You can only add additional columns to the dataset in Power Query before the data source is created in Customer Insights - Data.
  • C. After you save a Power Query data source, you have to manually trigger the initial refresh process.
  • D. You must create a separate Power Query data source for each table you wish to ingest.

Answer: A

Explanation:
When using Power Query in Dynamics 365 Customer Insights - Data, you have the flexibility to add additional tables to your data source through the Get Data functionality. This allows you to manage multiple tables and sources efficiently within a single Power Query environment.


NEW QUESTION # 42
Your organization works with larger customers (accounts) that can have a single holding and then many subsidiaries through different levels in a parent-child relationship.
The chief commercial officer wants the sales team to start creating different account plans for each individual subsidiary.
You need to create a new custom account plan table so that records can have the same parent-child relationships as the account records. The relationships must be able to be visualized in a hierarchy.
Which four actions should you perform in sequence before saving and publishing your changes' To answer, move the four appropriate actions from the list of actions to the answer are a. Arrange the four actions in the correct order.

Answer:

Explanation:

Reference:
Create a 1
Self-Referential Relationship and Mark It as Hierarchical:
Establish a self-referential relationship within the Account Plan table where one record can be linked to another within the same table. Choose a 1 relationship type, where one parent account plan can have multiple subsidiary account plans.
Mark this relationship as hierarchical to enable visual representation of the hierarchy. This is essential for tracking parent-subsidiary structures in a hierarchical view.
Open the Advanced Relationship Settings:
After setting up the hierarchical relationship, go to the Advanced Relationship Settings. This allows you to fine-tune options related to cascading behavior, which will control how changes in parent records impact related child records.
Go to the Hierarchy Settings Grid View:
Finally, navigate to the Hierarchy Settings to configure the visualization settings for this relationship. The Hierarchy Settings will enable you to define how the hierarchy is displayed, allowing users to see the parent-child relationships clearly.
Once configured, publish the changes so that users can access the hierarchical view within the system.
By following these steps, you will have configured the new custom account plan table with hierarchical visualization, meeting the requirements to manage and display complex parent-child relationships within your Dynamics 365 system.


NEW QUESTION # 43
A company has two departments. Each department uses only custom forms and views designed for each department. Currently, all users can view all forms and views.
The company wants to improve usability for its users.
You need to limit users to only individual department forms and views.
What should you do?

  • A. Add an area for each department within the site map
  • B. Use a hierarchy security model.
  • C. Create a model-driven app for each department.
  • D. Use security roles.

Answer: D

Explanation:
In Dynamics 365 Sales, security roles control access to different forms, views, and records. To ensure that each department can only access their respective custom forms and views, you should assign security roles to the forms and views. This allows you to restrict users based on their department so they only see the forms and views relevant to them.
How it works:
Edit the form properties → Assign the form to specific security roles.
Edit the view properties → Restrict views based on security roles.
Ensure users have the correct security roles → Users in Department A will only see their assigned forms and views, and the same applies to Department B.


NEW QUESTION # 44
You are a Dynamics 365 administrator. The sales team uses goals to track actual to target opportunity amounts.
A salesperson reviews their goals chart and observes the following:
* An opportunity updated today is not included in the chart.
* The time period for the goal is not accurate.
You need to resolve these issues.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
Time Period for the Goal is Inaccurate: Have the manager update the goal If the goal's time period is incorrect, the data might not align with the expected reporting period. To correct this, you need to have the manager update the goal to ensure that the time period accurately reflects the intended tracking duration.
Managers typically have the required permissions to adjust goal settings, including the start and end dates, which directly affect how goals are calculated and displayed.
By updating the roll-up settings and ensuring the goal's time period is correct, you can address these issues, ensuring that the goal chart reflects accurate and up-to-date information for the sales team.


NEW QUESTION # 45
You are the Dynamics 365 Sales administrator for an electronics company.
The sales team is having difficulty locating different products in the same category - for instance; all versions of flat screen TV available.
You need to make it easier for the sales team to navigate through products via taxonomy.
What should you use?

  • A. Product unit groups
  • B. Product families
  • C. Related products
  • D. Product bundles

Answer: B

Explanation:
Using Product families allows you to group similar products together under a common category or taxonomy. For example, you can create a product family for all versions of flat screen TVs, making it easier for the sales team to locate and navigate through different models within that category. This organization helps streamline product searches and improves overall efficiency in managing product offerings.


NEW QUESTION # 46
The remote sales workforce of your organization has been using the integrated Teams chat to collaborate internally. To save time, you indicate to the sales leader that suggested contacts can be displayed when a seller starts a new connected chat.
The sales leader asked you to configure the ability to use suggested contacts.
Which three users can you use as a rule for suggesting contacts? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

  • A. The system user who updated a timeline activity on the initiating record.
  • B. The user assigned as your manager on your system user record.
  • C. The Created By of the initiating record.
  • D. The Last Modified By of the initiating record.
  • E. The Record Owner of the initiating record.
  • F. The Record Owner of your linked business unit.

Answer: B,C,E

Explanation:
When configuring suggested contacts for a new connected chat in Dynamics 365, the following user roles can be utilized as rules for suggesting contacts:
The user assigned as your manager on your system user record: This is a logical option, as it allows the system to suggest contacts that are in the user's direct reporting line.
The Record Owner of the initiating record: This user is directly associated with the record being discussed or worked on, making it relevant for suggestions.
The Created By of the initiating record: The creator of the record may also have pertinent insights or context about the record, making them a suitable candidate for suggestion.


NEW QUESTION # 47
You need to update the role configuration for the digital sales team to enable the capability requested. What two actions should you perform? Each correct answer presents part of the solution. Choose two. NOTE: Each correct selection is worth one point.

  • A. Assign the Sales Copilot user role to the members of the digital sales team.
  • B. Grant View Audit Partitions permissions to the Digital seller security role.
  • C. Grant View Audit Summary permissions to the Digital seller security role.
  • D. Grant View Audit History permissions to the Digital seller security role.

Answer: A,D

Explanation:
To enable the digital sales team's request to use Copilot for summarizing changes to lead records, you need to ensure that they have the necessary permissions and access to the required features. Here's how to proceed:
Assign the Sales Copilot User Role:
Dynamics 365 Copilot in Sales is a feature that assists users by providing insights and summaries based on data within the system.
To allow the digital sales team to access and utilize Copilot's capabilities, they must have the Sales Copilot user role assigned. This role enables users to interact with Copilot and benefit from its AI-driven functionalities such as summarizing changes and insights in records.
Microsoft Documentation Reference: Dynamics 365 Sales Copilot Setup
Grant View Audit History Permissions:
The View Audit History permission is essential for team members to access audit logs, which is necessary for reviewing and summarizing changes made to lead records.
Enabling this permission will allow the digital sales team to view a history of modifications in lead records, thus allowing them to generate summaries based on this audit trail.
The View Audit Summary permission specifically lets them see summaries of audit data, which complements Copilot's functionality by allowing Copilot to access detailed change history for summarization.
Microsoft Documentation Reference: Security Roles and Privileges
By implementing these two actions, the digital sales team will have both the necessary access to Copilot features and the required permissions to audit lead record changes, enabling them to leverage Copilot for summarizing changes to leads effectively.


NEW QUESTION # 48
You are working a list of leads in Dynamics 365 Sales.
You have a custom security role that contains the following privileges:
create and edit user-level privileges on the lead and note entities.
business unit-level append, append to, and assign privileges on the lead and note entities.
organization-level share privileges on the lead and note entities.
You need to perform the following actions on leads:
add notes to leads.
assign leads to other users.
How should you manage leads? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:


NEW QUESTION # 49
Drag and Drop Question
A company must decide whether to use push notifications or assistant cards in the Dynamics 365 Sales mobile app.
You need to recommend which functionality the company should use based on its scenarios.
Which functionalities should you recommend? To answer, move the appropriate functionalities to the correct requirements. Each functionality may be used once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:
Must be able to specify individual recipients - Push notifications
Push notifications allow specifying individual recipients, ensuring that only selected users receive real-time alerts directly on their mobile devices.
Supported by both the Sales mobile app and Sales Hub - Insight cards
Insight cards (also known as assistant cards) are supported in both the Sales mobile app and Sales Hub, providing contextual insights and reminders within the Dynamics 365 environment.


NEW QUESTION # 50
Hotspot Question
A sales manager needs to set up goals in Dynamics 365 Sales for salespeople.
The measurement of goals must be based on the total deal amount upon closing an opportunity.
The fiscal year for the goals must be based on the calendar year.
You need to create the rollup query for the goal metrics.
Which options should you select? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:
Box 1: Opportunity
Entity
Dynamics 365 Sales, Define goal metric and rollup fields
For each goal metric, you can create up to three rollup field records. Each record can specify actual, in-progress, or custom amount or count. You can use the same source table or difference source tables for all rollup field records. For example, in a goal metric that specifies the Money type, you can use an opportunity table as a source table and Opportunity.ActualValue as a source attribute. This lets you track the actual money amounts in all opportunities that are closed as "Won". The Opportunity.EstimatedValue can be used to track the revenue that is expected after the opportunity is closed.
Box 2: Actual Close Date
Date field
Specify Rollup Fields
To specify other important rollup information, use the rollup field table.
* RollupField.DateAttribute
The date that is validated against the goal time period, such as Opportunity.ActualCloseDate or Lead.EstimatedCloseDate. A record participates in the goal rollup, if the specified date falls between the start date and the end date for the goal. For example, if an opportunity is closed between the start and end dates for the goal, revenue generated from this opportunity is added to the goal's total revenue; otherwise, it is not included.
Box 3: Actual Revenue
Revenue field
Examples of rollup data are Lead.EstimatedAmount and OpportunityClose.ActualRevenue that can be rolled into the Goal.InProgressMoney and the Goal.ActualMoney rollup fields.


NEW QUESTION # 51
Hotspot Question
Your organization has been noticing some peculiar field changes on certain records and wants to know what is causing this.
You need to audit user access and updates for several custom tables.
Which two boxes must be checked as prerequisites steps? To answer, select the appropriate check boxes in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:
Start Auditing: This enables auditing for the system, which is the first step for capturing any record changes or access. Audit User Access: This enables the auditing of user access, so you can track who is accessing the custom tables.


NEW QUESTION # 52
You have enabled Dynamics 365 App for Outlook for your sales team.
Users report that they are dissatisfied that they must track the emails manually, so you propose folder-level tracking.
You need to enable folder-level tracking in your environment in order for your users to configure the rules.
Which three actions should you perform in sequence before saving your changes? To answer, move the three appropriate actions from the list of actions to the answer are a. Arrange the three actions int he correct order.

Answer:

Explanation:

Reference:
Select Email Tracking Settings:
Within the environment settings, go to Email Tracking settings. This area contains the configuration options for email tracking, including methods for tracking emails automatically or manually, and where folder-level tracking can be configured.
Enable Use Folder-Level Tracking from Exchange Folders:
Once in the Email Tracking settings, enable the Use folder-level tracking from Exchange folders option. This feature allows users to automatically track emails by moving them into designated folders in their mailbox. It removes the need for manual tracking, as moving an email to a tracked folder automatically links it to Dynamics 365.
After enabling this setting, save the changes to activate folder-level tracking across the environment.
By following these steps, folder-level tracking will be enabled, allowing users to configure tracking rules based on specific folders in their Exchange mailboxes, streamlining the email tracking process within Dynamics 365.


NEW QUESTION # 53
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.
A company's IT department has a .CSV file stored on one of their Shared Documents folders within their Microsoft SharePoint sites. The data from the .CSV file is ingested into Dynamics 365 Customer Insights - Data.
The file contains a row header and columns of different types, such as quantities and prices. The file also contains some rows with a high proportion of nulls.
You need to clean and transform the data in Customer Insights - Data to be ready for unification.
Solution: Remove any rows where the primary key is missing, delete any leading or trailing zeros on the primary key, and name the query. Select Next and your data is now ready for unification.
Does this meet the goal?

  • A. No
  • B. Yes

Answer: A

Explanation:
Correct:
* Transform the first row to be used as headers. Define column types to be the appropriate field types and name the query. Create a full name and full address columns by merging the appropriate columns if they exist. Select Next and your data is now ready for unification.
The proposed solution effectively prepares the data for unification in Dynamics 365 Customer Insights - Data. Here's how each step contributes to meeting the goal:
Transform the first row to be used as headers: This step is necessary to define the column names, which is critical for accurate data interpretation.
Define column types to be the appropriate field types: Specifying the correct data types for each column ensures that the data will be processed correctly during unification, maintaining data integrity.
Create a full name and full address columns by merging the appropriate columns if they exist: This step enhances the dataset by consolidating relevant information into single columns, which can simplify data usage and improve data quality. Merging columns helps ensure that users can easily access essential information without navigating through multiple fields.
Select Next: This indicates that the data transformation steps are completed and the dataset is ready for the unification process.
Incorrect:
* Define column types to be appropriate field types and name the query. Create a full name and full address columns by merging the appropriate columns, if they exist. Select Next and your data is now ready for unification.
Does not address the problem with null values.
* Remove any rows where the primary key is missing, delete any leading or trailing zeros on the primary key, and name the query. Select Next and your data is now ready for unification.
Problem not related to the primary key.
* Transform the first row to be used as headers, and remove any special characters or spaces from header row. Remove rows with missing primary keys and name the query. Select Next and your data is now ready for unification.
Does not address the problem with null values.
* Transform the first row to be used as headers, define column types to be the appropriate field types and name the query. Select Next and your data is now ready for unification.
Solution removes all rows with null values, which can lead to significant data loss, especially if those rows contain important information.
It may compromise data quality by eliminating rows, which can impact analysis and insights.
* Transform the first row to be used as headers, remove rows that contain null values, and name the query. Select Next and your data is now ready for unification.
While the solution includes transforming the first row to be used as headers and naming the query, the step of removing rows that contain null values is problematic.
Removing all rows with null values can lead to significant data loss, particularly if those rows contain relevant information.


NEW QUESTION # 54
Drag and Drop Question
Your organization introduced a new loyalty solution that exposes the loyalty profile and related point transactions in an Azure SQL Database.
You need to ensure the new loyalty data is imported from the Azure SQL Database into Dynamics 365 Customer Insights ?Data and refreshed incrementally.
Which five actions should you perform in sequence within Customer Insights ?Data before selecting Save to complete the creation? To answer, move the five appropriate actions from the list of actions to the answer area. Arrange the five actions in the correct order.

Answer:

Explanation:

Explanation:
Step 1: Create a new data source based on Microsoft Power Query
To configure Dynamics 365 Customer Insights - Data, first bring in source data for processing.
Customer Insights - Data provides several types of data connectors to connect to and ingest data from a broad set of sources.
Customer Insights - Data, Connect to a Power Query data source
Power Query with data source Azure SQL Database supports incremental refresh.
Step 2: Select the data source and tables to ingest
Connect to Azure SQL database from Power Query Desktop
To connect to an Azure SQL database from Power Query Desktop, take the following steps:
1. Select Azure SQL database in the get data experience. The get data experience in Power Query Desktop varies between apps
2. In SQL Server database, provide the name of the server and database (optional).
3. Select either the Import or DirectQuery data connectivity mode.
[Steps omitted]
7. In Navigator, select the database information you want [Step 2], then either select Load to load the data or Transform Data [Step 3] to continue transforming the data in Power Query Editor.

Step 3: Complete the transformation steps and select Next,
Step 4: In the Set up incremental refresh dialog box, select Set up to open the Incremental refresh settings.
When you select Incremental Refresh [Step 4], a pop-up window will appear. In this window, select the table [Step 5] that you want to set up for incremental refresh and click the button next to Incrementally refresh this table.
Step 5: Select the tables and provide the required incremental refresh details.


NEW QUESTION # 55
You are a Dynamics 365 Sales administrator. You create a forecast by using the forecast category layout shown in the exhibit:

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
Deleting the Lost Column from the Forecast:
To remove a column entirely, such as the Lost column, you should adjust the Forecast configuration. This configuration setting allows you to add or remove columns from the forecast grid.
Modifying Forecast configuration affects the structural aspects of the forecast, such as which columns are included, based on what is necessary for reporting and analysis.
By utilizing the Layout column settings for renaming columns and the Forecast configuration for adding or removing columns, you can tailor the forecast layout to meet specific business requirements, ensuring the forecast view is both relevant and easy for users to interpret.


NEW QUESTION # 56
You are implementing Dynamics 365 Customer Insights - Data as the company's Customer Data Platform. You set up the data sources and start the unification process.
You need to identify the primary table within the Matching conditions page.
Which two criteria should you use to determine the primary table? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

  • A. Choose the table that has the most related tables.
  • B. Choose the Dynamics 365 contact table when this is available as the data source.
  • C. Choose the table that has several attributes in common with other tables.
  • D. Choose the table with the most complete and reliable profile data about your customers.

Answer: B,D

Explanation:
Choose the table with the most complete and reliable profile data about your customers: The primary table should contain the most accurate and complete information to serve as the foundation for matching records across different sources.
Choose the Dynamics 365 contact table when this is available as the data source: The contact table in Dynamics 365 is a logical choice for the primary table when it's available because it likely contains the core customer profile data that can be unified with other data sources.


NEW QUESTION # 57
......

Ultimate Guide to Prepare Free MB-280 Exam Questions and Answer: https://drive.google.com/open?id=1hJE2Zhy4xhjIIAEChM_TcBgQ31OWAdIJ

Pass MB-280 Tests Engine pdf - All Free Dumps: https://www.dumpsfree.com/MB-280-valid-exam.html