Free Microsoft 070-458 Exam Dumps Questions & Answers

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which Data Flow transformation should you use?

• A.  Conditional Split
• B.  Source Assistant
• C.  Multicast
• D.  Script Task

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.
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.  Database Mirroring
• B.  Log Shipping
• C.  Availability Groups
• D.  Peer-to-Peer Replication

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 SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named userA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from any of the tables in the Customers schema.
Which Transact-SQL statement should you use?

• A.  DENY SELECT ON Schema::Customers FROM Sales
• B.  DENY SELECT ON Object::Regions FROM UserA
• C.  DENY SELECT ON Schema::Customers FROM UserA
• D.  EXEC sp_droprolemember 'Sales', 'UserA'
• E.  REVOKE SELECT ON Schema::Customers FROM Sales
• F.  REVOKE SELECT ON Schema::Customers FROM UserA
• G.  REVOKE SELECT ON Object::Regions FROM UserA
• H.  REVOKE SELECT ON Object::Regions FROM Sales
• I.  DENY SELECT ON Object::Regions FROM Sales
• J.  EXEC sp_addrolemember 'Sales', 'UserA'

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

• A.  Use the Database Engine Tuning Advisor.
• B.  Query the sys.dm_db_missing_index_columns DMV.
• C.  Query the sys.dm_db_missing_index_details DMV.
• D.  Query the sys.dm_db_index_usage_stats DMV.

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

• A.  Perform a transaction log restore.
• B.  Perform a filegroup restore.
• C.  Perform a restore from a full backup.
• D.  Perform a file restore.