Online Access Free 70-458 Practice Test

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.Multicast
• B.Source Assistant
• C.Conditional Split
• D.Script Task

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 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 remove the Select permission for userA on the Regions table. You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions.
Which Transact-SQL statement should you use?

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

--- -
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.
Which destination component should you use?

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

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.Script Task
• C.Data Conversion
• D.Destination Assistant

DRAG DROP
You are building a fact table In a data warehouse.
The table must have a columnstore index. The table cannot be partitioned.
You need to design the fact table and load it with data.
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.)

Correct Answer: