070-458 무료 덤프문제 온라인 액세스

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

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 the following requirements are met:
The Sales role does not have the Select permission on the Customers schema.UserA has the Select permission on the Regions table.
Which Transact-SQL statement should you use?

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

DRAG DROP
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.)

정답:

DRAG DROP
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.)

정답:

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different,
untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?

• A.Use Kerberos authentication.
• B.Use certificates.
• C.Configure firewalls to allow Windows Logins.
• D.Use SQL Authenticated Logins.