Microsoft 70-458 Online Practice Questions and Exam Preparation

Microsoft 70-458 Online Questions & Answers

• Question 51:

  You administer a SQL Server 2012 database instance.

  You need to configure the SQL Server Database Engine service on a failover cluster.

  A. a domain user
  B. the SQLBrowser account
  C. the BUILTIN\SYSTEM account
  D. a local user with Run as Service permissions
  A. a domain user

• Question 52:

  You are building a SQL Server Integration Services (SSIS) package to load product data sourced from aWindows Azure SQL Database database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.

  

  You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products taskfails.

  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 53:

  You administer a Microsoft SQL Server 2012 database.

  All database traffic to the SQL Server must be encrypted by using secure socket layer (SSL) certificates or the connection must be refused.

  Network administrators have deployed server certificates to the Windows store of all Windows servers on the network from a trusted Certificate Authority. This is the only Certificate Authority allowed to distribute certificates on the network.

  You enable the Force Encryption flag for the MSSQLServer protocols, but client computers are unable to connect. They receive the following error message:

  "A connection was successfully established with the server, but then an error occurred during the pre-login handshake, (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL

  Server)" You notice the following entry in the SQL Server log:

  "A self-generated certificate was successfully loaded for encryption."

  You need to configure SQL Server to encrypt all client traffic across the network. You also need to ensure that client computers are able to connect to the server by using a trusted certificate.

  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 54:

  You are preparing to install SQL Server 2012 Master Data Services (MDS), You need to ensure that the database requirements are met.

  A. Microsoft SharePoint Server 2010 Enterprise Edition SP1
  B. SQL Server 2012 Data Center (64-bit) x64 on the database server
  C. SQL Server 2012 Enterprise (64-bit) x64 on the database server
  D. SQL Server 2012 Standard (64-bit) x64 on the database server
  C. SQL Server 2012 Enterprise (64-bit) x64 on the database server

• Question 55:

  You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.

  Referential integrity must be enforced declaratively.

  You need to design a solution that can join a single time dimension to both fact tables.

  A. Create a time dimension that can join to both fact tables at their respective granularity.
  B. Merge the fact tables.
  C. Create a time mapping table.
  D. Join the two fact tables.
  B. Merge the fact tables.

• Question 56:

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

  The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.

  You need to create a separate data flow path for data that has been modified since it was last processed.

  A. Data Conversion
  B. Aggregate
  C. Lookup
  D. Multicast
  E. Slowly Changing Dimension
  C. Lookup
  D. Multicast

• Question 57:

  You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.

  Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.

  You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.

  What should you do?

  A. Use the gacutil command.
  B. Use the dtutil /copy command.
  C. Use the Project Deployment Wizard.
  D. Create an OnError event handler.
  E. Create a reusable custom logging component.
  F. Run the package by using the dtexec /rep /conn command.
  G. Run the package by using the dtexec /dumperror /conn command.
  H. Run the package by using the dtexecui.exe utility and the SQL Log provider.
  I. Add a data tap on the output of a component in the package data flow.
  J. Deploy the package by using an msi file.
  I. Add a data tap on the output of a component in the package data flow.

• Question 58:

  You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.

  You attempt to add a SQL login, [User1], to the database. However, you receive the following error message:

  "User already exists in current database."

  You need to configure the [User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions.

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 59:

  You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.

  The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.

  The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.

  You need to meet the requirements by using the least amount of administrative effort.

  A. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
  B. Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.
  C. For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
  D. For each target server, create a separate XML configuration file. Select the XML configuration file at package execution time.
  A. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.

• Question 60:

  You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found.

  After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable.

  You need to set the precedence constraints.

  Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.)

  

  Hot Area: