Microsoft 70-458 Online Practice Questions and Exam Preparation

Microsoft 70-458 Online Questions & Answers

• Question 1:

  You administer a Windows Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Reporting.

  

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

• Question 2:

  Note: This question is 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) project that copies a large amount of rows from aWindows Azure SQL Database database. The project uses the PackageDeployment Model. This project is deployed to SQL Server on atest server.

  You need to ensure that the project is deployed to the SSIS catalog on the production server.

  A. Add an OnError event handler to the SSIS project.
  B. use an msi file to deploy the package on the server.
  C. Open a command prompt and run the gacutil command.
  D. Open a command prompt and run the dtutil /copy command.
  E. Open a command prompt and run the dtexec /rep /conn command.
  F. Open a command prompt and run the dtexec /dumperror /conn command.
  G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  H. create a reusable custom logging component and use it in the SSIS project.
  I. Configure the SSIS solution to use the Project Deployment Model.
  J. Configure the output of a component in the package data flow to use a data tap.
  I. Configure the SSIS solution to use the Project Deployment Model.

• Question 3:

  You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process.

  You need to load data from all copied files to a destination table in SQL Server.

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

  You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails.

  You add two Windows groups as logins for the server:

  

  CORP\Employees - All company employees

  

  CORP\HRAdmins - HR administrators only

  

  HR Administrators are also company employees.

  

  You need to grant users access according to the following requirements:

  

  CORP\Employees should have SELECT access to the Employees table.

  Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table. Logins are based only on Windows security groups.

  A. Create a database role called Employees. Add CORP\Employees to the db_datareader role. Add all company employees except HR administrators to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.
  B. Create a database role called HRAdmins. Add all company employees except HR administrators to the db_datareader role, Add all HR administrators to the HRAdmins role. Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the db_datareader role.
  C. Create two database roles: Employees and HRAdmins. Add all company employees to the Employees role. Add HR administrators to the HRAdmins role. Grant SELECT access to all tables except SalaryDetails to the Employees role. Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the Employees role.
  D. Create a database role called Employees. Add all HR administrators to the db_datareader role. Add all company employees to the Employees role. Grant SELECT access to all tables except the SalaryDetails table to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.
  D. Create a database role called Employees. Add all HR administrators to the db_datareader role. Add all company employees to the Employees role. Grant SELECT access to all tables except the SalaryDetails table to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.

• Question 5:

  You are installing the Data Quality Server component of Data Quality Services.

  You need to provision the hardware and install the software for the server that runs the Data Quality Server.

  You must ensure that the minimum Data Quality Server prerequisites are met.

  A. Install Microsoft Internet Explorer 6.0 SP1 or later.
  B. Install SQL Server 2012 Database Engine.
  C. Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.
  D. Install the .NET Framework 4.0.
  B. Install SQL Server 2012 Database Engine.

• Question 6:

  You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).

  The financial database has the following characteristics:

  

  A data file of 2 terabytes is located on a dedicated LUN (drive D).

  

  A transaction log of 10 GB is located on a dedicated LUN (drive E).

  

  Drive D has 1 terabyte of free disk space.

  

  Drive E has S GB of free disk space.

  The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.

  The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.

  These data load operations must occur in the minimum amount of time.

  A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

  You implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failoverto this secondary database.

  You need to ensure that all transactions will be replicated to the secondary database.

  A. Differential
  B. Transaction log
  C. FULL
  D. SIMPLE
  E. BULK_LOGGED
  F. SKIP
  G. RESTART
  H. STANDBY
  I. CHECKSUM
  J. DBO_ONLY
  L

• Question 7:

  You administer several Microsoft SQL Server 2012 servers. Your company has a number of offices across the world connected by using a wide area network (WAN).

  Connections between offices vary significantly in both bandwidth and reliability.

  You need to identify the correct replication method for each scenario.

  What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.)

  Select and Place:

  

  

• Question 8:

  You administer a Microsoft SQL Server database.

  You want to import data from a text file to the database.

  You need to ensure that the following requirements are met:

  

  Data import is performed from a Windows batch file.

  

  Data is loaded as a unit and is minimally logged.

  Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

  Select and Place:

  

  

• Question 9:

  Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

  You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.

  

  At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database.

  You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal.

  What should you do?

  A. Perform a page restore.
  B. Perform a partial restore.
  C. Perform a point-in-time restore.
  D. Restore the latest full backup.
  E. Restore the latest full backup. Then, restore the latest differential backup.
  F. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
  G. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
  H. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
  A. Perform a page restore.

• Question 10:

  Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

  You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.

  

  The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours.

  You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.

  What should you do?

  A. Perform a page restore.
  B. Perform a partial restore.
  C. Perform a point-in-time restore.
  D. Restore the latest full backup.
  E. Restore the latest full backup. Then, restore the latest differential backup.
  F. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
  G. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
  H. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
  D. Restore the latest full backup.