Microsoft 70-458 Online Practice Questions and Exam Preparation

Microsoft 70-458 Online Questions & Answers

• Question 31:

  You are developing a SQL Server Integration Services (SSIS) package. The package contains several tasks that must repeat until an expression evaluates to FALSE. You need to add and configure a container to enable this design. 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:

  

  

• Question 32:

  You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database.

  The SSIS package has the following requirements:

  

  Every night, a very large amount of data is imported into the staging database.

  

  Package processing time must be minimized.

  

  The package must run on its own dedicated server when it is deployed to production.

  

  Transaction log activity when data is imported must be minimized.

  You need to design the package to meet the requirements.

  A. Raw File
  B. OLE DB
  C. ODBC
  D. Bulk Insert
  B. OLE DB

• Question 33:

  Users need to be able to SELECT from all tables in the database and execute the stored procedure. You need to grant only the necessary permissions. What should you do?

  A. Add EXECUTE AS OWNER to the stored procedure. Add all users to the db_datareader role.
  B. Add all users to the db_datawriter role. Add all users to the db_datareader role.
  C. Create a new database role. Grant EXECUTE permission on p_AddInventory to the newrole. Add all users to the role. Add all users to the db_datareader role.
  D. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to to the role. Add all users to the role.
  A. Add EXECUTE AS OWNER to the stored procedure. Add all users to the db_datareader role.

• Question 34:

  You administer three Microsoft SQL Server 2012 servers named ServerA, Servers, and ServerC.

  ServerA is the acting principal and ServerB is the mirror.

  You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB. You need to achieve this goal without delaying synchronization. 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:

  

  

• Question 35:

  You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database. You need to grant a junior database administrator only the permissions required to create new logins.

  A. securityadmin
  B. loginmanager
  C. serveradmin
  D. setupadmin
  B. loginmanager

• Question 36:

  You are a database administrator for a Microsoft SQL Server 2012 environment.

  You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.

  Which feature should you use?

  A. Database Mirroring
  B. Peer-to-Peer Replication
  C. Log Shipping
  D. Availability Groups
  B. Peer-to-Peer Replication

• Question 37:

  You are developing a SQL Server Integration Services (SSIS) package.

  The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certaingroups of tasks will share variable and transaction scope.

  You need to group tasks together while enabling them to be collapsed and expanded as a group.

  Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item in the answer area.)

  Hot Area:

  

  

• Question 38:

  You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02.

  The database Contoso exists on SQLServer01.

  You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.

  You need to prepare the Contoso database for database mirroring. 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:

  

  

• Question 39:

  You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.

  All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed.

  A. Set the Sensitive property of the parameter to True.
  B. Edit each package Connection Manager. Set the ServerName property to @[$Project::ServerParam].
  C. Edit the project Connection Manager in Solution Explorer. Set the ServerName property to @[$Project::ServerParam].
  D. Create a project parameter named ServerName.
  E. Create a package parameter named ServerName in each package.
  F. Set the Required property of the parameter to True.
  B. Edit each package Connection Manager. Set the ServerName property to @[$Project::ServerParam].
  D. Create a project parameter named ServerName.
  F. Set the Required property of the parameter to True.

• Question 40:

  You are a database administrator for a Microsoft SQL Server 2012 environment.

  You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.

  Which feature should you use?

  A. peer-to-peer replication
  B. snapshot replication
  C. failover clustering
  D. database audits
  A. peer-to-peer replication