You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
– Report utility functions and business logic in code
– Standardized report formatting properties such as fonts and colors for report branding
– Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution.
You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a report as a template. Apply standardized formatting to the template.
Store code in the Code section of the template.
B. Build a web service that retrieves formatting properties and runs code.
Call the web service through a report dataset.
C. Store the formatting properties and code in database objects.
Use stored procedures to populate a default value for report parameters and map each parameter
to a corresponding formatting property.
D. Create an assembly that contains formatting properties and code.
Deploy the assembly on the Reporting Server and reference the assembly from each report.
You use SQL Server 2014 to maintain the data used by applications at your company.
You want to execute two statements.
You need to guarantee that either both statements succeed, or both statements fail together as a batch.
Which code should you use?
A. Option A
B. Option B
C. Option C
D. Option D
E. Option E
Structure should be:
You have a System Center 2012 Virtual Machine Manager (VMIM) infrastructure that contains a server named Server1. Server1 hosts the VMM library. You add a server named Server2 to the network. You install the Windows Deployment Services (WDS) server role on Server2.
You have the Install.wim file from the Windows Server 20008 R2 Service Pack 1 (SP1) installation media. You need to install Hyper-V hosts by using the bare-metal installation method.
What should you do first?
A. Convert Install.wim to a .vmc file.
B. Convert Install.wim to a .vhd file.
C. Add Install.wim to the VMM library.
D. Add Install.wim to the Install Images Container.
For the bare metal deployment, you need an operating system and one of the first steps to take is to create a bootable VHD for that operating system. This is done by using the WIM2VHD tool to take the install.wim file from your Windows Server 2008 R2 SP1 installation media and convert it.
You plan to deploy a System Center 2012 infrastructure. You plan to create and deploy a service named CloudService1.
You need to recommend a solution to deploy CloudService1 to a Windows Azure subscription.
What should you include in the recommendation?
A. System Center 2012 Service Manager
B. System Center 2012 Orchestrator
C. System Center 2012 Operations Manager
D. System Center 2012 App Controller
App Controller allows a user to view, manage, and deploy services to both a private cloud (via Virtual Machine Manager) and the Public Windows Azure Cloud in a consistent template driven manner. App Controller also allows you to connect to multiple Windows Azure subscriptions and then delegate subscription access out to users via their Active Directory credentials
Your network contains a RADIUS server named Server1.
You install a new server named Server2 that runs Windows Server 2012 R2 and has Network Policy Server (NPS) installed.
You need to ensure that all accounting requests for Server2 are forwarded to Server1. On Server2, you create a new remote RADIUS server group named Group1 that contains Server1.
What should you configure next on Server2?
To answer, select the appropriate node in the answer area.
Connection request policies are sets of conditions and settings that allow network administrators to designate which Remote Authentication Dial-In User Service (RADIUS) servers perform the authentication and authorization of connection requests that the server running Network Policy Server (NPS) receives from RADIUS clients. Connection request policies can be configured to designate which RADIUS servers are used for RADIUS accounting. http://technet.microsoft.com/en-us/library/cc753603.aspx
Your network is configured as shown in the exhibit. (Click the Exhibit button.)
Server1 regularly accesses Server2.
You discover that all of the connections from Server1 to Server2 are routed through Router1.
You need to optimize the connection path from Server1 to Server2.
Which route command should you run on Server1?
A. Route add -p 10.10.10.0 MASK 255.255.255.0 10.10.10.1 METRIC 50
B. Route add -p 10.10.10.0 MASK 255.255.255.0 172.23.16.2 METRIC 100
C. Route add -p 10.10.10.12 MASK 255.255.255.0 10.10.10.1 METRIC 100
D. Route add -p 10.10.10.12 MASK 255.255.255.0 10.10.10.0 METRIC 50
destination – specifies either an IP address or host name for the network or host.
subnetmask – specifies a subnet mask to be associated with this route entry. If subnetmask is not specified, 255.255.255.255 is used.
gateway – specifies either an IP address or host name for the gateway or router to use when forwarding.
costmetric – assigns an integer cost metric (ranging from 1 through 9,999) to be used in calculating the fastest, most reliable, and/or least expensive routes. If costmetric is not specified, 1 is used.
interface – specifies the interface to be used for the route that uses the interface number. If an interface is not specified, the interface to be used for the route is determined from the gateway IP address.
Drag and Drop Question
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create?
A. an Extended Event session
B. a Policy
C. a Database Audit Specification
D. an Alert
E. a Server Audit Specification
F. a SQL Profiler Trace
G. a Resource Pool
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?
A. CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
B. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
C. ALTER INDEX ALL ON OrderDetail REBUILD
D. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD
Your company has a private cloud that contains a System Center 2012 Orchestrator infrastructure. You are creating a runbook named runbook1.
You need to ensure that the workflow starts when a file is added to a folder. From which category should you add an activity? To answer, select the appropriate category in the answer area.
A runbook can only have one starting point. A starting point is an activity that automatically runs when the runbook is started. Each activity in the runbook runs after the previous activity in the workflow is complete.
If a runbook starts with any activity other than a monitor, the runbook begins processing and attempts to run to completion. If the runbook starts with a monitor activity, the monitor loads and
waits for the trigger condition. Once the condition is met, a runbook instance is created to run the remaining activities in the runbook. The monitor continues to run and wait another occurrence of the trigger condition. Runbooks that start with monitors continue to run until you stop them from the Runbook Designer or Orchestration console.
Your company has a private cloud that is managed by using a System Center 2012 infrastructure. You plan to deploy a single-tier service to the private cloud. The service is configured to use Network Load Balancing (NLB). You need to create a Hardware Profile for the virtual machines that will be added to the service template. The solution must ensure that the virtual machines will use Windows Network Load Balancing. Which settings should you configure in the Hardware Profile? To answer, configure the four appropriate settings in the dialog box in the answer area.