Microsoft 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam
Page: 3 / 48
Total 237 questions
Question #11 (Topic: Topic 1)
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client
application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in
the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?
application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in
the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?
A. Map a composite domain to the source column.
B. Create a composite domain that includes the Group column.
C. Add a domain for the Group column.
D. Add a column mapping for the Group column.
Answer: C
Question #12 (Topic: Topic 1)
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.)
[Microsoft-70-463-13.0/Microsoft-70-463-12_2.png]
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.)
[Microsoft-70-463-13.0/Microsoft-70-463-12_2.png]
Answer: [Microsoft-70-463-13.0/Microsoft-70-463-12_3.png]
Question #13 (Topic: Topic 1)
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a
logging methodology is put in place.
The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing
the amount of deployment and development effort.
What should you do?
logging methodology is put in place.
The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing
the amount of deployment and development effort.
What should you do?
A. Open a command prompt and run the gacutil command.
B. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
C. Add an OnError event handler to the SSIS project.
D. Use an msi file to deploy the package on the server.
E. Configure the output of a component in the package data flow to use a data tap.
F. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
G. Open a command prompt and run the dtexec /rep /conn command.
H. Open a command prompt and run the dtutil /copy command.
I. Open a command prompt and run the dtexec /dumperror /conn command.
J. Configure the SSIS solution to use the Project Deployment Model. K. Create a reusable custom logging component and use it in the SSIS project.
Answer: B
Question #14 (Topic: Topic 1)
You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by
using the least amount of development effort.
What should you use?
You need to design a package to change a variable value during package execution by
using the least amount of development effort.
What should you use?
A. Expression task
B. Script task
C. Execute SQL task
D. Execute Process task
E. Term Extraction transformation
Answer: A
Question #15 (Topic: Topic 1)
A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time
errors.
You need to edit the package to log specific error messages.
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.)
errors.
You need to edit the package to log specific error messages.
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: [Microsoft-70-463-13.0/Microsoft-70-463-15_2.png]
