Delivery Methods: SAP Certification Level: Associate Exam: 80 questions Sample Questions: View more Cut Score: 61% Duration: 180 mins Languages: English
Description The “SAP Certified Technology Associate – SAP Fiori System Administration” certification exam validates that the candidate possesses the fundamental and core knowledge required of the consultant profile. This certification proves that the candidate has an overall understanding and in‐depth technical skills to participate as a member of an SAP Fiori team with a focus on system administration in a mentored role. This certification exam is recommended as an entry level qualification.
Topic Areas
Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.
AS ABAP System Administration > 12% Start & stop, configure, maintain and monitor ABAP-based SAP systems; describe the user and authorization concept; manage background jobs ADM100 (SAP S/4HANA 2021)
Technology Components for HTTP-based Communication > 12% Administrate ICF Services; install, configure and operate SAP Web Dispatcher. ADM103 (SAP S/4HANA 2021)
SAP Fiori System Landscape > 12% Activate SAP S/4HANA Embedded Analytics and Enterprise Search; configure communication channels. UX200 (SAP S/4HANA 2021)
SAP Fiori Content Management > 12% Manage SAP Fiori spaces, pages, groups, catalogs, and target mappings; configure and manage roles and SAP Fiori launchpad UX100 (SAP S/4HANA 2021)
SAP Fiori Implementation and Operations > 12% Configure transactional apps, analytical apps, fact sheet apps and classic applications; use transport and troubleshooting functions for SAP Fiori. UX200 (SAP S/4HANA 2021)
SAP Fiori Foundation 8% – 12% Describe SAP Fiori design, SAP Fiori launchpad, SAP Fiori data handling and personalize SAP Fiori; identify user interfaces for SAP systems and applications; describe data services. UX100 (SAP S/4HANA 2021)
SAP Fiori Architecture 8% – 12% Describe SAP Fiori for ABAP Platform, SAP Fiori for SAP S/4HANA, SAP S/4HANA Embedded Analytics and Enterprise Search. UX100 (SAP S/4HANA 2021)
SAP Fiori Infrastructure 8% – 12% Describe rapid activation; configure SAP Gateway, SAP Fiori, in-app help, and notifications. UX200 (SAP S/4HANA 2021)
General Information
Exam Preparation All SAP consultant certifications are available as Cloud Certifications in the Certification Hub and can be booked with product code CER006. With CER006 – SAP Certification in the Cloud, you can take up to six exams attempts of your choice in one year – from wherever and whenever it suits you! Test dates can be chosen and booked individually.
Each specific certification comes with its own set of preparation tactics. We define them as “Topic Areas” and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.
Certification exams might contain unscored items that are being tested for upcoming releases of the exam. These unscored items are randomly distributed across the certification topics and are not counted towards the final score. The total number of items of an examination as advertised in the Training Shop is never exceeded when unscored items are used.
Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.
For more information refer to our SAP Certification FAQs.
Safeguarding the Value of Certification SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.
Security Guidelines
Sample Question and Answers
QUESTION 1 You want to enable the context sensitive user assistance in the SAP Fiori launchpad. Where are the help texts persisted?
A. At the BES system B. At a separate web server C. At the SAP web dispatcher D. At the FES System
Answer: C
QUESTION 2 In addition to a transaction code, what is required to define the target mapping for a single ABAP transaction?
A. ICF service URL B. Application configuration C. SAP Gateway service D. System alias
Answer: D
QUESTION 3 You have passed the initial authentication for an SAP Fiori transactional app. Which authentication technology is used for subsequent OData calls of this app?
A. X.509 client certificates B. ABAP Session security C. SAP logon tickets D. SAML2.0
Answer: B
QUESTION 4 You have successfully executed all tasks of task list SAP_FIORI_REFERENCE_APPS_SETUP. What do you have to configure to get the reference apps working?
A. Activate the corresponding SAPUI5 ICF services using transaction SICF B. Register the corresponding OData services using transaction/IWFND/MAINT_SERVICE C. Create tiles and target mappings in the SAP Fiori launchpad designer D. Generate demo data using transaction SEPM_DG
Answer: C
QUESTION 5 In what form are user interfaces for SAPUI5-based SAP Fiori apps for SAP SHANA provided by SAP?
A. Enhancement packages B. Product-specific UI add-ons C. Product-specific UI components D. Enhancement points
Answer: C
QUESTION 6 In an SAP SHANA system, which element group SAP Fiori apps based on the duties of a user?
A. Back-end catalog B. Business catalog C. Business catalog group D. Technical catalog
SAP Certified Associate – Implementation Consultant – SAP S/4HANA Cloud Public Edition Delivery Methods: SAP Certification Level: Associate Exam: 60 questions Sample Questions: View more Cut Score: 67% Duration: 120 mins Languages: English
Description “The “”SAP Certified Associate – Implementation Consultant – SAP S/4HANA Cloud Public Edition”” certification exam validates that the candidate possesses the fundamental knowledge required to explain and execute core implementation project tasks to deploy, adopt, and extend SAP S/4HANA Cloud Public Edition. This certification is designed for implementation project members to prove their overall understanding and in-depth skills to participate in their role as members of a SAP S/4HANA Cloud Public Edition implementation project. To ensure success, SAP recommends combining learning content and hands-on experience to prepare for a certification exam because questions will test your ability to apply the knowledge gained in training. You are not allowed to use any reference materials during the certification exam (no access to online documentation or to any SAP system).”
Topic Areas Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.
Introduction to Cloud Computing and SAP Cloud ERP Deployment Options 11% – 20% Describe cloud computing, SAP’s enteprise portfolio, and Cloud ERP deployment options and enablement packages. S4C01e (SAP Learning Hub only)
Implementing with a Cloud Mindset, Building the Team, and Conducting Fit-to-Standard Workshops 11% – 20% Implement with a Cloud Mindset, build the implementation team, and conduct Fit-to-Standard Workshops. S4C01e (SAP Learning Hub only)
System Landscapes and Identity Access Management 11% – 20% Define system landscapes for implementaton, set up the systems and initial authorizations, and customize authorizations. S4C01e (SAP Learning Hub only)
Configuration and the SAP Fiori Launchpad 11% – 20% Configure business processes with SAP Central Business Configuration and work with the SAP Fiori Launchpad capabilities. S4C01e (SAP Learning Hub only)
Extensibility and Integration 11% – 20% Customizing applications and processes with extensibility tools and setting up integrations. S4C01e (SAP Learning Hub only)
Data Migration and Business Process Testing 11% – 20% Migrate data from legacy systems and test configured business processes with manual and automated tests. S4C01e (SAP Learning Hub only)
General Information
Exam Preparation All SAP consultant certifications are available as Cloud Certifications in the Certification Hub and can be booked with product code CER006. With CER006 – SAP Certification in the Cloud, you can take up to six exams attempts of your choice in one year – from wherever and whenever it suits you! Test dates can be chosen and booked individually.
Each specific certification comes with its own set of preparation tactics. We define them as “Topic Areas” and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.
Certification exams might contain unscored items that are being tested for upcoming releases of the exam. These unscored items are randomly distributed across the certification topics and are not counted towards the final score. The total number of items of an examination as advertised in the Training Shop is never exceeded when unscored items are used.
Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.
For more information refer to our SAP Certification FAQs.
Safeguarding the Value of Certification SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.
Security Guidelines
Sample Question and Answers QUESTION 1 Where are the manual test cases created for customer User Acceptance Testing?
A. Test Automation Tool B. SAP Solution Manager C. SAP Cloud ALM D. SAP Signavio Process Navigator
Answer: C
QUESTION 2 Which dimension do you use to produce external financial statements based on cost-of-sales accounting?
A. Functional area B. Profit center C. Segment D. Market segment
Answer: B
QUESTION 3 What are the restrictions when posting general journal entries to special periods? Note: There are 2 correct answers to this question
A. You must specify a posting date in the last period of the fiscal year. B. You must only post to balance sheet accounts. C. You must use the document type YE (year end). D. You must manually enter the specific special period you are posting to
Answer: A, D
QUESTION 4 What must you create when you build an integration scenario using the SAP Fiori Communication Management apps in SAP SHANA Cloud Public Edition? Note: There are 2 correct answers to this question
A. Communication arrangement B. Communication system C. Communication API D. Communication interface
Answer: A, B
QUESTION 5 What is the role of the valuation method in the foreign currency valuation of accounts payable? Note: There are 3 answers to this question.
A. Define the document type for the valuation posting B. Define the exchange rate type C. Determine the G/L accounts for the valuation posting D. Define the valuation procedure E. Define the posting and reversal date for the valuation posting
Answer: B, C, D
QUESTION 6 Which of the following are steps in an automated payment run process? Note: There are 3 correct answers to this question
A. Maintain Parameters B. Upload Bank Statement C. Schedule Payment Run D. Schedule Proposal Run E. Schedule Invoice Run
About Pegasystems Pega is the leader in cloud software for customer engagement and operational excellence. The world’s most recognized and successful brands rely on Pega’s AI-powered software to optimize every customer interaction on any channel while ensuring their brand promises are kept. Pega’s low-code application development platform allows enterprises to quickly build and evolve apps to meet their customer and employee needs and drive digital transformation on a global scale. For more than 35 years, Pega has enabled higher customer satisfaction, lower costs, and increased customer lifetime value.
Certified Pega Senior System Architect 60 Questions 1 hr 30 mins Passing Score: 70%
The Certified Pega Senior System Architect version ’23 certification validates the ability to use Pega to design and build for reusability across multiple lines of business, and includes applying best practices, understanding application debugging, understanding performance tuning and system maintenance techniques, and addressing security/access requirements in an application.
Exam Code: PEGACPSSA23V1 Language: English Retirement Date: N/A Prerequisites : Senior System Architect
Exam topics (% of exam)
Application Development (28%) Define the Enterprise Class Structure Create an application with the New Application wizard Understand the rule resolution process; adjust rule availability Identify how circumstancing affects application behavior Circumstance rules on a single variable or multiple variables Differentiate between a queue processor and a job scheduler Identify the role and elements of activities in case processing Automate actions when a property value changes Promote rule reuse with relevant records Identify the role and impacts of application versioning; Use of ruleset skimming Configure and validate application rulesets Branch rulesets for parallel development Migrate an application; use of product rules Case Management (15%) Differentiate between work groups, work queues, and organizational structures Configure parallel processing for cases Manage concurrent case access; locking strategies Configure flow action pre- and post-processing Extend service-level agreement configurations
Data and Integration (19%) Validate data against a pattern Identify use cases for keyed data pages Exchange data with other applications Manage integration settings Address integration errors in connectors Expose an application with a web service
User Experience (5%) Create and customize Pega Web Mashups Configure Pega Web Mashup authentication
Reporting (5%) Design reports with multiple sources; associations and joins Performance (7%) Measure System Performance; use of performance-related tools Debug system performance Review log files: Distinguish system events and performance events
Security (16%) Distinguish between role-based, attribute-based, and client-based access control Organize and manage case attachments Secure data with data encryption
Mobile (5%) Differentiate between the delivery options for mobile devices Design applications for mobile use; use of certificate sets
Sample Question and Answers
QUESTION 1 The Static Assembler is used to address rules assembly issues due to which cause?
A. The server is managing a large number of rules caches. B. Access groups contain multiple production rulesets. C. A new application is migrated to the production system. D. The application record lists several branch rulesets.
Answer: A
Explanation: The Static Assembler is a Pega tool used to address rules assembly issues specifically when the server is managing a large number of rules caches. By pre-assembling rules into a static content, the Static Assembler helps in improving performance in situations where cache management becomes complex due to the volume of rules. It creates a set of static files that represents the assembled rules, which can reduce the overhead on the server during rule assembly and cache management. Reference: Pega official documentation on performance tools and best practices.
QUESTION 2 Which two actions do you perform when using the Performance Analyzer (PAL) to ensure that you obtain accurate performance data? (Choose Two)
A. Run the process to completion first to perform needed rule assembly and avoid skewed results. B. Capture PAL readings after significant changes to a process to identify any performance impact. C. Capture a PAL reading for a process with good performance to establish a benchmark for comparison. D. Run PAL as an end user to account for any performance differences due to the portal itself.
Answer: A, B
Explanation: A: Running the process to completion before capturing PAL readings is important because it ensures that all the necessary rule assemblies have taken place. If you measure performance without doing this, the rule assembly might skew the results by adding additional overhead. B: Capturing PAL readings after significant changes to a process helps in identifying any performance impacts due to those changes. This allows you to compare the performance data before and after changes to assess their impact. Reference: Pega official documentation on Performance Analyzer (PAL). QUESTION 3 A user reports that an application takes five seconds to complete a step and present the next step in a process. Which tool allows you to gather and analyze performance data for the form submission?
A. Performance Profiler B. Performance Analyzer (PAL) C. Database Trace D. Tracer
Answer: B
Explanation: The Performance Analyzer (PAL) is the correct tool to gather and analyze performance data for the form submission that takes a significant amount of time. PAL tracks the interaction with the Pega Platform and provides metrics related to the performance of activities, rules, and system functions over time, which is essential for identifying the cause of the delay during form submission. Reference: Pega official documentation on PAL. QUESTION 4 Which two statements about guardrails are true? (Choose Two)
A. Each rule may have multiple guardrail warnings. B. Pega Platform performs guardrail examination when a rule is checked out. C. Pega Platform performs guardrail examination when a rule is saved. D. A developer receives a guardrail warning for rules checked out by other developers.
Answer: A, C
Explanation: A: Each rule in Pega can indeed have multiple guardrail warnings. These warnings indicate the degree to which the rule deviates from Pega’s best practices. C: Pega Platform performs a guardrail examination when a rule is saved. This is to ensure that developers are immediately aware of any potential issues that may arise from the rule they are creating or modifying. Reference: Pega official documentation on compliance score and guardrails. QUESTION 5 Which three statements about the guardrail score are true? (Choose Three)
A. The Application Guardrails landing page counts the number of rules with severe or moderate guardrail warnings. B. Guardrail scores do not include Pega Platform core rules. C. The Application Guardrails landing page counts the number of rules with no warnings or cautionlevel guardrail warnings. D. A weighted compliance score above 90 signifies that an application is ready for general distribution. E. Rules with unjustified warnings are not counted in the compliance score.
Answer: ABC
Explanation: A: The Application Guardrails landing page does count the number of rules with severe or moderate warnings, as these can have a significant impact on the application’s performance and maintainability. B: Guardrail scores exclude Pega Platform core rules since these are established by Pega and are assumed to be optimized. C: The landing page also counts the number of rules with no warnings or caution-level warnings, which contribute positively to the overall compliance score. Reference: Pega official documentation on the Application Guardrails landing page and guardrail scores. QUESTION 6 An assignment service-level agreement (SLA) is configured with the following details: * Initial urgency: 20 * Assignment ready: Timed delay of 1 hour * Goal: 5 hours and increase urgency by 10 * Deadline: 8 hours and increase urgency by 20 * Passed deadline: 2 hours, increase urgency by 20, and limit events to 5 Assuming no other urgency adjustments, what is the assignment urgency 16 hours after the case reaches the assignment?
A. 100 B. 90 C. 130 D. 70
Answer: B
Explanation: Sixteen hours after the case reaches the assignment, the assignment urgency is calculated as follows: Initial urgency (20) + Urgency after goal (10) + Urgency after deadline (20) + Urgency after passing the deadline (2 hours passed, urgency increases by 20, and this event repeats for the limit of 5 times, so 20×5=100). Adding these together: 20 + 10 + 20 + 100 = 150. However, since none of the options matches this calculation, there might be an error in the given options or a misinterpretation of the question. Based on the provided options, 90 would be the closest, indicating a possible oversight in the question. Reference: Pega official documentation on Service Level Agreements (SLAs) and urgency calculations.
Description The “SAP Certified Integration Associate – SAP SuccessFactors Full Cloud/Core Hybrid 2H/2023” certification exam validates that the candidate possesses the fundamental and core knowledge required of the Integration Consultant profile for SAP SuccessFactors Full Cloud/Core Hybrid. This certification proves that the candidate has an overall understanding and in‐depth technical skills to participate as a member of a project team in a mentored role. This certification exam is recommended as an entry level qualification. This certification is intended for SAP partner consultants implementing the solution. Only registered SAP partner consultants will be provided with provisioning rights once they have been certified. Customers and independent consultants, even if certified, will not be provided with provisioning rights. There are no exceptions to this policy.
Topic Areas Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.
SAP SuccessFactors Employee Central OData API 11% – 20% Determine when to use the appropriate API, enable the Employee Central OData APIs in your instance, call a simple OData API from a browser, identify what kind of API tools are available within Employee Central, query Employee Central data using OData APIs from a test client, and locate OData API Resources and Documentation.
HRH51e —– OR —– HRH99e
SAP ERP Employee Data Migration and Replication with SAP SuccessFactors Employee Central 11% – 20% Configure settings you make in Customizing to prepare SAP ERP HCM system for data extraction, list which data extraction programs are available, describe how to use available data extraction programs and which BAdIs are available to use, and determine which Employee Central Entities are supported for employee data extraction and organizational data migration.
HRH95e —– OR —– HRH99e
Employee Master Data Replication from SAP SuccessFactors Employee Central to SAP ERP 11% – 20% Implement and configure the replication of Employee Central data from SAP SuccessFactors and SAP ERP HCM.
HRH94e —– OR —– HRH99e
SAP SuccessFactors Employee Central Integration Overview and Basic Settings <= 10% Configure the required settings and permissions in SAP SuccessFactors to support SAP Employee Center/SAP ERP HCM integrations.
HRH03e —– OR —– HRH99e
Extensibility (BadIs) for SAP ERP Employee Data Replication with SAP SuccessFactors Employee Central <= 10% Implement and configure the extensibility of SAP ERP employee data to SAP SuccessFactors.
HRH96e —– OR —– HRH99e
Organizational Data Replication from SAP SuccessFactors Employee Central to SAP ERP <= 10% Implement and configure the integration of Organizational Management from SAP SuccessFactors and SAP ERP HCM.
HRH93e —– OR —– HRH99e
Cost Center Replication from SAP ERP to SAP SuccessFactors Employee Central <= 10% Implement and configure the integration of Cost Centers from SAP SuccessFactors and SAP ERP HCM.
HRH92e —– OR —– HRH99e
SAP SuccessFactors Employee Central Integration with SAP ERP Scenarios Overview <= 10% Introduce the Employee Central based integration scenarios and productized integrations and Identify new tools that are available from SAP to support integration and how they can be used.
HRH91e —– OR —– HRH99e
SAP SuccessFactors Compound Employee API <= 10% Determine general aspects of the SF Compound Employee API, the use case for Full, Delta and Snapshot transmission modes, demonstrate how to apply select parameter and interpret the results and how to implement Error Handling.
HRH52e —– OR —– HRH99e
SAP ERP User Interface Integration with SAP SuccessFactors Employee Central <= 10% Implement and configure the integration of SAP ERP user interface to SAP SuccessFactors.
HRH97e —– OR —– HRH99e
General Information
Exam Preparation All SAP consultant certifications are available as Cloud Certifications in the Certification Hub and can be booked with product code CER006. With CER006 – SAP Certification in the Cloud, you can take up to six exams attempts of your choice in one year – from wherever and whenever it suits you! Test dates can be chosen and booked individually.
Each specific certification comes with its own set of preparation tactics. We define them as “Topic Areas” and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.
Certification exams might contain unscored items that are being tested for upcoming releases of the exam. These unscored items are randomly distributed across the certification topics and are not counted towards the final score. The total number of items of an examination as advertised in the Training Shop is never exceeded when unscored items are used.
Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.
For more information refer to our SAP Certification FAQs.
Safeguarding the Value of Certification SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.
Security Guidelines
Sample Questions and Answers
QUESTION 1 Which of the following segments are filtered out, when the Compound Employee API query is executed with filter parameter suppressUnwantedGloballnfo? Note: There are 3 correct answers to this question.
A. depedent_information(dependent_personal_information) B. personaljnformation C. employment_informatlon D. jobjnformation E. national_id_card
Answer: A, B,E
QUESTION 2 What data Web service must be configured for employee data replication using Business Integration Builder in SOAMANAGER?
A. EmployeeMasterDataAndOrgAssignmentBundleReplicationRequestJn B. EmployeeMasterDataReplicationRequestjn C. Employee MasterData Bundle ReplfcatfonRequestJn D. EmployeeOrganisatfonalAssfgnmentReplicationRequest_ln
Answer: B
QUESTION 3 What fields are filterable in the EmpEmployment and PerPerson OData APIs?
A. custom-stringl – custom-string3 B. custom-stringl – custom-string 20 C. custom-datel – custom-date2 D. custom-datel – custom-date3
Answer: A
QUESTION 4 Position management is active in SAP SuccessFactors Employee Central and the customer wants to replicate the same positions to SAP ERP. Which switch needs to be activated in the SAP ERP system?
A. SFSFI OANSS B. SFSFI PMACT C. SFSFI SPO MP D. SFSFI SBSER
Answer: B
QUESTION 5 You want to display the SAP ERP employee data in SAP SuccessFactors. How can you integrate the SAP ERP user interface with SAP Success Factors? Note: There are 3 correct answers to this question.
A. Role-based Ul integration B. Integration Center C. Ul mashup integration D. Homepage tile integration E. Custom navigation link
Answer: C, D, E
QUESTION 6 Which IDoc will you use to replicate cost center to the SAP SuccessFactors Employee Central Payroll system?
About the exam Languages Some exams are localized into other languages. You can find these in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured
Audience profile As a candidate for this exam, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.
Your responsibilities for this role include transforming data into reusable analytics assets by using Microsoft Fabric components, such as: Lakehouses Data warehouses Notebooks Dataflows Data pipelines Semantic models Reports
You implement analytics best practices in Fabric, including version control and deployment.
To implement solutions as a Fabric analytics engineer, you partner with other roles, such as: Solution architects Data engineers Data scientists AI engineers Database administrators Power BI data analysts
In addition to in-depth work with the Fabric platform, you need experience with: Data modeling Data transformation Git-based source control Exploratory analytics
Languages, including Structured Query Language (SQL), Data Analysis Expressions (DAX), and PySpark
Skills at a glance
Plan, implement, and manage a solution for data analytics (10–15%) Prepare and serve data (40–45%) Implement and manage semantic models (20–25%) Explore and analyze data (20–25%)
Plan, implement, and manage a solution for data analytics (10–15%) Plan a data analytics environment Identify requirements for a solution, including components, features, performance, and capacity stock-keeping units (SKUs) Recommend settings in the Fabric admin portal Choose a data gateway type Create a custom Power BI report theme Implement and manage a data analytics environment Implement workspace and item-level access controls for Fabric items Implement data sharing for workspaces, warehouses, and lakehouses Manage sensitivity labels in semantic models and lakehouses Configure Fabric-enabled workspace settings Manage Fabric capacity Manage the analytics development lifecycle Implement version control for a workspace Create and manage a Power BI Desktop project (.pbip) Plan and implement deployment solutions Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models Deploy and manage semantic models by using the XMLA endpoint Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models
Prepare and serve data (40–45%) Create objects in a lakehouse or warehouse Ingest data by using a data pipeline, dataflow, or notebook Create and manage shortcuts Implement file partitioning for analytics workloads in a lakehouse Create views, functions, and stored procedures Enrich data by adding new columns or tables Copy data Choose an appropriate method for copying data from a Fabric data source to a lakehouse or warehouse Copy data by using a data pipeline, dataflow, or notebook Add stored procedures, notebooks, and dataflows to a data pipeline Schedule data pipelines Schedule dataflows and notebooks Transform data Implement a data cleansing process Implement a star schema for a lakehouse or warehouse, including Type 1 and Type 2 slowly changing dimensions Implement bridge tables for a lakehouse or a warehouse Denormalize data Aggregate or de-aggregate data Merge or join data Identify and resolve duplicate data, missing data, or null values Convert data types by using SQL or PySpark Filter data
Optimize performance Identify and resolve data loading performance bottlenecks in dataflows, notebooks, and SQL queries Implement performance improvements in dataflows, notebooks, and SQL queries Identify and resolve issues with Delta table file sizes
Implement and manage semantic models (20–25%) Design and build semantic models Choose a storage mode, including Direct Lake Identify use cases for DAX Studio and Tabular Editor 2 Implement a star schema for a semantic model Implement relationships, such as bridge tables and many-to-many relationships Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions Implement calculation groups, dynamic strings, and field parameters Design and build a large format dataset Design and build composite models that include aggregations Implement dynamic row-level security and object-level security Validate row-level security and object-level security
Optimize enterprise-scale semantic models Implement performance improvements in queries and report visuals Improve DAX performance by using DAX Studio Optimize a semantic model by using Tabular Editor 2 Implement incremental refresh
Explore and analyze data (20–25%) Perform exploratory analytics Implement descriptive and diagnostic analytics Integrate prescriptive and predictive analytics into a visual or report Profile data Query data by using SQL Query a lakehouse in Fabric by using SQL queries or the visual query editor Query a warehouse in Fabric by using SQL queries or the visual query editor Connect to and query datasets by using the XMLA endpoint
Sample Questions and Answers QUESTION 1 What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?
A. a stored procedure B. a pipeline that contains a KQL activity C. a Spark notebook D. a dataflow
Answer: D
QUESTION 2 Which type of data store should you recommend in the AnalyticsPOC workspace?
A. a data lake B. a warehouse C. a lakehouse D. an external Hive metaStore
Answer: C
QUESTION 3 You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: Table1: A Delta table created by using a shortcut Table2: An external table created by using Spark Table3: A managed table
Answer: A
QUESTION 4 You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?
A. ReadTable3. B. Update the data Table3. C. ReadTable2. D. Update the data in Table1.
Answer: D
QUESTION 5 You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?
A. Table. MaxN B. Table.Max C. Table.Range D. Table.Profile
Answer: B
QUESTION 6 You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
A. T-SQL B. DAX EC. C. Spark SQL D. PySpark
Answer: C, D
QUESTION 7 You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?
Earn associated certifications Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle Base Database Services 2023 Certified Professional Oracle Database Cloud Administrator 2023 Certified Professional
Format: Multiple Choice Duration: 90 Minutes Exam Price: $ Number of Questions: 55 Passing Score: 68% Validation: This exam has been validated against Oracle Cloud Infrastructure 2023
Policy: Cloud Recertification Prepare to pass exam: 1Z0-1093-23
An Oracle Base Database Services 2023 Certified Professional has demonstrated the knowledge and skills required to implement Oracle Base Database Services on the Oracle Cloud Infrastructure (OCI) platform.
They can configure and monitor Bare Metal and Virtual Machine (BM/VM) DB Sytems, configure Maximum Availability Architecture (MAA) and Data Guard for Exadata Cloud Service, deploy Exadata Cloud at Customer, manage MySQL Database and HeatWave, and understand the NoSQL Database Cloud Service requirements.
Take recommended training Complete one of the courses below to prepare for your exam (optional):
Become an Oracle Base Database Services Professional (2023)
Practice Exam Additional Preparation and Information A combination of Oracle training and hands-on experience (attained via labs and/or field experience), in the learning subscription, provides the best preparation for passing the exam.
Review exam topics
Oracle Cloud Platform for Database in the Cloud Describe Oracle Cloud Platform for Database in the Cloud Describe Oracle Cloud Infrastructure Strategy (OCI)
DB Systems BM/VM Discuss Database Cloud Services (Overview) Provision Database Cloud Service on a Virtual Machine DB System Manage Database Cloud Service on a Virtual Machine DB System Manage the Database Lifecycle for Database Cloud Services on a Virtual Machine DB System Utilize Database Cloud Service Management Interfaces
Exadata Database Service Explain the Exadata Database Service Provision Exadata Manage Exadata Infrastructure and VM Clusters Manage the Exadata Database Lifecycle Utilize Exadata Cloud Management tools
MySQL Database Service and HeatWave Technical Overview Describe the MySQL Database Service Manage MySQL Database Provision and connect to MySQL Database Monitor MySQL Database Set up Backup for MySQL Database Service Describe performance considerations for the MySQL Database Service Create, manage, and use HeatWave
NoSQL Database Cloud Service Explain connecting to the NoSQL Database Cloud service Explain table security management Explain table rate limiting Describe NoSQL data models Explain provisioned throughput for NoSQL Database Cloud Service Describe NoSQL language SDKs
Oracle Cloud Infrastructure Database Management Service Describe the Oracle Cloud Infrastructure Database Management Service Install and configure Management Agent Register External Databases & enable and use Database Management View Fleet Summary and Management features Use Database Groups and Jobs
QUESTION 1 What is the NoSQLHandle interface NOT used for?
A. to set the row retention time B. to gets rows from a table C. to get dynamic information on a table D. to access multiple tables
Answer: D
QUESTION 2 You have permanently deleted your MySQL database system. What happens to the two backups that are associated with the deleted database system?
A. They are archived and moved to Oracle Cloud Infrastructure file storage. B. They are retained for their retention periods. C. They are automatically deleted along with the database system. D. They are moved to Oracle Cloud Infrastructure Object Storage.
Answer: B
QUESTION 3 Your MySQL Database Service system is automatically backed up between midnight and 1 AM. What must you do to change the starting time to 4 AM?
A. Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM. B. Use the mysqlbackup command to establish a 4 AM backup start time. C. Update the Oracle Cloud Infrastructure (QCI) MySQL DB System Details page to specify the 4 AM backup window start time. D. Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.
Answer: A
QUESTION 4 What statement is FALSE regarding the differences between the Exadata Cloud@Customer X8M and X8 Infrastructure?
A. X8 uses InfiniBand for its internal network fabric whereas X8M uses RoCE. B. Both X8M and X8 Exadata System models use InfiniBand for their internal network fabric. C. X8M has more total OCPUs available than an equivalent X8 configuration. D. X8M uses Persistent Memory (PMEM).
Answer: B
QUESTION 5 Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.)
A. Oracle 18c Database deployed on Oracle Exadata Cloud@Customer B. Oracle Autonomous Database 19c deployed on an OCI Tenant C. Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine D. Oracle 11gR2 Database deployed on an Oracle Private Cloud
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 23, 2024 Audience profile
As a Microsoft cybersecurity architect, you translate a cybersecurity strategy into capabilities that protect the assets, business, and operations of an organization. You design, guide the implementation of, and maintain security solutions that follow Zero Trust principles and best practices, including security strategies for:
Identity Devices Data Applications Network Infrastructure DevOps Plus, you design solutions for: Governance and Risk Compliance (GRC) Security operations Security posture management
As a cybersecurity architect, you continuously collaborate with leaders and practitioners in IT security, privacy, and other roles across an organization to plan and implement a cybersecurity strategy that meets the business needs of an organization.
As a candidate for this exam, you have experience implementing or administering solutions in the following areas:
Identity and access Platform protection Security operations Data security Application security Hybrid and multicloud infrastructures
You should have expert skills in at least one of those areas, and you should have experience designing security solutions that include Microsoft security technologies.
Skills at a glance Design solutions that align with security best practices and priorities (20–25%) Design security operations, identity, and compliance capabilities (30–35%) Design security solutions for infrastructure (20–25%) Design security solutions for applications and data (20–25%)
Design solutions that align with security best practices and priorities (20–25%) Design a resiliency strategy for ransomware and other attacks based on Microsoft Security Best Practices Design a security strategy to support business resiliency goals, including identifying and prioritizing threats to business-critical assets Design solutions that align with Microsoft ransomware best practices, including backup, restore, and privileged access Design configurations for secure backup and restore by using Azure Backup for hybrid and multicloud environments Design solutions for security updates Design solutions that align with the Microsoft Cybersecurity Reference Architectures (MCRA) and Microsoft cloud security benchmark (MCSB) Design solutions that align with best practices for cybersecurity capabilities and controls Design solutions that align with best practices for protecting against insider and external attacks Design solutions that align with best practices for Zero Trust security, including the Zero Trust Rapid Modernization Plan (RaMP) Design solutions that align with the Microsoft Cloud Adoption Framework for Azure and the Microsoft Azure Well-Architected Framework Design a new or evaluate an existing strategy for security and governance based on the Microsoft Cloud Adoption Framework (CAF) for Azure and the Microsoft Azure Well-Architected Framework Recommend solutions for security and governance based on the Microsoft Cloud Adoption Framework for Azure and the Microsoft Azure Well-Architected Framework Design solutions for implementing and governing security by using Azure landing zones Design a DevSecOps process
Design security operations, identity, and compliance capabilities (30–35%) Design solutions for security operations Develop security operations capabilities to support a hybrid or multicloud environment Design a solution for centralized logging and auditing Design a solution for security information and event management (SIEM), including Microsoft Sentinel Design a solution for detection and response that includes extended detection and response (XDR) Design a solution for security orchestration automated response (SOAR), including Microsoft Sentinel and Microsoft Defender Design and evaluate security workflows, including incident response, threat hunting, incident management, and threat intelligence Design and evaluate threat detection coverage by using MITRE ATT&CK Design solutions for identity and access management Design a solution for access to software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), hybrid/on-premises, and multicloud resources, including identity, networking, and application controls Design a solution for Microsoft Entra ID, including hybrid and multi-cloud environments Design a solution for external identities, including business-to-business (B2B), business-to-customer (B2C), and decentralized identity Design a modern authentication and authorization strategy, including Conditional Access, continuous access evaluation, threat intelligence integration, and risk scoring Validate the alignment of Conditional Access policies with a Zero Trust strategy Specify requirements to secure Active Directory Domain Services (AD DS) Design a solution to manage secrets, keys, and certificates Design solutions for securing privileged access Design a solution for assigning and delegating privileged roles by using the enterprise access model Design an identity governance solution, including Microsoft Entra Privileged Identity Management (PIM), privileged access management, entitlement management, and access reviews Design a solution for securing the administration of cloud tenants, including SaaS and multicloud infrastructure and platforms Design a solution for cloud infrastructure entitlement management that includes Microsoft Entra Permissions Management Design a solution for Privileged Access Workstation (PAW) and bastion services Design solutions for regulatory compliance Translate compliance requirements into a security solution Design a solution to address compliance requirements by using Microsoft Purview risk and compliance solutions Design a solution to address privacy requirements, including Microsoft Priva Design Azure Policy solutions to address security and compliance requirements Evaluate infrastructure compliance by using Microsoft Defender for Cloud
Design security solutions for infrastructure (20–25%) Design solutions for security posture management in hybrid and multicloud environments Evaluate security posture by using MCSB Evaluate security posture by using Microsoft Defender for Cloud Evaluate security posture by using Microsoft Secure Score Design integrated security posture management and workload protection solutions in hybrid and multi-cloud environments, including Microsoft Defender for Cloud Design cloud workload protection solutions that use Microsoft Defender for Cloud, such as Microsoft Defender for Servers, Microsoft Defender for App Service, and Microsoft Defender for SQL Design a solution for integrating hybrid and multicloud environments by using Azure Arc Design a solution for Microsoft Defender External Attack Surface Management (Defender EASM) Design solutions for securing server and client endpoints Specify security requirements for servers, including multiple platforms and operating systems Specify security requirements for mobile devices and clients, including endpoint protection, hardening, and configuration Specify security requirements for IoT devices and embedded systems Design a solution for securing operational technology (OT) and industrial control systems (ICS) by using Microsoft Defender for IoT Specify security baselines for server and client endpoints Design a solution for secure remote access Specify requirements for securing SaaS, PaaS, and IaaS services Specify security baselines for SaaS, PaaS, and IaaS services Specify security requirements for IoT workloads Specify security requirements for web workloads, including Azure App Service Specify security requirements for containers Specify security requirements for container orchestration
Design security solutions for applications and data (20–25%) Design solutions for securing Microsoft 365 Evaluate security posture for productivity and collaboration workloads by using metrics, including Microsoft Secure Score and Microsoft Defender for Cloud secure score Design a Microsoft 365 Defender solution Design secure configurations and operational practices for Microsoft 365 workloads and data Design solutions for securing applications Evaluate the security posture of existing application portfolios Evaluate threats to business-critical applications by using threat modeling Design and implement a full lifecycle strategy for application security Design and implement standards and practices for securing the application development process Map technologies to application security requirements Design a solution for workload identity to authenticate and access Azure cloud resources Design a solution for API management and security Design a solution for secure access to applications, including Azure Web Application Firewall (WAF) and Azure Front Door Design solutions for securing an organization’s data Design a solution for data discovery and classification by using Microsoft Purview data governance solutions Specify priorities for mitigating threats to data Design a solution for protection of data at rest, data in motion, and data in use Design a security solution for data in Azure workloads, including Azure SQL, Azure Synapse Analytics, and Azure Cosmos DB Design a security solution for data in Azure Storage Design a security solution that includes Microsoft Defender for Storage and Microsoft Defender for SQL
Sample Questions and Answers
New Topic: Topic 1, Fabrikam, Inc Case Study 1 OverView Fabrikam, Inc. is an insurance company that has a main office in New York and a branch office in Paris. On-premises Environment The on-premises network contains a single Active Directory Domain Services (AD DS) domain named corp.fabrikam.com. Azure Environment Fabrikam has the following Azure resources: An Azure Active Directory (Azure AD) tenant named fabrikam.onmicrosoft.com that syncs with corp.fabnkam.com A single Azure subscription named Sub1 A virtual network named Vnet1 in the East US Azure region A virtual network named Vnet2 in the West Europe Azure region An instance of Azure Front Door named FD1 that has Azure Web Application Firewall (WAR enabled A Microsoft Sentinel workspace An Azure SQL database named ClaimsDB that contains a table named ClaimDetails 20 virtual machines that are configured as application servers and are NOT onboarded to Microsoft Defender for Cloud A resource group named TestRG that is used for testing purposes only An Azure Virtual Desktop host pool that contains personal assigned session hosts All the resources in Sub1 are in either the East US or the West Europe region. Partners Fabrikam has contracted a company named Contoso, Ltd. to develop applications. Contoso has the following infrastructure-. An Azure AD tenant named contoso.onmicrosoft.com An Amazon Web Services (AWS) implementation named ContosoAWS1 that contains AWS EC2 instances used to host test workloads for the applications of Fabrikam Developers at Contoso will connect to the resources of Fabrikam to test or update applications. The developers will be added to a security Group named Contoso Developers in fabrikam.onmicrosoft.com that will be assigned to roles in Sub1. The ContosoDevelopers group is assigned the db.owner role for the ClaimsDB database. Compliance Event Fabrikam deploys the following compliance environment: Defender for Cloud is configured to assess all the resources in Sub1 for compliance to the HIPAA HITRUST standard. Currently, resources that are noncompliant with the HIPAA HITRUST standard are remediated manually. Qualys is used as the standard vulnerability assessment tool for servers. Problem Statements The secure score in Defender for Cloud shows that all the virtual machines generate the following recommendation-. Machines should have a vulnerability assessment solution. All the virtual machines must be compliant in Defender for Cloud. ClaimApp Deployment Fabrikam plans to implement an internet-accessible application named ClaimsApp that will have the following specification ClaimsApp will be deployed to Azure App Service instances that connect to Vnetl and Vnet2. Users will connect to ClaimsApp by using a URL of https://claims.fabrikam.com. ClaimsApp will access data in ClaimsDB. ClaimsDB must be accessible only from Azure virtual networks. The app services permission for ClaimsApp must be assigned to ClaimsDB. Application Development Requirements Fabrikam identifies the following requirements for application development: Azure DevTest labs will be used by developers for testing. All the application code must be stored in GitHub Enterprise. Azure Pipelines will be used to manage application deployments. All application code changes must be scanned for security vulnerabilities, including application code or configuration files that contain secrets in clear text. Scanning must be done at the time the code is pushed to a repository. Security Requirement Fabrikam identifies the following security requirements: Internet-accessible applications must prevent connections that originate in North Korea. Only members of a group named InfraSec must be allowed to configure network security groups (NSGs} and instances of Azure Firewall, VJM. And Front Door in Sub1. Administrators must connect to a secure host to perform any remote administration of the virtual machines. The secure host must be provisioned from a custom operating system image. AWS Requirements Fabrikam identifies the following security requirements for the data hosted in ContosoAWSV. Notify security administrators at Fabrikam if any AWS EC2 instances are noncompliant with secure score recommendations. Ensure that the security administrators can query AWS service logs directly from the Azure environment. Contoso Developer Requirements Fabrikam identifies the following requirements for the Contoso developers; Every month, the membership of the ContosoDevelopers group must be verified. The Contoso developers must use their existing contoso.onmicrosoft.com credentials to access the resources in Sub1. The Comoro developers must be prevented from viewing the data in a column named MedicalHistory in the ClaimDetails table. Compliance Requirement Fabrikam wants to automatically remediate the virtual machines in Sub1 to be compliant with the HIPPA HITRUST standard. The virtual machines in TestRG must be excluded from the compliance assessment. QUESTION 1 You need to recommend a solution to meet the security requirements for the InfraSec group. What should you use to delegate the access?
A. a subscription B. a custom role-based access control (RBAC) role C. a resource group D. a management group
Answer: B
QUESTION 2 You need to recommend a solution to scan the application code. The solution must meet the application development requirements. What should you include in the recommendation?
A. Azure Key Vault B. GitHub Advanced Security C. Application Insights in Azure Monitor D. Azure DevTest Labs
Answer: B
QUESTION 3 You need to recommend a solution to resolve the virtual machine issue. What should you include in the recommendation? (Choose Two) A. Onboard the virtual machines to Microsoft Defender for Endpoint. B. Onboard the virtual machines to Azure Arc. C. Create a device compliance policy in Microsoft Endpoint Manager. D. Enable the Qualys scanner in Defender for Cloud.
Answer: A, B
QUESTION 4 HOTSPOT What should you create in Azure AD to meet the Contoso developer requirements? Answer: Box 1: A synced user account – Need to use a synched user account. Box 2: An access review
QUESTION 5 HOTSPOT You are evaluating the security of ClaimsApp. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE; Each correct selection is worth one point. Answer: Explanation: QUESTION 6 You need to recommend a solution to secure the MedicalHistory data in the ClaimsDetail table. The solution must meet the Contoso developer requirements. What should you include in the recommendation?
A. Transparent Data Encryption (TDE) B. Always Encrypted C. row-level security (RLS) D. dynamic data masking E. data classification
Answer: D
QUESTION 7 HOTSPOT You need to recommend a solution to meet the AWS requirements. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: QUESTION 8 You need to recommend a solution to meet the security requirements for the virtual machines. What should you include in the recommendation?
A. an Azure Bastion host B. a network security group (NSG) C. just-in-time (JIT) VM access D. Azure Virtual Desktop
Answer: A
QUESTION 9 HOTSPOT You need to recommend a solution to meet the requirements for connections to ClaimsDB. What should you recommend using for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: QUESTION 10 HOTSPOT You need to recommend a solution to meet the compliance requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Security and Governance: Implementing security measures. Managing access and permissions.
Administration and Deployment: Lifecycle management. Environment management.
Remember, these are general areas that may be covered in the PL-300 exam. For the most accurate and up-to-date information, it’s recommended to refer to the official Microsoft documentation and the skills measured section on the exam page.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. Although Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of February 6, 2024
Audience profile As a candidate for this exam, you should deliver actionable insights by working with available data and applying domain expertise. You should:
Provide meaningful business value through easy-to-comprehend data visualizations. Enable others to perform self-service analytics. Deploy and configure solutions for consumption. As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with enterprise data analysts and data engineers to identify and acquire data. You use Power BI to: Transform the data. Create data models. Visualize data. Share assets.
You should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). You know how to assess data quality. Plus, you understand data security, including row-level security and data sensitivity.
Skills at a glance Prepare the data (25–30%) Model the data (25–30%) Visualize and analyze the data (25–30%) Deploy and maintain items (15–20%)
Prepare the data (25–30%) Get data from data sources Identify and connect to a data source Change data source settings, including credentials, privacy levels, and data source locations Select a shared semantic model, or create a local data model Choose between DirectQuery, Import, and Dual mode Change the value in a parameter Clean the data Evaluate data, including data statistics and column properties Resolve inconsistencies, unexpected or null values, and data quality issues Resolve data import errors Transform and load the data Select appropriate column data types Create and transform columns Transform a query Design a star schema that contains facts and dimensions Identify when to use reference or duplicate queries and the resulting impact Merge and append queries Identify and create appropriate keys for relationships Configure data loading for queries
Model the data (25–30%) Design and implement a data model Configure table and column properties Implement role-playing dimensions Define a relationship’s cardinality and cross-filter direction Create a common date table Implement row-level security roles Create model calculations by using DAX Create single aggregation measures Use CALCULATE to manipulate filters Implement time intelligence measures Identify implicit measures and replace with explicit measures Use basic statistical functions Create semi-additive measures Create a measure by using quick measures Create calculated tables Optimize model performance Improve performance by identifying and removing unnecessary rows and columns Identify poorly performing measures, relationships, and visuals by using Performance Analyzer Improve performance by choosing optimal data types Improve performance by summarizing data
Visualize and analyze the data (25–30%) Create reports Identify and implement appropriate visualizations Format and configure visualizations Use a custom visual Apply and customize a theme Configure conditional formatting Apply slicing and filtering Configure the report page Use the Analyze in Excel feature Choose when to use a paginated report Enhance reports for usability and storytelling Configure bookmarks Create custom tooltips Edit and configure interactions between visuals Configure navigation for a report Apply sorting Configure sync slicers Group and layer visuals by using the Selection pane Drill down into data using interactive visuals Configure export of report content, and perform an export Design reports for mobile devices Identify patterns and trends Use the Analyze feature in Power BI Use grouping, binning, and clustering Incorporate the Q&A feature in a report Use AI visuals Use reference lines, error bars, and forecasting Detect outliers and anomalies Create and share scorecards and metrics
Deploy and maintain items (15–20%) Create and manage workspaces and items Create and configure a workspace Assign workspace roles Configure and update a workspace app Publish, import, or update items in a workspace Create dashboards Choose a distribution method Apply sensitivity labels to workspace content Configure subscriptions and data alerts Promote or certify Power BI content Manage global options for files Manage semantic models Identify when a gateway is required Configure a semantic model scheduled refresh Configure row-level security group membership Provide access to semantic models
Sample Questions and Answers Version: 13.0 New Topic: Topic 1, Litware, Inc. Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources. Litware uses Azure Active Directory (Azure AD) to authenticate users. – Existing Environment Sales Data Litware has online sales data that has the SQL schema shown in the following table. In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager. Data Concerns You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts. Reporting Requirements Litware identifies the following technical requirements: Executives require a visual that shows sales by region. Regional managers require a visual to analyze weekly sales and returns. Sales managers must be able to see the sales data of their respective region only. The sales managers require a visual to analyze sales performance versus sales targets. The sale department requires reports that contain the number of sales transactions. Users must be able to see the month in reports as shown in the following example: Feb 2020. The customer service department requires a visual that can be filtered by both sales month and ship month independently. QUESTION 1 You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
A. Select Column distribution. B. Select the sales_amount column and apply a number filter. C. Select Column profile, and then select the sales_amount column. D. Transform the sales_amount column to replace negative values with 0.
Answer: C
QUESTION 2 You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
A. FORMAT(‘Date'[date], “MMM YYYY”) B. FORMAT(‘Date’ [date], “M YY”) C. FORMAT(‘Date'[date_id], “MMM”) & “” & FORMAT(‘Date'[year], “#”) D. FORMAT(‘Date’ [date_id], “MMM YYYY”)
Answer: A
QUESTION 3 You need to create the required relationship for the executive’s visual. What should you do before you can create the relationship?
A. Change the data type of Sales[region_id] to Whole Number. B. In the Sales table, add a measure for sum(sales_amount). C. Change the data type of sales[sales_id] to Text. D. Change the data type of sales [region_id] to Decimal Number.
Answer: A Scenario: Executives require a visual that shows sales by region. Need to change the sales_id column from Varchar to Whole Number (Integer).
QUESTION 4 What should you create to meet the reporting requirements of the sales department?
A. a measure that uses a formula of SUM (Sales [sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that uses a formula of SUM (Sales [sales_id])
Answer: C
Explanation: The sale department requires reports that contain the number of sales transactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
QUESTION 5 You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table. B. Add the Weekly_Returns data to the Sales table by using related DAX functions. C. Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
Answer: A
Explanation: Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column.
QUESTION 6 HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Scenario: The sales managers require a visual to analyze sales performance versus sales targets. Box 1: KPI A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Sales[sales_amount] Box 3: Date[month] Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target] QUESTION 7 You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?
A. Create a security role that has a table filter on the Sales_Manager table where username = UserName() B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName(). C. Create a security role that has a table filter on the Sales_Manager table where name = UserName(). D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Answer: A
QUESTION 8 You need to create relationships to meet the reporting requirements of the customer service department. What should you create?
A. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] B. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id] D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] E. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Answer: A
Explanation: Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
QUESTION 9 HOTSPOT You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer: Explanation:
QUESTION 10 You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection’
A. import that uses a Microsoft account B. DirectQuery that uses the end-user s credentials C. DirectQuery that uses a database credential D. Import that uses a database credential
The PL-200 exam is crucial for aspiring Microsoft Power Platform Functional Consultants. To succeed, candidates should focus on understanding PL-200 exam details, including objectives and updates. Utilize reliable study materials, practice questions, and official Microsoft Learning resources to prepare effectively for this certification, ensuring a comprehensive grasp of Power Platform concepts.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 12, 2024
Audience profile As a candidate for this exam, you: Perform discovery. Capture requirements. Engage subject matter experts and stakeholders. Configure business solutions by using Microsoft Power Platform tools and components. You create: Application enhancements Tailored user experiences Process automation
As a candidate, you implement the design provided by and in collaboration with a solution architect and the standards, branding, and artifacts established by user experience designers. You implement integrations with third-party applications and services. You generate training documentation, and you facilitate training and enablement.
You must interact and effectively communicate with members of a delivery team, stakeholders, and customer teams while championing for their success. You must have an understanding of application lifecycle management (ALM) practices for Microsoft Power Platform and quality assurance.
You should be familiar with using the following Microsoft Power Platform components:
Microsoft Dataverse Microsoft Power Apps Microsoft Power Automate cloud flows Microsoft Power Pages Microsoft Power Platform environments You should have proficiency in: Data modeling User experience design Requirements analysis
Skills at a glance Configure Microsoft Dataverse (25–30%) Create apps by using Microsoft Power Apps (25–30%) Create and manage logic and process automation (25–30%) Manage environments (15–20%)
Configure Microsoft Dataverse (25–30%) Manage the data model Create or modify standard, activity, or virtual tables Create new tables or modify existing tables Determine which type of relationship to implement, including one-to-many and many-to-many Configure table relationships including behaviors and cascading rules Create new or modify existing columns, including calculated, rollup, and formula Configure table properties Manage Dataverse Configure Dataverse search, and manage the search index Manage auditing Describe options for importing and exporting data Configure duplicate detection settings Configure bulk deletion Configure security settings Manage business units Create and manage security roles Create and manage users and teams Create and manage column security Configure hierarchy security Configure Microsoft Entra ID group teams
Create apps by using Microsoft Power Apps (25–30%) Create model-driven apps Create and configure multiple form types Use controls in the form designer Create and configure views Configure custom pages Configure modern commanding by using Power Fx Embed a canvas app in a model-driven app form Add Microsoft Power BI dashboards and reports in a model-driven app Describe canvas apps Describe canvas app structure Describe form navigation, formulas, variables and collections, and error handling Describe how Microsoft Power Automate flows are called from a canvas app Build Microsoft Power Pages Configure pages, forms, and navigation Describe advanced Power Pages features, including document management, search, multi-step forms, and Power BI Configure website security including web roles and page access Describe use cases for templates Describe authentication options
Create and manage logic and process automation (25–30%) Create and manage cloud flows Describe types of flows, use cases, and flow components, including when to use a classic workflow Describe components of a connector Implement logic controls including branches, loops, conditions, error handling, and variables Implement dynamic content and expressions Work with the Dataverse connector Manage and troubleshoot flows Create and manage business process flows Configure a business process flow Add stages, workflows, and flow steps to a business process flow Manage the business process flow table for a business process flow Create and manage classic Dataverse workflows Configure a workflow Troubleshoot workflows Manage workflow logs Implement low-code logic Configure low-code plug-ins Write and use Power Fx functions and formulas Create and configure business rules
Manage environments (15–20%) Participate in application lifecycle management (ALM) Describe use cases for app checker and solution checker Create and manage Dataverse solutions Describe the difference between managed and unmanaged Dataverse solutions Manage Microsoft Power Platform environments for development Import and export Dataverse solutions Manage interoperability with other services Configure email integration Configure Microsoft SharePoint integration Describe options for document management Work with Microsoft Word templates
Sample Questions and Answers
Background Alpine SKi House is a boutique mountain resort that offers year-round spa and outdoor activities such as snow sports, hiking, mountain biking, and more. The resort has been family owned and operated for more than 50 years. The company has been able to remain profitable while not needing to adopt new technologies.
General Booking at the resort have decreased. The company has decided to focus on creating a tailored, firstclass experience for guest. The company also plans to target corporate meetings and events. The company recently purchased a chatbot named FAQbot from AppSoure. The chatbot uses the resort’s existing FAQS Communication * Communication between staff members is primarily conducted through email and SMS text messages. * Conversations between staff members and guest often lost. * Conference calls are used for all group meeting
Event Registration * Corporate customers can reserve a meeting room at the resort to host meetings. The meetings will include lunch and choice of either an inside-spa experience or a seasonally appropriate outdoor activity. * Event registration is conducted three weeks prior to start of the event. It is assumed that all event attendees will attend the meeting Check-in process * Guests wait in lines to check in and obtain name badges. At this time, guests can specify any dietary restrictions and select their activity preference. This can result in long wait times and crowding at the front desk. * For health and compliance reasons, guests must answer a series of questions with a yes or no answer during check-in. The front desk will ask and record these answers for the resort’s records.
Marketing At the check-in counter, the guests can drop their business cards into a bowl for a chance to win an all-inclusive weekend stay at the resort. The resort uses the business card information to send announcements about promotions and upcoming events.
Resort policies and event inquiries * A guest can call or send an email to the event coordinator at the resort to get information about hotel policies, snow conditions, or to pre-select their after-meeting event; * Guests can also go to the website to view the extensive list of frequently asked questions (FAQ) compiled over the years. Many of the answers to the FAQ’s are out of date.
General Alpine Ski House does not employ technical staff and does not have the budget to hire an external firm to develop solutions. There are two team members who are proficient at Microsoft Excel formulas. Any solution created must use the capabilities of current team members. All solutions must be simple to use, easy to maintain, and represent the brand of the resort. You must implement the following solutions: * a centrally managed communication solution * a customer service solution * a resort portal * a chat solution * a check-in solution Communication * Communication between team members must be centrally managed and unified in Microsoft Teams. * When the company confirms an event they, must provide a list of guest’s names and email addresses. * You must send guests a welcome email that includes a unique registration number for authentication with the resort’s portal. * Guests must receive a separate email to verify proof of ownership for their registration. Event attendance * Guests must create an account and sign into a resort portal to confirm their attendance to an event and pre-select an after-meeting event * Prior to the event, guests must be able to identify any personal dietary restrictions. Check-in processes * Check-in processes must be self-service. Each screen must ask for specific data from the guest. The check-in solution will use some data that is stored in Microsoft Excel. * The check-in solution must continue to function if there are internet issues. If the self-service kiosks are not available, staff must be able to use the check-in solution from within their communication solution. * The check-in solution must have a screen where the guest will select either yes or no to health and wellness questions. * Guests must physically interact with each answer before proceeding to the next screen. Guests must be able to confirm any dietary restrictions they may have entered from the portal or add new ones at this time. * Data must be entered in each screen before users move on to the next screen. Marketing * To eliminate the handling of business cards, the check-in solution must be able to translate the contents of the business cards into Alpine Ski House’s marketing system. * The solution must not require any effort or manual entry from the guest to prevent any mistyped information and to make it more appealing to the guest to participate. Hotel policies and event inquiries The portal must allow the guest to ask questions about hotel policies, event information, weather reports, and current weather condition at the resort. Chat solution The chat solution must specifically address the following key words. No additional key words will be added until a later implementation phase: * Snow reports * Weather conditions * Start time * End time * Event date * Outdoor activities * Indoor activities * Most popular The chat solution must be available always and not require staff to answer all of the questions. If a question does require a staff member’s attention, the solution must determine which staff member is best to assist the customer with the question. The information in the FAQ on the legacy website must be used in the chat solution but retyping all the data from the website should not be required. If quests ask about topics that are not listed in the FAQ, the chat solution must identify the issue and escalate to a staff member. Team members must be able to ask their own questions through a centrally managed communication solution instead of using the guest portal. Team members must be able to access the same FAQ across multiple solutions. Issue Guest1 inquires about snow conditions several times each day of their stay. QUESTION 1 You need to create the FAQ solution content What should you do first?
A. Al Builder B. Suggest topics C. Automate D. Trigger phrases
Explanation:
Answer: B You need to make sure there are three main steps need to do while doing import FAQ and add the topic to your bot application. Import Suggested Topics from FAQ webpage. Add a topic. Enable the topics
QUESTION 2 HOTSPOT You need to design the resort portal’s email registration process. Which solutions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer:
QUESTION 3 You need to design the resort portal to meet the business requirements. Which data source should you use?
A. Microsoft Excel B. Azure SQL Database C. SQL Server D. Common Data Service
Answer: A
QUESTION 4 HOTSPOT You need to design and create the solution for gathering contact information from guests for marketing purposes. What should you use? To answer, select the appropriate options In the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer:
QUESTION 5 HOTSPOT You need to embed the check-in solution into the communication solution. To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer: Box 1: Power Apps Web Studio Scenario: The check-in solution must continue to function if there are internet issues. If the selfservice kiosks are not available, staff must be able to use the check-in solution from within their communication solution. PowerApps Studio is a browser application used to edit your apps. PowerApps Studio includes a drag-and-drop canvas in the center of the screen and a screen or object list pane on the left. Properties, Rules, and Advanced Properties for selected screens or controls are displayed in the right pane. Box 2: in a tab You can customize the Teams experience by adding Power Apps canvas apps to your channels in Teams using the PowerApps tab.
QUESTION 6 HOTSPOT You need to design the guest check-in solution. Which technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Canvas app, Power Apps mobile app
QUESTION 7 You need to add controls to the check-in solution for the health and wellness questions. Which form control should you use? A. Drop down B. Check box C. Text input
Answer: A
QUESTION 8 You need to design the resort portal’s email registration process. Which solution should you use?
A. Default the invitation code from the email upon logging into the portal B. Auto-populate the invitation code field on the sign in screen from the email link C. Embed the invitation code in the email link URL D. Send the customer their username and temporary password in the email link
Answer: C Scenario: Guests must receive a separate email to verify proof of ownership for their registration. Note: You can setup redeem an invitation code for power apps portal.
QUESTION 9 HOTSPOT A guest asks about the start time of a specific scheduled event and wants to know what the snow conditions will be like during their stay. You need to determine how to design the chat solution to answer those questions. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer: Box 1: Load the extracted topic into a variable Power Virtual Agents uses entities to understand and identify a specific type of information from a user’s responses. When saving the identified information to a variable, a variable type will be associated with it. The variable type is analogous with the entity. In Power Virtual Agents, a topic defines a how a bot conversation plays out. A topic has trigger phrases – these are phrases, keywords, or questions that a user is likely to type that is related to a specific issue – and conversation nodes – these are what you use to define how a bot should respond and what it should do. Box 2: Create a custom entity The prebuilt entities cover commonly used information types, but on some occasions, such as when building a bot that serves a specific purpose, you’ll need to teach the bot’s language understanding model some domain-specific knowledge.
QUESTION 10 You need to design the chat solution to answer the inquiry from Guest1. Which three components can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Variables B. Escalations C. Smart match D. Synonyms E. Topics
Answer: ACD Scenario: Guest1 inquires about snow conditions several times during each day of their stay. Variables let you save responses from your customers in a conversation with your bot so that you can reuse them later in the conversation. Synonyms allows you to manually expand the matching logic by adding synonyms. Smart match and synonyms seamlessly work together to make your bot even smarter. Reference: QUESTION 11 You need to embed the business card solution in the check-in app. What you use?
A. control B. Button control C. Custom component D. Al Builder component
Preparing for the MS-700 exam requires a comprehensive approach. Utilize official documentation and a reliable study guide for effective MS-700 exam preparation. Avoid the temptation of MS-700 exam dumps, as they violate certification terms. Practice tests, exam questions, and a Microsoft Teams administrator certification can enhance your readiness for success.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 30, 2024
Audience profile As a Microsoft Teams administrator, you manage and maintain internal and external collaboration and communication solutions using Teams and Microsoft 365. You’re responsible for configuring and managing teams, channels, chat, apps, calling, meetings, and events. You manage: Phone numbers and services for Teams Phone. Operational aspects of Teams clients and devices. You collaborate with owners of other workloads, including: Networking Identity Licensing Information management
User adoption You work with collaboration and communication system engineers to implement advanced Teams Phone and Teams Rooms scenarios. You plan and implement governance, security, and compliance for Teams. As a candidate for this exam, you should have a working knowledge of Microsoft 365 services, including: Microsoft 365 groups Microsoft SharePoint Online OneDrive Exchange Microsoft Entra ID You should understand the options for integrating and extending Teams with other apps, including: Microsoft Viva Power Platform Third-party apps Custom apps
Skills at a glance Configure and manage a Teams environment (45–50%) Manage teams, channels, chats, and apps (20–25%) Manage meetings and calling (15–20%) Monitor, report on, and troubleshoot Teams (10–15%)
Configure and manage a Teams environment (45–50%) lan and configure network settings for Teams Calculate network bandwidth capacity for Teams voice, video, meetings, and live events Analyze network impact by using Network planner Specify network ports and protocols used by Teams Specify optimal network architecture for Teams Assess network readiness and connectivity by using the Microsoft Teams Network Assessment Tool and Microsoft 365 network connectivity test tool Manage security and compliance settings for Teams Identify licensing requirements for security and compliance features Specify security and compliance alert policies for Teams Choose appropriate Teams administrator roles Plan and configure Enhanced encryption policies Plan and configure threat policies in Microsoft 365 Defender Plan and configure retention policies Plan and configure sensitivity labels and policies Plan and configure data loss prevention (DLP) policies Plan Conditional Access for Teams Plan and configure information barrier (IB) policies Identify appropriate use cases for communication compliance and insider risk management Plan and implement governance and lifecycle management Identify licensing requirements for advanced lifecycle management of teams Identify where Teams stores content Plan and manage update policies, including Public Preview, Office Insider, and Targeted release Create and manage policy packages in Teams Plan and configure policy assignment for users and groups Configure settings for Microsoft 365 group creation Configure an expiration policy for Microsoft 365 groups Configure a naming policy for Microsoft 365 groups, including blocked words Archive, delete, or unarchive one or more teams Restore or troubleshoot the deletion of a Microsoft 365 group Identify when to use Microsoft Entra Access reviews for Teams and Groups. Perform operations for Teams by using PowerShell Configure and manage external collaboration Identify licensing requirements for external collaboration Configure SharePoint Online and OneDrive external sharing settings Configure External access in the Microsoft Teams admin center Configure External collaboration settings in Microsoft Entra ID for guest access Configure guest access and sharing in the Microsoft Teams admin center, Microsoft 365 admin center, or Microsoft Entra admin center Control guest access to a specific team, including sensitivity labels and Microsoft Entra ID Remove guests from Teams, including from a team or a tenant Configure shared channels for external access Configure and manage cross-tenant access for B2B direct connect in Microsoft Entra ID for shared channels Manage Teams clients and devices Identify licensing requirements for Teams Phone and resource accounts Identify licensing requirements for Teams devices Manage configuration profiles for Teams devices Configure Teams Rooms accounts and systems Manage device settings and firmware Manage Teams device tags Provision and configure remote sign-in for new devices
Manage teams, channels, chats, and apps (20–25%) Create and manage teams Plan for a Microsoft Teams rollout by using Advisor for Teams Create a team by using the Microsoft Teams admin center, Teams client, or the Teams PowerShell module Create a team from an existing Microsoft 365 group, SharePoint site, or team Create a team from a template Create and manage Teams templates and template policies Manage the membership of a team Assign and modify user roles in a team Manage a team in the Microsoft Teams admin center Manage Teams environment settings in the Microsoft Teams admin center Configure privacy and sensitivity settings for Teams Manage channels and chats Recommend channel types, including standard, private, and shared Add, edit, and remove channels Manage Teams channel settings Create and manage teams policies for channels Manage private and shared channel membership Create and manage messaging policies Manage apps for Teams Manage Org-wide app settings in the Microsoft Teams admin center Create and manage app permission policies Create and manage app setup policies Manage permissions and consent for apps, including blocking apps Recommend appropriate extensibility options, including apps, connectors, tabs, meetings, and messaging extensions Manage purchasing of apps in the Teams app store Customize the appearance of the Teams app store Customize the branded experience of an app Upload an app to Teams
Manage meetings and calling (15–20%) Manage meetings and events Recommend meeting types, including live events, webinars, and virtual appointments Enable enhanced meeting features for a user by assigning Microsoft Teams Premium licenses Configure meeting settings Create and manage meeting templates and template policies Create and manage meeting policies Create and manage conference bridges Create and manage audio conferencing policies Plan and configure live events settings and policies Manage phone numbers and services for Teams Phone Evaluate Public Switched Telephone Network (PSTN) options, including Calling Plan, Direct Routing, Operator Connect, and Teams Phone Mobile Add, change, or remove an emergency address for an organization Provision and manage phone numbers for users, services, and conferencing bridges Assign, change, or remove a phone number for a user or a resource account Create and manage resource accounts in the Microsoft Teams admin center Manage voice settings and policies for users Create and manage voicemail policies Configure auto-attendants and call queues Create and manage calling policies
Monitor, report on, and troubleshoot Teams (10–15%) Monitor and report on Teams Monitor and report on voice and meeting quality Report on Teams usage, including team activity, app usage, active users, per-meeting metrics, and storage usage Monitor and report on the creation and deletion of teams Monitor and report on guest access Monitor the Microsoft 365 network connectivity test tool Manage feedback policies Troubleshoot audio, video, and client issues Collect client-side logs Clear the Teams client cache Troubleshoot issues by using self-help diagnostics for Teams Troubleshoot Team client installation and update issues Troubleshoot sign-in issues to Teams
Sample Questions and Answers
New Topic: Topic 1, Contoso, Ltd Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirement, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview Contoso, Ltd. is a pharmaceutical company that has 3,000 users in offices across North America. Existing Environment Active Directory The network contains an on-premises Active Directory domain. All user accounts are in departmental organizational units (OUs). Microsoft Office 365 All users are assigned a Microsoft Office 365 E5 license and are enabled for the following services: Microsoft Yammer Microsoft Exchange Online Microsoft SharePoint Online Microsoft OneDrive for Business Azure Active Directory (Azure AD) Azure AD dynamic group membership Microsoft Skype for Business Contoso has an on-premises deployment of Microsoft Skype for Business Server 2015. All the latest cumulative updates are installed on all the servers. The following services are used in Skype for Business Server 2015: Meetings PSTN calling Instant messaging (IM) Federation to external companies Departments Contoso has the following departments: IT Sales Human resources (HR) Research and deployment (R&D) All groups are created by using dynamic group membership that use the department attribute. Requirements Business goals Contoso identifies the following business goals: Migrate the maximum number of users to Microsoft Teams. Minimize administrative effort. Device requirements Contoso identifies the following device requirements: Replace Skype for Business IP phones with Microsoft Teams phones. All Microsoft Teams phones must be set to lock automatically after 60 seconds. Meeting and Live Event Requirements Contoso identifies the following meeting and live event requirements: Requirement1: Guest users must be able to join live events. Requirement2: Guest users must always wait in a meeting lobby. Requirement3: Contoso users must always bypass the meeting lobby when they join by using the Microsoft Teams client. Requirement4: After the upgrade to Microsoft Teams, all meetings must be scheduled by using Microsoft Teams. Calling Requirements Contoso identifies the following calling requirements: Migrate all existing auto attendants and response groups to Office 365. Minimize the on-premises PSTN infrastructure. Technical Requirements Guest users must be prevented from making private calls. Security Requirements Contoso has the following security requirements for the Microsoft Teams deployment: The number of ports allowed on the company?s firewall must be limited. Team names must be prevented from containing the name of any products produced by Contoso. Users in the R&D group must be prevented from sending chat messages to users in other departments. To meet the company?s compliance policy, users in the sales department must continue to use onpremises Skype for Business for IM and calling only. Pilot Project Contoso begins a pilot project for the upgrade to Microsoft Teams. You identify the following issues during the pilot project: Microsoft Teams users report that they often receive continuous notifications from the Microsoft Teams client for 20 minutes. Two pilot users in the HR department report that they are not members of the HR team. QUESTION 1 You need to configure the environment to meet the security requirements for the R&D group. What should you do first?
A. Start the information barrier policy application. B. Add an identity provider. C. Create two information barrier segments. D. Create one information barrier policy.
Answer: C Explanation: Create information barrier segments first, then create information barrier policy based on the segments then start the information barrier application.
QUESTION 2 You need to configure the user accounts of the sales department users to meet the security requirements. What should you do for each user?
A. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Skype for Business with Teams collaboration and meetings coexistence mode. B. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBWithTeamsCollab cmdlet. C. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName Islands cmdlet. D. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Skype for Business coexistence mode.
Answer: A
QUESTION 3 You need to resolve the notification issues identified during the pilot project. What should you modify?
A. the global meeting policy B. the global messaging policy C. the org-wide Teams settings D. the app permission policy
Answer: B
QUESTION 4 You need to configure the environment to meet the technical requirements for guest users. What should you modify from the Microsoft Teams admin center?
A. the global app permission policy B. the Org-wide settings C. the global meeting policy D. the global messaging policy
Answer: B
Explanation: Microsoft Teams admin center > Org-wide settings > Guest access > Make private calls = off.
QUESTION 5 You need to resolve the membership issues for the two pilot users. What should you do?
A. Modify the department attribute of both users. B. Invite both users to the HR team. C. Add both users to the HR group. D. Modify the privacy level of the HR team.
Answer: A QUESTION 6 HOTSPOT You need to recommend which inbound ports to the network and outbound ports to Office 365 must be allowed on the company?s firewall after the planned upgrade. The solution must meet the security requirements. Which inbound and outbound ports should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer: Explanation:
QUESTION 7 You need to configure the user accounts of the sales department users to meet the security requirements. What should you do for each user?
A. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBWithTeamsCollabAndMeetings cmdlet. B. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Islands coexistence mode. C. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName Islands cmdlet. D. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBOnly cmdlet.
Answer: A
QUESTION 8 You need to configure the environment to meet the security requirements for team names. What should you do?
A. From the Security & Compliance admin center, create a sensitivity label and a sensitivity policy. B. From the Microsoft Teams admin center, modify the Teams setting policies. C. From the Azure Active Directory admin center, upload a blocked word list for the group naming policy.
Answer: C
QUESTION 9 HOTSPOT During the pilot project, you review the global policies in the Microsoft Teams admin center. Contoso has a global meeting policy configured as shown in the following exhibit. Contoso has a global live events policy configured as shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer: Explanation:
QUESTION 10 You need to configure the environment to meet the device requirements for the Microsoft Teams phones. What should you do from the Microsoft Teams admin center?
A. Create a configuration profile B. Modify the Teams settings C. Create a meeting policy D. Create a calling policy
