IT인증시험덤프자료를 제공해드리는 사이트는 너무나도 많습니다. 그중에서 대부분 분들이 Pass4Test제품에 많은 관심과 사랑을 주고 계시는데 그 원인은 무엇일가요?바로Pass4Test에서 제공해드리는 덤프자료 품질이 제일 좋고 업데이트가 제일 빠르고 가격이 제일 저렴하고 구매후 서비스가 제일 훌륭하다는 점에 있습니다. Pass4Test 표
MCTS 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) 덤프를 공부하시면 시험보는데 자신감이 생기고 MCTS 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) 시험불합격에 대한 우려도 줄어들것입니다.
NO.1 You develop and deploy a SQL Server Integration Services (SSIS)
package.
The package is stored in the file system.
You need to execute the
package without importing it to the SSIS server.
What should you use to
execute the package? (Each correct answer presents a complete
solution.Choose
all that apply.)
A.catalog.start_package
B.dtexec
C.SQL Server
Management Studio
D.SQL Server Agent
Answer: CA
NO.2 DRAG DROP
A
SQL Server Integration Services (SSIS) project has been deployed to the SSIS
catalog.The project
includes a project Connection Manager to connect to the
data warehouse.The SSIS catalog includes
two
Environments:
Development
QA
Each Environment defines a single
Environment Variable named ConnectionString of type string.The
value of each
variable consists of the connection string to the development or QA data
warehouses.
You need to be able to execute deployed packages by using either
of the defined Environments.
Which three 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.)
Answer:
NO.3 DRAG DROP
A new SQL Server Integration
Services (SSIS) project is deployed to the SSIS catalog.
To troubleshoot some
data issues, you must output the data streaming through several data flows into
text
files for further analysis.You have the list of data flow package paths
and identification strings of the
various task components that must be
analyzed.
You need to create these output files with the least amount of
administrative and development effort.
Which three stored procedures should
you execute in sequence? (To answer, move the appropriate
actions from the
list of actions to the answer area and arrange them in the correct
order.)
Answer:
NO.4 You are developing a SQL Server Integration
Services (SSIS) project that copies a large amount of
rows from a SQL Azure
database.The project uses the Package Deployment Model.This project
is
deployed to SQL Server on a test server.
You need to ensure that the
project is deployed to the SSIS catalog on the production server.
What should
you do?
A.Open a command prompt and run the dtexec /dumperror /conn
command.
B.Create a reusable custom logging component and use it in the SSIS
project.
C.Open a command prompt and run the gacutil command.
D.Add an
OnError event handler to the SSIS project.
E.Open a command prompt and
execute the package by using the SQL Log provider and running
the
dtexecui.exe utility.
F.Open a command prompt and run the dtexec /rep
/conn command.
G.Open a command prompt and run the dtutil /copy
command.
H.Use an msi file to deploy the package on the
server.
I.Configure the SSIS solution to use the Project Deployment
Model.
J.Configure the output of a component in the package data flow to use
a data tap.
K.Run the dtutil command to deploy the package to the SSIS
catalog and store the configuration in SQL
Server.
Answer: I
NO.5 A
SQL Server Integration Services (SSIS) package on a computer is failing
periodically in
production.The package was created less than one year ago and
was deployed to the SSIS catalog.
Sometimes the package is started on a SQL
Agent schedule; sometimes the package is started manually
by an SSIS
developer by using the Object Explorer in SQL Server Management Studio.
You
need to identify the authenticated user responsible for starting the package
each time it failed in the
past.
Where can you find this
information?
A.the SQL Server Log
B.the SSISDB.[catalog].[executions]
view
C.the SSISDB.[catalog].[event_messages] view
D.the SQL Agent Job
History
E.the SQL Agent Error Log
Answer: B
NO.6 You are developing
a project that contains multiple SQL Server Integration Services
(SSIS)
packages.The packages will be deployed to the SSIS catalog.One of the
steps in each package accesses
an FTP site to download sales transaction
data.
You create project parameters to store the username and password that
are used to access the FTP site.
You need to ensure that the username and
password values are encrypted when they are deployed.
What should you
do?
A.set the Sensitive property of the parameters to True.
B.Set the
ProtectionLevel property of the package to
EncryptSensitiveWithUserKey.
C.Change the parameters to package
parameters.
D.Change the project to the Legacy Deployment model.
Answer:
A
NO.7 You develop a SQL Server Integration Services (SSIS) package that
imports SQL Azure data into a data
warehouse every night.
The SQL Azure
data contains many misspellings and variations of abbreviations.To import the
data, a
developer used the Fuzzy Lookup transformation to choose the
closest-matching string from a reference
table of allowed values.The number
of rows in the reference table is very large.
If no acceptable match is
found, the Fuzzy Lookup transformation passes a null value.
The current
setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are
incorrectly matched.
You need to ensure that more accurate matches are made
by the Fuzzy Lookup transformation without
degrading performance.
What
should you do?
A.Change the Exhaustive property to True,
B.Change the
similarity threshold to 0.55.
C.Change the similarity threshold to
0.40.
D.Increase the maximum number of matches per lookup.
Answer:
B
NO.8 You install a SQL Server 2012 database engine instance on a
production server.A month later, you
install SQL Server 2012 Integration
Services (SSIS).
You must develop an SSIS project and deploy it to the server
by using the Project Deployment model.
Operations Log records that are
outside the configured retention period must be cleaned automatically.
You
need to create the SSIS catalog on the production server.
What should you do?
(Each correct answer presents part of the solution.Choose all that
apply.)
A.Enable XP Command Shell.
B.Enable CLR Integration.
C.Enable
OLE Automation.
D.Start the SQL Server Browser service.
E.Enable Cross
Database Ownership Chaining.
F.Start the SQL Server Agent
service.
G.Enable Ad Hoc Remote Queries.
Answer: FA
package.
The package is stored in the file system.
You need to execute the
package without importing it to the SSIS server.
What should you use to
execute the package? (Each correct answer presents a complete
solution.Choose
all that apply.)
A.catalog.start_package
B.dtexec
C.SQL Server
Management Studio
D.SQL Server Agent
Answer: CA
NO.2 DRAG DROP
A
SQL Server Integration Services (SSIS) project has been deployed to the SSIS
catalog.The project
includes a project Connection Manager to connect to the
data warehouse.The SSIS catalog includes
two
Environments:
Development
QA
Each Environment defines a single
Environment Variable named ConnectionString of type string.The
value of each
variable consists of the connection string to the development or QA data
warehouses.
You need to be able to execute deployed packages by using either
of the defined Environments.
Which three 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.)
Answer:
NO.3 DRAG DROP
A new SQL Server Integration
Services (SSIS) project is deployed to the SSIS catalog.
To troubleshoot some
data issues, you must output the data streaming through several data flows into
text
files for further analysis.You have the list of data flow package paths
and identification strings of the
various task components that must be
analyzed.
You need to create these output files with the least amount of
administrative and development effort.
Which three stored procedures should
you execute in sequence? (To answer, move the appropriate
actions from the
list of actions to the answer area and arrange them in the correct
order.)
Answer:
NO.4 You are developing a SQL Server Integration
Services (SSIS) project that copies a large amount of
rows from a SQL Azure
database.The project uses the Package Deployment Model.This project
is
deployed to SQL Server on a test server.
You need to ensure that the
project is deployed to the SSIS catalog on the production server.
What should
you do?
A.Open a command prompt and run the dtexec /dumperror /conn
command.
B.Create a reusable custom logging component and use it in the SSIS
project.
C.Open a command prompt and run the gacutil command.
D.Add an
OnError event handler to the SSIS project.
E.Open a command prompt and
execute the package by using the SQL Log provider and running
the
dtexecui.exe utility.
F.Open a command prompt and run the dtexec /rep
/conn command.
G.Open a command prompt and run the dtutil /copy
command.
H.Use an msi file to deploy the package on the
server.
I.Configure the SSIS solution to use the Project Deployment
Model.
J.Configure the output of a component in the package data flow to use
a data tap.
K.Run the dtutil command to deploy the package to the SSIS
catalog and store the configuration in SQL
Server.
Answer: I
NO.5 A
SQL Server Integration Services (SSIS) package on a computer is failing
periodically in
production.The package was created less than one year ago and
was deployed to the SSIS catalog.
Sometimes the package is started on a SQL
Agent schedule; sometimes the package is started manually
by an SSIS
developer by using the Object Explorer in SQL Server Management Studio.
You
need to identify the authenticated user responsible for starting the package
each time it failed in the
past.
Where can you find this
information?
A.the SQL Server Log
B.the SSISDB.[catalog].[executions]
view
C.the SSISDB.[catalog].[event_messages] view
D.the SQL Agent Job
History
E.the SQL Agent Error Log
Answer: B
NO.6 You are developing
a project that contains multiple SQL Server Integration Services
(SSIS)
packages.The packages will be deployed to the SSIS catalog.One of the
steps in each package accesses
an FTP site to download sales transaction
data.
You create project parameters to store the username and password that
are used to access the FTP site.
You need to ensure that the username and
password values are encrypted when they are deployed.
What should you
do?
A.set the Sensitive property of the parameters to True.
B.Set the
ProtectionLevel property of the package to
EncryptSensitiveWithUserKey.
C.Change the parameters to package
parameters.
D.Change the project to the Legacy Deployment model.
Answer:
A
NO.7 You develop a SQL Server Integration Services (SSIS) package that
imports SQL Azure data into a data
warehouse every night.
The SQL Azure
data contains many misspellings and variations of abbreviations.To import the
data, a
developer used the Fuzzy Lookup transformation to choose the
closest-matching string from a reference
table of allowed values.The number
of rows in the reference table is very large.
If no acceptable match is
found, the Fuzzy Lookup transformation passes a null value.
The current
setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are
incorrectly matched.
You need to ensure that more accurate matches are made
by the Fuzzy Lookup transformation without
degrading performance.
What
should you do?
A.Change the Exhaustive property to True,
B.Change the
similarity threshold to 0.55.
C.Change the similarity threshold to
0.40.
D.Increase the maximum number of matches per lookup.
Answer:
B
NO.8 You install a SQL Server 2012 database engine instance on a
production server.A month later, you
install SQL Server 2012 Integration
Services (SSIS).
You must develop an SSIS project and deploy it to the server
by using the Project Deployment model.
Operations Log records that are
outside the configured retention period must be cleaned automatically.
You
need to create the SSIS catalog on the production server.
What should you do?
(Each correct answer presents part of the solution.Choose all that
apply.)
A.Enable XP Command Shell.
B.Enable CLR Integration.
C.Enable
OLE Automation.
D.Start the SQL Server Browser service.
E.Enable Cross
Database Ownership Chaining.
F.Start the SQL Server Agent
service.
G.Enable Ad Hoc Remote Queries.
Answer: FA