Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 81:

  You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012.

  Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects:

  

  View and validate projects and packages

  

  View Environments and Environment variables

  

  Execute packages

  You need to grant the minimum possible privileges to the QA testers.

  What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  A. In the SSISDB database, add QA Tester logons to the ssis_admin role.
  B. In the msdb database, add QA Tester logons to the db_ssisoperator role.
  C. Grant Modify permission in the projects to the QA Tester logons.
  D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons.
  E. Grant Execute permission in the projects to the QA Tester logons.
  F. In the msdb database, add QA Tester logons to the db_ssisItduser role.
  D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons.
  E. Grant Execute permission in the projects to the QA Tester logons.

  ---

  Incorrect Answers:

  B: "perform the following tasks on specific projects:" All the required tasks are performed within specific projects. In other words, not individual packages stored in the MSDB database.

  References: https://www.mssqltips.com/sqlservertip/3153/managing-ssis-security-with-database-roles/ https://anothersqlgeek.wordpress.com/2013/07/20/sql-2012-ssis-catalog-permissions/

• Question 82:

  You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by using the EncryptSensitiveWithUserKey package protection level.

  You are preparing the package for deployment by the production operations team.

  You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information.

  Which three steps 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:

  

  

• Question 83:

  You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com.

  You have recently installed Microsoft SQL Server 2012, with SQL Server Integration Services (SSIS), in ABC.com's environment. You are preparing to install the SSISDB catalog on the SSIS server.

  Which of the following is TRUE with regards to the SSISDB catalog? (Choose all that apply.)

  A. You can make use of SQL Server Management Studio to create the SSISDB catalog.
  B. You can make use of SQL Server Data Tools to create the SSISDB catalog.
  C. You can make use of Solution Explorer to create the SSISDB catalog.
  D. You can make use of Windows PowerShell to create the SSISDB catalog programmatically.
  A. You can make use of SQL Server Management Studio to create the SSISDB catalog.
  D. You can make use of Windows PowerShell to create the SSISDB catalog programmatically.

• Question 84:

  You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing a utility that can be run from the command prompt to manage SQL Server Integration Services packages.

  Which of the following is the utility you are discussing?

  A. dbimpexp.exe
  B. dtutil.exe
  C. gacutil.exe
  D. dtexecui.exe
  B. dtutil.exe

• Question 85:

  You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B.

  Both packages must reference a file path corresponding to an input folder where files will be located for further processing.

  You need to design a solution so that the file path can be easily configured with the least administrative and development effort.

  Which four 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:

  

  

• Question 86:

  You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:

  

  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.

  What should you do? (To answer, simply select the option or options in the answer area that you would configure.)

  Hot Area:

  

  

• Question 87:

  You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.

  You need to use DQS profiling to obtain the required statistics.

  Which DQS activity should you use?

  A. Cleansing
  B. Matching
  C. Knowledge Discovery
  D. Matching Policy
  A. Cleansing

  ---

  References: http://msdn.microsoft.com/en-gb/library/hh213055(v=sql.110).aspx

• Question 88:

  You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.

  A stored procedure will be called in an Execute SQL task by using an ODBC connection.

  This stored procedure has only the @CustomerID parameter of type INT.

  A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.

  You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.

  In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)

  Select and Place:

  

  

• Question 89:

  You are the Master Data Services (MDS) administrator at your company.

  An existing user must be denied access to a certain hierarchy node for an existing model.

  You need to configure the user's permissions.

  Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

  Hot Area:

  

  

• Question 90:

  You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)

  

  Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?

  A. DateHired
  B. DepartmentID
  C. EmployeeID
  D. EmployeeNum
  E. FirstName
  F. JobTitle
  G. LastName
  H. MiddleName I. ReportsToID
  C. EmployeeID