Question : 3
You administer Windows 10 Enterprise desktop computers that are members of an Active Directory domain. You want to create an archived copy of user profiles that are stored on the desktops. You create a standard domain user account to run a backup task. You need to grant the backup task user account access to the user profiles. What should you do?
A. Add the backup task account to the Remote Management Users group on a domain controller.
B. Add the backup task account to the Backup Operators group on every computer.
C. Add the backup task account to the Backup Operators group on a domain controller.
D. Set the backup task account as NTFS owner on all the profiles.
You need to update the CreateMonthlyTotalsReports() method to use database transactions. Which code segment should you use?
* Scenario: The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or inserting new rows until complete.
A range lock is placed on the DataSet, preventing other users from updating or inserting rows into the dataset until the transaction is complete.
You need to recommend a solution for the sales reports. What should you include in the recommendation?
A. BranchCache in distributed cache mode
B. Offline files
C. BranchCache in hosted cache mode
D. Distributed File System (DFS)
Question : 23
You need to ensure that app developers have the necessary permission to submit apps for deployment. Which permission level should you grant to the SharePoint_App_Dev group?
A. App Manager permission level to the Central Administration site
B. Full Control permission level to the App Store site
C. Contribute permission level to the App Store site
D. Farm Administrator permission level to ContentFarm
E. Full Control permission level to the Central Administration site
You need to meet the performance and scalability requirements. Which SQL Database configuration should you use?
A. Use the S1 performance level for On-Peak mode.
B. Use the P2 performance level for On-Peak mode.
C. Use the S2 performance level for On-Peak mode.
D. Use the P1 performance level for On-Peak mode.
You need to configure session storage in the web.config file to meet the technical requirements for scalability. Which Session State mode should you use? (Each correct answer presents a complete solution. Choose all that apply.)
ASP.NET session state supports several different storage options for session data. Each option is identified by a value in the SessionStateMode enumeration. The following list describes the available session state modes:
InProc mode – stores session state in memory on the Web server. This is the default.
StateServer mode/OutProc – stores session state in a separate process called the ASP.NET state service. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.
SQLServer mode – stores session state in a SQL Server database. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.
Custom mode – custom storage provider. Off mode, which disables session state.
A company deploys Enterprise Search for SharePoint Server 2013. Some crawls of result sources fail to complete. You need to examine detailed information about crawl rate, crawl latency, crawl freshness, content processing, CPU and memory load, continuous crawls, and the crawl queue to determine how you should alter crawling. What should you review?
A. Microsoft Search Server performance counters
B. The crawl log
C. Crawl-health reports
D. Unified Logging Service (ULS) logs
Crawl-health reports provide detailed information about crawl rate, crawl latency, crawl freshness, content processing, CPU and memory load, continuous crawls, and the crawl queue.
Not A: Microsoft Search Server performance counters would not provide any crawl data. Not B: The crawl log would not provide such detailed information. The crawl log tracks information about the status of crawled content. The log includes views for content sources, hosts, errors, databases, URLs, and history.
Not D: ULS logs would not provide any crawl data.
You have a database application that uses Microsoft SQL Server 2012. You have a query named Query1 that returns four columns from a frequently updated table that has a clustered index. Three of the columns are referenced in the WHERE clause of the query. The three columns are part of a non-clustered index. The fourth column is not referenced in the WHERE clause. Users report that the application begins to run slowly. You determine that the root cause for the performance issue is Query1. You need to optimize the statement. What should you do?
A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.
SET SHOWPLAN_XML (Transact-SQL) causes SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are going to be executed in the form of a well-defined XML document. Incorrect:
Not F: Columnstore indexes in the SQL Server Database Engine can be used to significantly speed-up the processing time of common data warehousing queries. Typical data warehousing workloads involve summarizing large amounts of data. But in this question the query is run on a table that is updated frequently, not a warehousing table.
Reference: SET SHOWPLAN_XML (Transact-SQL)
You are planning an upgrade strategy for an existing Azure application. Multiple instances of the application run in Azure. The management team is concerned about application downtime, due to a business service level agreement (SLA). You are evaluating which change in your environment will require downtime. You need to identify the changes to the environment that will force downtime. Which change always requires downtime?
A. Adding an HTTPS endpoint to a web role
B. Upgrading the hosted service by deploying a new package
C. Changing the value of a configuration setting
D. Changing the virtual machine size
Which of the following DBCC commands shows optimizer statistics for objects such as tables?
You are migrating an existing solution to Azure. The solution includes a user interface tier and a database tier. The user interface tier runs on multiple virtual machines (VMs). The user interface tier has a website that uses Node.js. The user interface tier has a background process that uses Python. This background process runs as a scheduled job. The user interface tier is updated frequently. The database tier uses a self-hosted MySQL database. The user interface tier requires up to 25 CPU cores. You must be able to revert the user interface tier to a previous version if updates to the website cause technical problems. The database requires up to 50 GB of memory. The database must run in a single VM. You need to deploy the solution to Azure. What should you do first?
A. Deploy the entire solution to an Azure website. Use a web job that runs continuously to host the database.
B. Deploy the database to a VM that runs Windows Server on the Standard tier.
C. Deploy the entire solution to an Azure website. Run the database by using the Azure data management services.
D. Deploy the user interface tier to a VM. Use multiple availability sets to continuously deploy updates from Microsoft Visual Studio Online.
Your role of Network Administrator at ABC.com includes the management of the Active Directory Domain Services (AD DS) domain named ABC.com. The network includes servers that run Windows Server 2008 R2 Service Pack 1 (SP1) and Windows Server 2012. The network includes a Windows Server 2012 server named ABC-File1. ABC-File1 runs the File and Storage Services server role. You need to increase the file storage space on ABC-File1. You attach four new physical hard disks to ABC-File1. You need to configure the disks to ensure that no data is lost in the event of a single disk failure while maximizing the storage space that can be used on the disks. How should you configure the disks?
A. You should create a RAID 0 volume.
B. You should create a RAID 1 volume.
C. You should create a storage space using the spanned option.
D. You should create a storage space using the mirror option.
E. You should create a storage space using the parity option.
You are modifying a blog site to improve search engine readability.
You need to group relevant page content together to maximize search engine readability.
Which tag should you use?
The <article> tag specifies independent, self-contained content :
An article should make sense on its own and it should be possible to distribute it independently from the rest of the site.
Potential sources for the <article> element :
You are the Office 365 Administrator for your company. You manage SharePoint Online for an Office 365 tenant. The site collection administrator receives an email message reporting that the resource usage reaches the warning level . you need to increase the resource quota for the site collection . which windows powershell cmdlet should you run?
A company migrates to Office 365. 2,000 active users have valid Office 365 licenses assigned. An additional 5,000 user accounts were created during the migration and testing processes. These users do not have any licenses assigned. You need to remove the Office 365 user accounts that do not have any licenses assigned by using the least amount of administrative effort. Which Windows PowerShell command should you run?
A. Get-MsolUser -All -EnabledFilter “DisabledOnly” | Remove-MsolUser -Force
B. Get-MsolUser-EnabledFilter “DisabledOnly” | Remove-MsolUser -Force
C. Get-MsolUser -All -UnlicensedUsersOnly | Remove-MsolUser -Force
D. Get-MsolUser -UnlicensedUsersOnly | Remove-MsolUserForce
You are the administrator for a large company. You plan to implement servers in the environment that do not use local hard drives. You need to recommend a supported storage solution. Which technology should you recommend?
A. Clustered NAS
B. Cloud storage
C. USB flash drive