Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Microsoft 70-463

Microsoft 70-463 Exam Practice Questions (P. 4)

  • Full Access (218 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
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?
  1. A
    Open a command prompt and run the gacutil command.
  2. B
    Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  3. C
    Add an OnError event handler to the SSIS project.
  4. D
    Use an msi file to deploy the package on the server.
  5. E
    Configure the output of a component in the package dataflow to use a data tap.
  6. F
    Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
  7. G
    Open a command prompt and run the dtexec /rep /conn command.
  8. H
    Open a command prompt and run the dtutil /copy command.
  9. I
    Open a command prompt and run the dtexec /dumperror /conn command.
  10. 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.

Correct Answer:
J
References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://www.element61.be/en/resource/sql-server-integration-services-2012-%E2%80%93-project-deployment-model

Question #17
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?
  1. A
    Open a command prompt and run the dtexec /dumperror /conn command.
  2. B
    Create a reusable custom logging component and use it inthe SSIS project.
  3. C
    Open a command prompt and run the gacutil command.
  4. D
    Add an OnError event handler to the SSIS project.
  5. E
    Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  6. F
    Open a command prompt and run the dtexec /rep /conn command.
  7. G
    Open a command prompt and run the dtutil /copy command.
  8. H
    Use an msi file to deploy the package on the server.
  9. I
    Configure the SSIS solution to use the Project Deployment Model.
  10. 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.

Correct Answer:
I
References:
http://msdn.microsoft.com/en-us/library/hh231102.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx

Question #18
Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series.
Information and details provided in a question apply only to that question.
You are developing a SQL Server Integration Services (SSIS) package.
To process complex scientific data originating from a Microsoft Azure SQL Database database, a custom task component is added to the project.
You need to ensure that the custom component is deployed on a test environment correctly.
What should you do?
  1. A
    Add an OnError event handler to the SSIS project.
  2. B
    Use an msi file to deploy the package on the server.
  3. C
    Open a command prompt and run the gacutil command.
  4. D
    Open a command prompt and run the dtutil /copy command.
  5. E
    Open a command prompt and run the dtexec /rep /conn command.
  6. F
    Open a command prompt and run the dtexec /dumperror /conn command.
  7. G
    Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  8. H
    Create a reusable custom logging component and use it in the SSIS project.
  9. I
    Configure the SSIS solution to use the Project Deployment Model.
  10. J
    Configure the output of a component in the package data flow to use a data tap. K. Run thedtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

Correct Answer:
C
References:
http://msdn.microsoft.com/en-us/library/ms403356.aspx

Question #19
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.)
Select and Place:


Correct Answer:

 We need to add references to the Development and QA environments to the project. Then we can map the variables in the project to the environment variables defined in the environments.
When you execute a package in a project that references multiple environments (Test and Production in this case), we can select which environment the package runs under.

Question #20
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.)
  1. A
    dtexec
  2. B
    catalog.start_package
  3. C
    SQL Server Agent
  4. D
    SQL Server Management Studio

Correct Answer:
AC
References: http://technet.microsoft.com/en-us/library/ms141708(v=sql.110).aspx

Previous Questions Next Questions

All Pages