You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns. What are two possible ways to identify the elastic database transaction units (eDTUs)? Each correct answer presents a complete solution.
A. Aggregate data from sys.dm_os_wait_stats.
B. Run the Database Engine Tuning Advisor.
C. Run the Service Tier Advisor.
D. Aggregate data from sys.dm_db_resource_stats.
E. Aggregate data from sys.dm_os_performance_counters.
Microsoft is about to fire thousands of employees around the world in a move to reorganize its sales force.
A source with knowledge of the planned reduction told Elearningexams that the US firm would lay off “thousands” of staff worldwide. The restructuring will include an organizational merger involving its business customer unit and one or more of its SME-focused divisions. The changes are scheduled to be announced next week, we understand.
Microsoft declined to comment.
Earlier this weekend, the Puget Sound Business Journal, Bloomberg and The Seattle Times reported “significant” layoffs related to a move to increase the emphasis on cloud services within Microsoft’s sales teams around the world. Bloomberg said layoffs would be “some of the most significant in the sales force in years.”
The reorganization appears to be the result of a change of leadership last year. Executives Judson Althoff and Jean-Philippe Courtois took over Microsoft’s marketing and sales divisions following the departure of long-time operations director Kevin Turner last summer. Althoff, for example, has been public in its critique of previous sales approaches, and is willing to make Azure a central part of the approach.
In any case, time is right for change, historically. The end of Microsoft’s fiscal year usually falls in July, and in recent years has been a time when the company has announced reductions in workforce.
Last year, Microsoft announced that it would cut 2,850 jobs – including at least 900 of its sales group, according to The Seattle Times – which two months earlier said it would leave 1,850 employees associated with its smartphone business. In July 2015, it made 7,800 job cuts and scored 7.6 billion dollars from its acquisition of Nokia.
You need to modify the environment before you create the QuarterSales report. What should you do?
A. Add a date table to the model that contains columns for the fiscal and calendar quarters.
B. Add a date table to the model that contains measures for the fiscal and calendar quarters.
C. Configure a time dimension by using the Time Intelligence Wizard.
D. Configure SSAS to use a server time dimension.
You need to recommend a disk monitoring solution that meets the business requirements. What should you include in the recommendation?
A. An audit
B. A dynamic management view
C. A maintenance plan
D. A SQL Server Agent alert
You need to implement a solution that meets the data recovery requirements. You update each stored procedure to accept a parameter named @transactionID. What should you add next to the beginning of each stored procedure?
A. SAVE TRANSACTION WITH MARK @transactionID
B. ROLLBACK DISTRIBUTED TRANSACTION @transactionID
C. BEGIN TRANSACTION WITH MARK @transactionID
D. COMMIT TRANSACTION @transactionID
You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the data type for this property?
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Create SSIS configuration files for the packages.
B. Create an Integration Services catalog.
C. Install Data Quality Services.
D. Install Master Data services.
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?
A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function
You work as a Network Administrator at ABC.com. The network contains a single Active Directory Domain Services (AD DS) domain named ABC.com. The network includes servers running various versions of Windows Server 2008. You plan to upgrade all servers in the network to Windows Server 2012.
Some servers run the 32-bit version of Windows Server 2008 Service Pack 2 (SP2) on hardware with x86 CPUs.
Some servers run the 64-bit version of Windows Server 2008 Service Pack 2 (SP2) on hardware with x64 CPUs.
Some servers run Windows Server 2008 R2 on hardware with x64 CPUs. Some servers run Windows Server 2008 R2 Service Pack 1 (SP1) on hardware with x64 CPUs.
Which of the servers can be upgraded directly to Windows Server 2012 without the need to purchase new hardware or install additional service packs?
(Choose all that apply)
A. The servers running the 32-bit version of Windows Server 2008 Service Pack 2 (SP2) on hardware with x86 CPUs.
B. The servers running the 64-bit version of Windows Server 2008 Service Pack 2 (SP2) on hardware with x64 CPUs.
C. The servers running Windows Server 2008 R2 on hardware with x64 CPUs.
D. The servers running Windows Server 2008 R2 SP1 on hardware with x64 CPUs.
You need to recommend which Certificate Services role service must be deployed to the perimeter network. The solution must meet the technical requirements. Which Certificate Services role services should you recommend?
A. Certificate Enrollment Web Service and Certificate Enrollment Policy Web Service
B. Certificate Enrollment Policy Web Service and Certification Authority Web Enrollment
C. Online Responder and Network Device Enrollment Service
D. Online Responder and Certificate Enrollment Web Service