MS-301 Practice Tests
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing You need to meet the data refresh requirements.How should you complete the PowerShell script?
$F = Get-SPFarm $F.Properties.Add("WopiLegacySoapSupport"."<URL>/x/_vti_bin/ExecelSErviceInternal.asmx"); $F.Update();
Your network contains multiple VLANs.You have a SharePoint Server 2019 farm that contains a Microsoft SQL Server Always On availability group. Each SQL Server instance is in a separate VLAN.You need to modify the database replication settings for the SQL Server instances to minimize network latency.How should you complete the PowerShell script?
$a = Get-SPDatabase foreach ($b in $a) { $b.MultiSubnetFailover = $true $b.Update() }
Your company named Litware, Inc. has a SharePoint Server 2019 farm.Litware acquires a company named Contoso, Ltd.You deploy Active Directory Federation Services (AD FS) authentication for users at Contoso to access SharePoint sites. You also deploy a web app namedApp1.You need to ensure that the Contoso users can authenticate to App1 by using AD FS. Users at Litware must continue to authenticate by using the default authentication.Which script should you run to configure the required authentication settings?
$webApp = Get-SPWebApplication https://WebAppur1 $LitwareUsers = NEw-SPAuthenticationProvider- UseWindowsIntegratedAuthentication $ContosoUsers = Get-SPTrustedIdentityTokenIssuer "YourSTS" Set-SPWebApplication -Identity $webApp -AuthenticationProvier $CoontosoUsers, $LitwareUsers -Zone "Default"
You have a SharePoint Server farm.You need to create a page that will display the 20 most recently modified documents from all the site collections in the farm. The results must be displayed in table format. The page must load as quickly as possible.Which three actions should you perform in sequence?
- Add a content search web part - Create a copy of ItemTemplate.html named DisplayTemplate.html and implement the page design. - Publish DisplayTemplate.html
You are configuring a highly available search farm.You have an existing Search Service Application that has a large search index.You discover that the index storage drive is almost full.You add two additional servers to the farm.You need to add an additional index partition to the new servers.Which four actions you should perform in sequence?
- Clone the search topology and add the two index components to the topology - Activate the cloned topology - Pause the Search Service application by using the PauseForIndexRepartitioning() method. - Resume the Search Service Application by using the Resume () method.
You have an on-premises file server that contains a shared folder for each user.You have a Microsoft 365 subscription. Each user uses Microsoft OneDrive for Business.You need to migrate the user data from the file server to the OneDrive for Business site of each user.Which three cmdlets should you run in sequence? To answer, move all cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.
1. Register-SPMTMigration 2. Add-SPMTTask 3. Start-SPMTMigration
You plan to deploy a Business Connectivity Services (BCS) solution.You identify the security requirements shown in the following table. Admin1 - Manage the BCS service. Admin2 - Manage the BCS solution. You need to configure permissions for BCS. The solution must use the principle of least privilege.For which object should you grant permissions to each user? -BDC Model -External Content Type -External System -Metadata Store
Admin1 - Metadata Store Admin2 - External System
You have a SharePoint Server farm.You need to implement hybrid search.Which two service applications are required for hybrid search?
Cloud Search Service Application a User Profile service application
You have a Microsoft SharePoint Server 2019 farm that contains multiple provider-hosted add-ins and a Workflow Manager farm.You run the SharePoint Hybrid Configuration Wizard.Users report that the add-ins and the workflows fail.You need to resolve the issue as quickly as possible.Solution: From the Workflow Manager server, you repair the Workflow Manager, and then you redeploy the provider-hosted add-ins.Does this meet the goal?
No
You have a SharePoint Server farm.You configure the farm to support custom tiles, and you add an item to the custom tiles list.You discover that the new item appears at the bottom of the list in the app launcher.You need to ensure that the new item appears first on the list.Solution: You change the sort order of the custom tiles list.Does this meet the goal?
No
You have a SharePoint Server farm and a Microsoft 365 subscription.You plan to migrate some SharePoint sites to SharePoint Online.You need to identify users who have access to your SharePoint Server on-premises environment and are NOT mapped to a Microsoft Azure Active Directory(Azure AD) account.What should you use?
SharePoint Migration Assessment Tool (SMAT)
You have a SharePoint Server farm.You need to ensure that you can implement a hybrid environment.Which two service applications should you include in the implementation? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
a User Profile service application a Managed Metadata Service application
You have a SharePoint Server farm and a Microsoft 365 subscription.You deploy the On-premises data gateway to your SharePoint Server on-premises environment.You need to configure Microsoft PowerApps to use the gateway.What should you add to PowerApps?
a connection
You have a SharePoint Server farm.You have a document library that stores contracts.You need to ensure that any changes to the documents in the library can be tracked.What should you use?
an information management policy
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing You need to deploy hybrid OneDrive for Business to all the remaining users.Which three actions should you perform in sequence?
- Create an audience named Audience1 from a User Profile service application. - From Central Administration, run the Hybrid Configuration Wizard. Select Hybrid OneDrive an Mysite Creation default to OneDrive in O365. - From the configure hybrid OneDrive and Site features page, set the audience to Audience1.
You plan a SharePoint Server farm. The farm contains a web application that has a URL of https://portal.contoso.com.Users use smart cards to sign in to domain-joined computers.You need to configure SharePoint Server to support smart card authentication.Which four actions you perform in sequence?
- Deploy AD FS and set localAuthenticationTypes to TlsClient in Web.Config - Create a relying party that use SAML 2.0 Web SSO and export the token-signing certificate - Import the token-signing certificate to SharePoint Server and create a new SPTrustedIdentityTokenIssuer. - Associate the web application of the portal to SPtrustedIdentityTokenIssuer.
You have a SharePoint Server farm that supports 30,000 users. The farm contains the servers shown in the following table. WFE1, WFE2 - Front-end server App1, App2 - Application Server Search1, Search2 - Search Server DC1, DC2 - Distributed cache server SQL1, SQL2 - Microsoft Sql Server cluster You plan to install a cumulative update (CU) in the farm. All patch files are downloaded and available on a network share.You need to install the CU without causing any downtime.In which order should you perform the actions?
- Enable the side by side file copy process by using PowerShell - Remove WFE1 from the load balancer, install the patch files, restart WFE1, and then add WFE1 to the load balancer. Repeat the process for WFE2. - Install the patch files on App1, Search1, and DC1. Install the CU on App2, Search2, and DC2. - Remove WFE1 from the load balancer, run psconfig.exe, and then add WFE1 to the load balancer. Repeat the process for WFE2. - Run psconfig.exe on App1, Search1, and DC1, and then run psconfig.exe on App2, Search2, and DC2.
You have a SharePoint Server 2019 farm. The servers are configured as shown in the following table. Server1, 2 - Web Front End - 12GB Server3, 4 - DistributedCache - 8GB Server5, 6 - Search - 64GB Server7, 8 - Application - 64GB You recently added 32 GB of RAM to each Distributed Cache server.You discover that the Distributed Cache servers only use 3 GB of memory.You need to ensure that the Distributed Cache servers use more than 8 GB of memory for site feeds.Which three actions should you perform in sequence?
- From Server3 and 4, stop the Distributed Cache service. - From Server 1, run Update-SPDistributedCacheSize-CacheSize 16384 - From Server3, and 4, start the Distributed Cache service.
You have a SharePoint Server farm and a SharePoint Online subscription.You need to configure cloud hybrid search.You complete the Hybrid Configuration wizard.Which four actions should you perform in sequence next? - Create a Search Service Application - Run On-Board-CloudHybridSearch.ps1. - Install the SharePoint Online Management Shell. - Run CreateCloudSSA.ps1 to create and configure a Cloud Search Service Application. - Install the MS Azure AD Powershell module and the MS Online services sign-in assistant - Create a content source and start a full crawl.
- Install the MS Azure AD Powershell module and the MS Online services sign-in assistant - Run CreateCloudSSA.ps1 to create and configure a Cloud Search Service Application. - Run On-Board-CloudHybridSearch.ps1. - Create a Search Service Application
Your company has a SharePoint Server hybrid deployment.You are creating a Microsoft Azure logic app that must access data from a list hosted in your SharePoint Server on-premises environment.You need to ensure that the logic app can access data from the list. All communication to the on-premises environment must be done through an encrypted channel.Which three actions should you perform in sequence? - Install the On-premises data gateway. - Use a SharePoint connector from the logic app. - Install a VPN gateway. - Install an Azure ExpressRoute gateway - Configure connectivity to use HTTPS
- Install the On-premises data gateway. - Use a SharePoint connector from the logic app. - Configure connectivity to use HTTPS
You plan to upgrade a SharePoint Server 2016 farm to SharePoint Server 2019.You deploy SharePoint Server 2019 and you create a new farm.You need to complete the upgrade to SharePoint Server 2019.Which five actions should you perform in sequence?
- Set the content databases to read-only mode - Back up the content databases, restore the databases, and then disable read-only mode - Configure service applications - Create new web applications - Attach the content databases
You have a SharePoint Server 2019 farm that contains thousands of term sets and terms.You deploy hybrid SharePoint taxonomy and hybrid content types.From a SharePoint server, you sign in by using a user account named SPAdmin.You run copy-SPTaxonomyGroups and receive an Access Denied error.You need to copy the term sets to SharePoint Online successfully.What should you do?
Add SPAdmin to the Term Store Administrators group.
You have a SharePoint Server farm and a Microsoft Office 365 subscription.You implement hybrid search.You discover that some search results are not hybrid search results. You discover that only the Domain Users security group is granted permissions to the content.You need to resolve the issue.What should you do?
Add all users to a new domain group. Grant the new domain group permissions to the content. Perform a full crawl.
You plan to deploy the following three SharePoint Server farms: a content farm, a services farm, and a search farm.Which two roles are required in the services farm?
Application Distributed Cache
You are configuring four servers in a small SharePoint Server farm.You plan to provide minimum high availability by using the MinRole topology.You need to configure roles for the SharePoint servers.Which two roles should you configure?
Application with Search Front-end with Distributed Cache
You have an on-premises file server that contains 30 TB of data.You purchase a SharePoint Online subscription.You need to recommend a solution to migrate your content to SharePoint Online. The solution must minimize network traffic.What should you include in the recommendation?
Azure Data Box
Your company has a SharePoint Server farm. All servers are virtualized on a Hyper-V host. The company has a single data center.You need to design a disaster recovery solution. The solution must meet the following requirements:-> If the data center fails, SharePoint Server services must be recoverable within 24 hours.-> Up to one hour of data can be lost.-> Costs must be minimized during normal operations.Which technology best meets the requirements?
Azure Site Recovery
You are planning the implementation of a SharePoint hybrid environment that will contain the following workloads:-> Workload1: An external list exposing data from a public OData service endpoint.-> Workload2: An external list exposing data from a Microsoft Azure SQL database.-> Workload3: A site that contains a sandbox solution.-> Workload4: A Microsoft Flow workload.Which workload can run only in the SharePoint Server farm and which workload can run only in SharePoint Online? To answer, drag the appropriate workloads to the correct environments. Each workload may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Can run only in the SharePoint Server farm: Can run only in SharePoint Online:
Can run only in the SharePoint Server farm: 3 Can run only in SharePoint Online: 2
You manage a SharePoint hybrid environment that is configured to use hybrid managed metadata.The on-premises SharePoint Server environment contains a term group named TermGroup1. An Active Directory group named Group1 is configured as the GroupManager of TermGroup1. Group1 contains a user named User1.You need to migrate TermGroup1 to SharePoint Online. The solution must meet the following requirements:-> Ensure that User1 can manage TermGroup1.-> Use the principle of least privilege.What should you do?
Change the Group Manager to User1, and then run the Copy-SPTaxonomyGroup cmdlet.
You have a SharePoint Server farm that is configured for Reporting Services integration mode.You have a Microsoft SQL Server Reporting Services (SSRS) report on a SQL server that uses only Windows authentication.You need to ensure that the farm can access the SSRS report.What should you configure?
Claims to Windows Token Service
You have a SharePoint Server farm.You create a Managed Metadata Service application.You plan to create site columns and site content types that will be used by all the site collections.You need to publish the site columns and the site content types to the site collections.Which three actions should you perform?
Configure the properties of the Managed Metadata Service application. Activate Content Type Syndication Hub for a site collection. Configure the connection properties of the Managed Metadata Service application.
You have a SharePoint Server farm.You have document libraries that contain multiple content types.You need to replicate the content types to SharePoint Online.Which PowerShell cmdlet should you run?
Copy-SPContentTypes
You have a SharePoint Server farm and a SharePoint Online subscription. The farm has a URL of https://sharepoint.contoso.com. The SharePoint Online subscription has a URL of https://contoso.sharepoint.com.You need to migrate the folksonomy from the farm to SharePoint Online.How should you complete the PowerShell script? To answer, select the appropriate options in the answer area.
Copy-SPTaxonomyGroups -LocalTermStoreName "Managed Metadata Service Application Proxy" LocalSiteUrl https://sharepoint.contoso.com -RemoteSiteUrl https://contoso.sharepoint.come -Group "System"
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing You need to meet the technical requirements for the research department term sets.How should you complete the PowerShell script?
Copy-SPTaxonomyGroups -LocalTermStoreName "Managed Metadata Service" -LocateSiteUrl "https://portal.contoso.com" -GroupNames "Research" -Credential $credential -RemoteSiteUrl "https://contoso.admin.sharepoint.com
You are planning the backup strategy for a SharePoint Server farm.You need to back up content databases automatically every week. The solution must minimize the backup size.What should you do?
Create a scheduled task that runs Backup-SPFarm.
Your company has a SharePoint Server farm.Each department at the company has an associated Active Directory group.You plan to deploy a Business Connectivity Services (BCS) solution for all the users in the human resources (HR) department. BCS will connect to a MicrosoftSQL Server named SQL1. SQL1 uses SQL Server Authentication.You need to ensure that BCS can access SQL1. Authentication credentials and connection information must be encrypted.What should you do?
Create a target application that uses a Target Application Type of Group. Add a new field named ConnectionString and set the field type to Generic. Set the credentials for the target application.
You have a SharePoint Server 2019 farm. The farm contains several Microsoft Office documents. All the documents have a property named Division that is populated automatically based on the document’s author.You create a text managed property that is retrievable and queryable, and you map the managed property to the Division property.You need to find only the documents that have the Division property set to Legal.For what should you search?
Division=Legal
You have a SharePoint Server farm.You need to configure the farm to support adding links to the app launcher.How should you complete the PowerShell script?
Enable-SPFeature -Identity CustomTiles -Url http://web_app $w = Get-SPWeb http://web_app $w.Properties. CustomTilesListHostUrl = http://web_app $w.Update()
Your company has a SharePoint Server farm.The human resources (HR) department at the company has a site that has a URL of http://contoso.com/hr.You need to back up the HR department site every eight hours by using PowerShell. The backup must complete as quickly as possible.How should you complete the command?
Export-SPWeb http://contoso.com/hr -Path d:\backup -NoFileCompression -NoLogFile
You have a SharePoint Server farm and a Microsoft Office 365 tenant.You plan to implement hybrid Microsoft OneDrive for Business for all users.You need to ensure that the users can create a OneDrive for Business site in a hybrid configuration and use the social and collaboration features.Which two user permissions should you assign to authenticated users?
Follow People and Edit Profile for the User Profile service application Create Personal Site for the User Profile service application
You have an on-premises Microsoft SharePoint Server 2019 farm.You need to ensure that users can search for user information by using Search in SharePoint.You create a content source for the user profiles.What should you do next?
From Administrators for User Profile Service Application, add a content crawl account and assign Retrieve People Data for Search Crawlers permissions.
You have a SharePoint Server farm and a SharePoint Online subscription.You implement inbound hybrid search.You need to ensure that SharePoint Online users can return search results from the farm.What should you do?
From SharePoint Online, create a Remote SharePoint result source.
You have a SharePoint Server farm that has one web application. The web application contains one site collection. The site collection contains one site.You need to enable managed navigation.What should you do?
From Site Features, activate SharePoint Server Publishing.
You have a SharePoint Server farm.You plan to migrate a SharePoint site collection to SharePoint Online.You need to view any issues that can cause the migration to fail.What should you do?
From site collection settings, run site collection health checks.
You have a hybrid deployment of SharePoint Server 2019 and Microsoft 365.You need to ensure that only the members of an Active Directory security group named Group1 can access personal OneDrive for Business sites online.Which two actions should you perform? Each correct answer presents part of the solution.
From the SharePoint Hybrid Configuration Wizard, add an audience. From SharePoint Server 2019, create an audience for Group1.
You have a SharePoint Server farm.You configure the farm to support custom tiles, and you add an item to the custom tiles list.You open a web browser and discover that the new item does not appear in the app launcher.You need to ensure that the tile appears immediately in the app launcher.What should you do?
From the developer tools of the web browser, run the ClearSuiteLinksCache() function.
You have a SharePoint Server farm.You create an external content type that exposes data from a Microsoft SQL Server database.You need to ensure that a user can access the data exposed by the type.What should you do?
Grant the user the Execute permission for the type.
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing You need to meet the technical requirements for the external content types of the marketing department.
HR department users: Execute Research department users: Edit and Execute Contractors: Execute and Selectable in Clients only
You have a SharePoint Server farm.You have a term set named Departments.You need to promote Departments to be used for managed navigation.Which settings should you modify from the Terms Store Management Tool?
Intended Use
Your company has a SharePoint Server farm.You are planning the authentication methods for internal users, users at a partner company, and individual external researchers.The company does NOT manage the identities of the partner company users and the external researchers.You need to configure authentication for the internal users, partner company users, and external researchers.Which authentication method should you configure for each type of user?
Internal users - Windows authentication External researches - SAML authentication with Windows LiveID Partner company users - SAML authentication with AD FS
You have a SharePoint Server farm and a SharePoint Online subscription.The farm contains the lists shown in the following table. List1 - Report Library List2 - ExternalList List3 - Promoted Link List List4 - GanttTasks List5 - PictureLibrary Which two lists can you migrate to SharePoint Online by using the SharePoint Migration Tool? Each correct answer presents a complete solution.
List5 List4
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing What should you recommend using to meet the requirements for the user profile page?
Microsoft Azure Active Directory (Azure AD) Connect
You have a SharePoint Server farm and a Microsoft 365 subscription.You plan to deploy the On-premises data gateway.Which three cloud services can use the gateway to access SharePoint data?
Microsoft PowerApps Microsoft Planner Microsoft Flow
You have a SharePoint Server farm.You need to create an external content type to connect to a table in a Microsoft Azure SQL database.What should you use to create the external content type?
Microsoft SharePoint Designer
You have a SharePoint Server farm.You plan to provide users who have a Microsoft account, such as hotmail.com with access to sites in the farm.You need to create a new web application that supports authenticating the Microsoft accounts.How should you complete the PowerShell script?
New-SPAuthenticationProvider Get-SPTrustedIdentityTokenIssuer New-SPWebApplication
You have a SharePoint Server farm and a SharePoint Online subscription.You need to implement cloud hybrid search.Which cmdlet should you run as part of the implementation? To answer, select the appropriate options in the answer area.
New-SPEnterpriseSearchServiceApplication -Name $SearchServiceAppName -ApplicationPool $appPool -DatabaseServer $DatavaseServerName -CloudIndex $true
You have a SharePoint Server farm.You have several document libraries that contain AutoCAD files.You discover that search results never return any of the AutoCAD files.You need to crawl the AutoCAD files.Which cmdlet should you run?
New-SPEnterpriseSearchfileFormat
You have a Microsoft SharePoint Server 2019 farm that contains multiple provider-hosted add-ins and a Workflow Manager farm.You run the SharePoint Hybrid Configuration Wizard.Users report that the add-ins and the workflows fail.You need to resolve the issue as quickly as possible.Solution: From the server hosting the provider-hosted add-ins, you redeploy the add-ins, and then you recreate the workflows.Does this meet the goal?
No
You have a SharePoint Server farm and a SharePoint Online subscription.You plan to perform a bulk migration by using the SharePoint Migration Tool.You create the following CSV file. (Line numbers are included for reference only.) 01 Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder 02 C:\Docs\,,,https://contoso.sharepoint.com/sites/Documents/,, 03 https://contoso.com/sites/site1/,Docs,,https://contoso.sharepoint.com/sites/Documents/,Corporate, You need to modify the CSV file to ensure that the bulk migration will complete successfully.Solution: At line 03, you change https://contoso.com/sites/site1/ to use http.Does this meet the goal?
No
You have a SharePoint Server farm and a SharePoint Online subscription.You plan to perform a bulk migration by using the SharePoint Migration Tool.You create the following CSV file. (Line numbers are included for reference only.) 01 Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder 02 C:\Docs\,,,https://contoso.sharepoint.com/sites/Documents/,, 03 https://contoso.com/sites/site1/,Docs,,https://contoso.sharepoint.com/sites/Documents/,Corporate, You need to modify the CSV file to ensure that the bulk migration will complete successfully.Solution: You change line 02 to use a UNC path instead of a local file path.Does this meet the goal?
No
You have a SharePoint Server farm and a SharePoint Online subscription.You plan to perform a bulk migration by using the SharePoint Migration Tool.You create the following CSV file. (Line numbers are included for reference only.) 01 Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder 02 C:\Docs\,,,https://contoso.sharepoint.com/sites/Documents/,, 03 https://contoso.com/sites/site1/,Docs,,https://contoso.sharepoint.com/sites/Documents/,Corporate, You need to modify the CSV file to ensure that the bulk migration will complete successfully.Solution: You remove the TargetDocLib value from line 03.Does this meet the goal?
No
You have a SharePoint Server farm.A user attempts to create a site column named RequestType that uses a managed metadata term set named RequestTypes as metadata. The user reports thatAllow ‘Fill-in’ choices are set to No, and the option cannot be configured.You need to ensure that the user can set Allow ‘Fill-in’ choices to Yes.Solution: From Intended Use, you clear Available for Tagging.Does this meet the goal?
No
You have a SharePoint Server farm.You configure the farm to support custom tiles, and you add an item to the custom tiles list.You discover that the new item appears at the bottom of the list in the app launcher.You need to ensure that the new item appears first on the list.Solution: You run the Add-PnpNavigationNode cmdlet and specify the â€"first parameter.Does this meet the goal?
No
You have a SharePoint Server farm.You configure the farm to support custom tiles, and you add an item to the custom tiles list.You discover that the new item appears at the bottom of the list in the app launcher.You need to ensure that the new item appears first on the list.Solution: You run the Set-SPWebApplication cmdlet and specify the â€"AssignmentCollection parameter.Does this meet the goal?
No
You have an on-premises SharePoint Server 2019 farm that is configured to import user profiles from Active Directory by using SharePoint Active Directory import(AD import).You need to prevent all disabled users from being imported into SharePoint user profiles.Solution: From Configure Synchronization Settings, you select Enable External Identity Manager.Does this meet the goal?
No
You have an on-premises SharePoint Server 2019 farm that is configured to import user profiles from Active Directory by using SharePoint Active Directory import(AD import).You need to prevent all disabled users from being imported into SharePoint user profiles.Solution: From the Profile Import Connection page, you modify the profile import connection.Does this meet the goal?
No
You have an on-premises SharePoint Server 2019 farm that is configured to import user profiles from Active Directory by using SharePoint Active Directory import(AD import).You need to prevent all disabled users from being imported into SharePoint user profiles.Solution: You deploy Microsoft Identity Manager (MIM).Does this meet the goal?
No
You have a SharePoint Server farm and a Microsoft 365 subscription.A user named User1 plans to connect to a SharePoint list from Microsoft Power BI and create a Power BI report.You need to recommend a solution to provide User1 with the required access. Only User1 requires access to the report.What should you include in the recommendation?
Personal Gateway
You have a SharePoint Server farm.You have an OData service that uses OAuth authentication.You need to create an external content type that will access the OData service.Which type of data source should you use?
REST Service Connection
Your company has a security policy requiring that all service account passwords be changed every 90 days.You need to enforce the policy by using the minimum amount of effort.
Register managed accounts in Central Administration.
You manage a SharePoint hybrid environment that contains an on-premises web application named webapp1.You plan to configure self-service site creation in webapp1 to create sites in SharePoint Online instead of on-premises SharePoint Server.From Central Administration, you open Configure self-service site creation, but you do not see the Create Site Collections in SharePoint Online option.You need to ensure that you can enable the option.What should you do first?
Run the Hybrid Picker.
You have a SharePoint Server farm.You plan to migrate a SharePoint site collection to SharePoint Online.You need to view any issues that can cause the migration to fail.What should you do?
Run the Test-SPSite cmdlet.
Your company has a SharePoint Server farm.The company has a partner company that uses Microsoft 365.You need to provide the users at the partner company with access to sites in the farm.Which authentication method should you use?
SAML token-based authentication
You have a SharePoint Server farm and a Microsoft 365 subscription.You plan to migrate some SharePoint sites to SharePoint Online. You do NOT plan to migrate alerts.You need to use the SharePoint Migration Assessment Tool (SMAT) to identify potential migration issues. The solution must prevent assessing alert issues.Which file should you modify before you run SMAT?
ScanDef.json
You have two SharePoint Server farms named Farm1 and Farm2.In Farm1, you need to display search results from both farms.What should you use?
Search result source to use: Remote SharePoint Web part to use: Content Search
You have a SharePoint Server farm.You need to add enterprise keywords to the term store.To which term group should you add the keywords?
System
You have a SharePoint Server 2019 farm that contains thousands of term sets and terms.You deploy hybrid SharePoint taxonomy and hybrid content types.You need to ensure that the term sets and terms sync every hour.Which timer job should you modify?
Taxonomy Groups Replication
You create a new color palette and font schemes.You need to use the new palette and schemes to customize your SharePoint Server environment.Where should you add the files you created?
Theme Gallery
You have a SharePoint Server farm.You plan to use a Managed Metadata Service application.You need to disable folksonomy.Which option should you disable from the Managed Metadata Service Connection properties?
This service application is the default storage location for Keywords.
You have SharePoint Server farm and a Microsoft 365 subscription.You use Microsoft Azure Active Directory (Azure AD) Connect to sync accounts.You have a file server that contains a file named File1. File1 contains the permissions shown in the following table. User 1 - Full control set to Allow User 2 - Read set to Allow - Write set to allow User 3 - Read set to Allow - Write set to deny You migrate the share that contains File1 to SharePoint Online by using the SharePoint Migration Tool.Which permission does each user have to File1 in SharePoint Online? To answer, drag the appropriate permissions to the correct users. Permissions: Contribute, read, none
User 1 - Contribute User 2 - Contribute User 3 - Read
You have a SharePoint Server farm. The farm contains a site collection named HRSite. HRSite contains a root site and a site named JobPosts.Two users named User1 and User2 plan to create search result sources for different file shares.You need to grant permissions to User1 and User2 to meet the following requirements:-> User1 can create result sources in all the sites in HRSite.-> User2 can create result sources in the JobPosts site.-> The solution must use the principle of least privilege.To which group should you add each user? Groups: - Hierachy Managers - Search Service Application admin - SharePoint admins - Site collection admins - Site owner
User1 - Site collection admins User2 - Site owner
You have a SharePoint Server farm and a SharePoint Online subscription.You start a data migration by using the SharePoint Migration Tool.After several hours, the migration fails. The migration log shows the following error message: “429 â€" Too many requests.â€You need to complete the migration.What should you do?
Wait 24 hours, and then start an incremental migration job.
You have a Microsoft SharePoint Server 2019 farm that contains multiple provider-hosted add-ins and a Workflow Manager farm.You run the SharePoint Hybrid Configuration Wizard.Users report that the add-ins and the workflows fail.You need to resolve the issue as quickly as possible.Solution: From the SharePoint 2019 Management Shell, you update the realms for the provider-hosted add-ins and the Workflow Manager.Does this meet the goal?
Yes
You have a SharePoint Server farm and a SharePoint Online subscription. You plan to perform a bulk migration by using the SharePoint Migration Tool.You create the following CSV file. (Line numbers are included for reference only.) 01 Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder 02 C:\Docs\,,,https://contoso.sharepoint.com/sites/Documents/,, 03 https://contoso.com/sites/site1/,Docs,,https://contoso.sharepoint.com/sites/Documents/,Corporate, You need to modify the CSV file to ensure that the bulk migration will complete successfully.Solution: At line 02, you specify a target document library and you delete line 01.Does this meet the goal?
Yes
You have a SharePoint Server farm.You configure the farm to support custom tiles, and you add an item to the custom tiles list.You discover that the new item appears at the bottom of the list in the app launcher.You need to ensure that the new item appears first on the list.Solution: You change the Tile Order value for the custom tile.Does this meet the goal?
Yes
You have an on-premises SharePoint Server 2019 farm that is configured to import user profiles from Active Directory by using SharePoint Active Directory import(AD import).You need to prevent all disabled users from being imported into SharePoint user profiles.Solution: From the Profile Import Connection page, you add connection filters.Does this meet the goal?
Yes
You have a SharePoint Server farm.You configure the User Profile service.You add a new attribute mapping for users.The users report they cannot see the new attribute in their profile.You need to ensure that the new attribute is displayed for all users as quickly as possible.What should you run?
a full profile synchronization
You have a SharePoint hybrid environment.When you run a search on-premises, you do not see any results from SharePoint Online on the results page.You need to ensure that SharePoint Online results appear on the search results page along with the results from on-premises SharePoint Server.Which two objects should you create?
a result source in on-premises SharePoint Server a query rule in on-premises SharePoint Server
You have a SharePoint Server farm that contains a Secure Store Service application and a Business Data Connectivity (BDC) service application. You have a site named Marketing that is used by all the users in the marketing department.You have an OData service named Service1 that is used only by the users in the marketing department. Service1 requires authentication. The identity used to access Service1 is managed by Service1.You need to ensure that users can create a list in SharePoint Server that accesses data from Service1.What should you create first?
a target application that uses a Target Application Type of Group
You have a SharePoint Server farm and a SharePoint Online subscription.You need to ensure that a new administrator named Admin1 can create a Search Service Application. The solution must use the principle of least privilege.Which two Microsoft SQL Server roles should you assign to Admin1?
dbcreator securityadmin
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing Which two types of components should you add to the farm?
dedicated front-end crawl servers distributed cache servers
You have a SharePoint Server farm that contains a term store.The root site collection uses a URL of https://contoso.com/.You need to find all the terms used by the root site collection.
https://contoso.com/lists/taxonomyhiddenlist/allitems.aspx
You have a SharePoint Server 2019 farm and a SharePoint Online subscription.You configure hybrid Microsoft OneDrive.You need to ensure that hybrid users can follow documents in the farm by using Microsoft Delve.What should you implement?
hybrid search
You have a SharePoint Server farm.You have the following three types of document libraries: expense reports, purchase orders, and invoices. Each document in the libraries has an associated project code and cost center.You need to ensure that when users check in expense reports, purchase orders, and invoices, the documents are associated to a project code and a cost center.The project code and cost center must be in a consistent format across all the document libraries. The solution must minimize administrative effort.What should you include in the solution?
managed properties
Your company has documents in both on-premises SharePoint Server and SharePoint Online.Currently, users must search each environment for results.You need to recommend a solution to ensure that searches performed from SharePoint Online contain results from on-premises SharePoint Server.What should you include in the recommendation?
multi-tenancy
Contoso, Ltd. - https://docs.google.com/document/d/1CJm7P6eFHsXchs0DykT1Q3XpAdiI3-7-pkjW-80wQUg/edit?usp=sharing Where is the best location to deploy the On-premises data gateway? More than one answer choice may achieve the goal.
on a new domain-joined server
You have a SharePoint hybrid environment.You have the following PowerShell script. https://gyazo.com/93f16e52974aa10748a44ed62b83af07 What is the effect of running the script?
replaces an expired certificate for Microsoft Azure Active Directory (Azure AD) and on-premises SharePoint Server.
You have a SharePoint Server farm and a SharePoint Online subscription.You plan to configure a SharePoint hybrid environment.You need to identify which groups and roles must be assigned to your user account to implement the deployment. The solution must use the principle of least privilege.Which three roles and groups should you identify?
the Farm Administrators group in SharePoint the Domain Admins group in Active Directory the Global administrator role in Microsoft Office 365
You have a SharePoint Server farm.You have a Microsoft Office 365 subscription.You need to ensure that all user profile data is stored in Office 365.What should you implement?
the On-premises data gateway
