Identify three components of an Oracle instance
for which you can change the size dynamically. (Choose three.)
A. Java Pool
B. Large Pool
C. Shared Pool
E. Database Buffer Cache
You have an application that uses a view to
access data from multiple tables. You need to ensure that you can insert rows
into the underlying tables by using the view. What should you do?
A. Materialize the view.
B. Create an INSTEAD OF
trigger on the view.
C. Define the view by using the CHECK
D. Define the view by using the SCHEMABINDING option.
You administer a Microsoft
SQL Server 2012 database. The database contains a table that has the following
You want to export data from the table to a flat file
by using the SQL Server Import and Export Wizard. You need to ensure that the
following requirements are met:
* The first row of the file contains the
first row of data.
* Each record is of the same length.
* The date follows
the U.S. date format.
* The file supports international characters.
should you do? (To answer, configure the appropriate option or options in the
dialog box in the answer area.)
You develop a Microsoft SQL Server 2012
database. You create a view from the Orders and OrderDetails tables by using the
You need to ensure that users are able to modify data
by using the view. What should you do?
A. Create an AFTER trigger on the view.
B. Modify the
view to use the WITH VIEW_METADATA clause.
C. Create an INSTEAD OF trigger
on the view.
D. Modify the view to an indexed view.
You are a database developer. You develop a
database application for a SQL Server 2008 instance.
The instance hosts a third-party database. You are not
allowed to modify the database schema. The database contains two tables that are
as shown in the following diagram. You plan to extract address information about
full-time employees based on the FullTimeIndicator flag. You need to design a
data access layer to simplify the extraction process. What should you do?
A. Design an Entity Data Model that contains the EMPLOYEES
and ADDRESS entities.
B. Create a view on the database to include
full-time employees and their address details.
C. Re-design the underlying
database model to include employee and address information in one
D. Design a conceptual Entity Data Model that contains an entity
named EMPLOYEE_ADDRESS. Ensure that this entity contains information about
employees and their addresses.
Which of the following is the MOST important
physical consideration when deploying a new server?
A. Humidity monitors, Biometrics, and fire
B. Cooling, rack space, and power requirements
C. Service level agreements, uninterruptible power supply (UPS) deployment, and
D. Biometrics, fire suppression, and power requirements
Company LEAD2PASS has recently completed the
connection of its network to a national high speed private research network.
Local businesses in the area are seeking sponsorship from Company LEAD2PASS to
connect to the high speed research network by directly connecting through
Company LEAD2PASS’s network. Company LEAD2PASS’s Chief Information Officer (CIO)
believes that this is an opportunity to increase revenues and visibility for the
company, as well as promote research and development in the area. Which of the
following must Company LEAD2PASS require of its sponsored partners in order to
document the technical security requirements of the connection?
You administer a SQL Server 2008 instance that
hosts a large database. The following backup strategy is used for the database:
A full database backup is performed at 02:00 hr every Monday. A differential
backup is performed at 23:00 hr every day. A transaction log backup is performed
on an hourly basis. A power failure on Thursday causes the SQL Server 2008
server to restart at 09:15 hr. Fifteen minutes after the server restarts, the
users report that they are unable to execute certain queries that access
customer data. You discover that the customer data is unmodified after the power
failure. When you execute the DBCC CHECKDB command on the database, you receive
the following error message:
Object ID 2814307832, index ID 2, partition ID
83127819437122157, alloc unit ID 82134587923221126 (type In-row data): Page
(3421:169) could not be processed. See other errors for d etails. Table error:
Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data), page (3421:169). Test (IS_OFF (BUF_IOERR,
pBUF- > bstat)) failed. Values are 16928422 and -8. CHECKDB found 0 allocatio
n errors and 2 consistency errors in table ‘tbl_Customer’ (object ID
When you execute the sp_help ‘tbl_customer’ stored procedure you
receive the following result set:
index_name index_description PK clustered
located on PRIMARY NCIX nonclustered located on PRIMARY
You need to ensure
that the data is available as quickly as possible with minimal effect on users.
What should you do?
A. Drop and recreate the PK index.
B. Drop and
recreate the NCIX index.
C. Restore the latest full database backup.
Restore all transaction log backups from the latest full database
D. Restore the latest full database backup. Restore the latest
differential backup. Restore all transaction log backups from the latest
You create a SQL Server 2008 Analysis Services
(SSAS) solution. You create a dimension named DimCustomer that contains the
following three attributes:
attribute is the key. The DimCustomer dimension is related to a measure group
named Sales that has the Granularity property set to City. You need to ensure
that you can retrieve measure values based on the City and Country attributes.
What should you do?
A. Set the source attribute to Customer and the related
attribute to City.Set the source attribute to City and the related attribute to
B. Set the source attribute to City and the related attribute to
Customer.Set the source attribute to Country and the related attribute to
C. Set the source attribute to Customer and the related attribute to
City.Set the source attribute to Customer and the related attribute to
D. Set the source attribute to City and the related attribute to
Customer.Set the source attribute to Country and the related attribute to
You have a table named Inventory. You open a
Microsoft Windows PowerShell session at the following location by using the SQL
Server Windows PowerShell provider. PS
Using the SQL Server Windows PowerShell provider, you need to query all the
columns in the table. Which cmdlet should you use?
You are the administrator of a SQL Server 2008
instance. All the instances run on their independent server. The three instances
are respectively named InstanceA, InstanceB, and InstanceC. Between InstanceA
and InstanceB, you configure a mirroring mission-critcal database. InstanceA
currently acts as the Principal and InstanceC acts as the witness. You intend to
apply a patch to both servers as soon as possible, the patch needs to restart
the server. You must make sure that the database is online on the partner that
currently does not apply the patch and during this time the database does not
failover to the other partner. Which action should you perform to achieve this
A. First, you should stop the mirroring session. Second you
apply the patch to the server that runs InstanceB. Third, you should resume the
mirroring session. Fourth, you should manually failover the mirroring session.
At last, you should apply the patch to the server that runs Instance1.
B. First, you should apply the patch to the server that runs InstanceB. Second you
apply the patch to the server that runs InstanceA.
C. First, you should
apply the patch to the server that runs InstanceB. Second you failover the
mirroring session manually. At last apply the patch to the server that runs
D. First, you should remove the mirroring session. Second you
apply the patch to the server that runs InstanceB. Third, you should apply the
patch to the server that runs Instance1. At last re-establish the mirroring
You have an Active Directory
domain named contoso.com. Your company has a Microsoft Office 365 subscription.
Twenty users are enabled for Microsoft Lync Online. The users frequently travel.
The users report that they receive the following error message when they attempt
to sign in to Microsoft Lync from the office: “Cannot sign in because the server
is temporarily unavailable. If the problem continues, please contact your
support team.” You verify that the users can sign in to Lync when they connect
from the Internet. You need to ensure that all of the users can sign in to Lync.
Which alias (CNAME) record should you create in the internal DNS domain? To
answer, select the appropriate record name and the appropriate record target in
the answer area.
You have a Lync Server 2013 infrastructure that
contains an Enterprise Edition front end pool. You plan to add the following
server roles to the existing infrastructure:
* Edge Server
* Monitoring Server
* Persistent Chat Server
You need to
identify the minimum number of Microsoft SQL Server servers that must be added
to the existing Lync Server 2013 infrastructure. The solution must not use the
existing SQL Server Back End Server. What is the minimum number of SQL Server
servers that you should identify?
You are configuring SharePoint 2013 to support
business intelligence. You need to install PowerPivot for SharePoint. What
should you do?
A. Download and install PowerPivot for SharePoint from the
PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.
B. Run the SQL
Server 2008 setup package.
C. Download and install PowerPivot for
SharePoint from the PowerPivot SQL Server 2012 Feature Pack webpage.
D. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server
2012 SP1 Feature Pack webpage.
Your company has a Microsoft Exchange Server 2003
organization. Users access their mailbox by using RPC over HTTP and Exchange
ActiveSync. You purchase an Office 365 subscription. From the Office 365 portal,
you create and verify the accepted domain of the company. From the Exchange
Control Panel, you attempt to migrate all of the mailboxes to Microsoft Exchange
Online and you receive an error message indicating that the remote server is
unavailable. You need to identify what prevents the mailboxes from migrating.
Which tool should you use?
A. the Microsoft Remote Connectivity Analyzer
Exchange Server Deployment Assistant
C. the Office 365 Deployment
D. the Microsoft Online Services Directory Synchronization
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
C. System Center 2012 Operations Manager
Center 2012 App Controller
Your company has a private cloud that contains
two Active Directory forests named contoso.com and adatum.com. The contoso.com
network and the adatum.com network are separated by a firewall.
exist between the forests.
You deploy System Center 2012 Operations Manager
You install agents on 100 servers in both forests.
to ensure that you can monitor all 100 servers. The solution must minimize the
traffic between the two networks.
What should you install? (Each correct
answer presents part of the solution. Choose all that apply.)
A. A server certificate on the gateway server in
B. A gateway server in adatum.com
C. A server
certificate on the gateway server in adatum.com
D. Client certificates on
all of the servers in adatum.com
E. A gateway server in
F. A server certificate on the management server in
G. Client certificates on all of the servers in contoso.com
Scenario: A company has recently purchased 100
XenApp licenses to deploy a new XenApp farm that will provide the Microsoft
Office Suite for remote users. The administrator configures Health Monitoring
and Recovery options to ensure that alerts are submitted when the IMA Service is
NOT working as expected. The test queries the service to ensure that the IMA
Service is working by ___________. (Choose the correct option to complete the
A. enumerating the applications available on the server
B. executing all of the applications available on the server
C. launching at least one of the applications available on the server
D. enumerating the current active sessions available on the server
All users in the Sales group must be able to
save documents created on their virtual desktops to USB devices connected to
their local desktops. Some users in the Sales group also belong to the Remote
Users group; however, the Remote Users group must not be able to save documents
to a local USB device. An administrator created the Sales USB policy, which
allows Client USB device redirection for the Sales group, and the Remote Users
USB policy, which prohibits Client USB device redirection for the Remote Users
group. Which additional step must the administrator take to meet the needs of
A. Set the Remote Users USB policy to ‘Disable’.
B. Edit the USB device list on the endpoint device.
C. Ensure that the Sales
USB policy has highest priority.
D. Add Client USB device redirection
rules to the Sales USB policy.
Your network environment has System Center Configuration Manager (SCCM) 2007. The SCCM hierarchy is shown in the following table.
The MOW site has Forefront Endpoint Protection (FEP) 2010 installed. You plan to install FEP 2010 on the LON site. You need to ensure that existing custom FEP policies will apply in the MOW site after the FEP installation on the LON site is complete. What should you do?
A. Rename the FEP – Policies package.
B. Set the highest precedence to the custom policies on the MOW site.
C. Distribute the FEP – Policies package from the MOW site before the FEP installation on the LON site is complete.
D. Export FEP policies from the MOW site before the FEP installation on the LON site is complete. Import the policies into the LON site.