You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in a s
You maintain a SQL Server 2008 Integration Services (SSIS) instance.
The instance stores packages in a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores
its packages in a shared directory.
What should you do?
Use the drop-down menus top select the answer choice that completes each statement.
You run Get-FSRMClassificationule and you receive the following output
ClassificationMechanism : Content Classfier
ContentRegularExpression : {\d{2,}}
ContentString :
ContentStringCaseSensitive :
Description :
Disabled : False
Flags :
Lastmodified : 4/18/2015 12:59:47 AM
Name : Rule2
Namespace : {D:\}
Parameters : {FSRMClearPropertyInternal = 0}
Property : Property2
PropertyValue : Value2
ReevaluateProperty : Overwrite
PSComputerName :
ClassficationMechanism : FolderClassifier
ContentRegularExpression :
ContentString :
ContentStringCaseSensitive :
Description :
Disabled : False
Flags :
Lastmodified : 4/15/2015 9:17:16 PM
Name : Rule1
Namespace : {D:\}
Parameters : {FSRMClearPropertyInternal = 0}
Property : Property1
PropertyValue : Value1
ReevaluateProperty : Aggregate
PSComputerName :
You have a file named file1 that is stored on drive D and has the following content
"111000000000111111"
You run the classification with all of the rules
Use the drop-down menus top select the answer choice that completes each statement.
File1 has [answer choice]
Only Property1 set to value1
Only Property2 set to value2
Property1 set to value1 and property2 set to value2
Neither Property1 nor Property2 set
If you modify File1 [answer choice]
Only the value of Property1 is
Only the value of Property2 is
the value of Property1 and Property2 are
Neither the value of Property1 nor the value of Property2 is
Which protection level should you use?
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who
deployed the package can execute it.
Which protection level should you use?
You need to create a clone of DC5 on Host2 What should you run on each Hyper-V Host.? To answer Drag the appro
You network contains one Active Directory domain. The domain contains two Hyper-V Hosts
named Host1 and Host2 that run Windows Server 2012 R2. Host1 contains a virtual machine
named DC5. DC5 is a domain controller that run Windows Server 2012 R2.
You configure Active Directory to support domain controller cloning for DC5, and then you shut
down DC5.
You need to create a clone of DC5 on Host2
What should you run on each Hyper-V Host.? To answer Drag the appropriate commands or
cmdlets to the correct Hyper-V hosts. Each command or cmdlet 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.
Command and cmdlets
Export-VM
Import-VM
Move-VM
New-ADDCCloneConfigFile
Answer Area
Host1: Command or cmdlet
Host2: Command or cmdlet
Which backup option should you use?
You administer a SQL Server 2008 instance that hosts a large database. The database has
the following backup strategy: Full database backups are performed weekly. Differential
backups are performed daily. Transaction log backups are performed hourly. The recovery
plan requires you to perform an unscheduled full backup. You need to perform a full
database backup without interrupting the scheduled backup strategy. Which backup option
should you use?
Which protection level should you use?
You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
You deploy the package to the file system in the production environment. The users report
that the connection strings contained in the package are blank. The package fails to execute.
You need to change the protection level of the package to ensure that users can view and
execute the package.
Which protection level should you use?
What should you configure on the new server?
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The domain
contains a server named Server that runs Windows Server 2012 R2.
You perform a Server Core Installation of Windows Server 2012 R2 on a new server.
You need to ensure that you can add the new server to Server Manager on Server1.
What should you configure on the new server? To answer, select the appropriate setting in
the answer area.
You need to create a measure named AccountBalance from the CurrentBalance column to display the closing accoun
You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension
named Account and a time dimension named Time. You have a fact table that contains a
column named CurrentBalance. CurrentBalance contains the current account balance.
You need to create a measure named AccountBalance from the CurrentBalance column to
display the closing account balance for a time period.
What should you do?
What should you configure for the DHCP service and the WDS service?
HOTSPOT
You have a server named Server1.Server1 runs Windows Server 2012 R2 and has the
Windows Deployment Services (WDS) server role installed.
You install the DHCP Server server role on Server1.
You need to ensure that Server1 can respond to DHCP clients and WDS clients.
What should you configure for the DHCP service and the WDS service?
To answer, configure the appropriate options in the answer area.
What should you identify?
HOTSPOT
You have a file server named Server1 that runs Windows Server 2012 R2.Server1 contains
a folder named Folder1.
A user named User1 is a member of Group1 and Group2.A user named User2 is a member
of Group2 and Group3.
You need to identify which actions the users can perform when they access the files in
Share1.
What should you identify?
To answer, select the appropriate actions for each user in the answer area.
