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

You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database.
An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule.
You need to establish the automated validation process by using the least amount of administrative effort.
What should you do?

• A.Deploy the project by using dtutil.exe with the /COPY DTS option.
• B.View the job history for the SQL Server Agent job.
• C.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
• D.View the All Messages subsection of the All Executions report for the package.
• E.Store the System::SourceID variable in the custom log table.
• F.Use an event handler for OnError for the package.
• G.Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
• H.Use an event handler for OnError for each data flow task.
• I.Enable the SSIS log provider for SQL Server for OnError in the package control flow.
• J.Use an event handler for OnTaskFailed for the package.
• K.Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
• L.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
• M.Store the System::ExecutionInstanceGUID variable in the custom log table.
• N.Deploy the .ispac file by using the Integration Services Deployment Wizard.
• O.Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
• P.Deploy the project by using dtutil.exe with the /COPY SQL option.
• Q.Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and SSISDB.catalog.*tart_execution stored procedures.
• R.Store the System::ServerExecutionID variable in the custom log table.

You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night.
The Windows Azure SQL Database data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?

• A.Decrease the maximum number of matches per lookup.
• B.Change the similarity threshold to 0.40.
• C.Change the Exhaustive property to True.
• D.Change the similarity threshold to 0.55.

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.
Which Transact-SQL statement should you use?

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

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 and the Sales role is granted the Select permission on the Customers schema.
You need to ensure that the Sales role, including userA, is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?

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

----
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 5 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 need to ensure that your backup will continue if any invalid checksum is encountered.
Which backup option should you use?

• A.STANDBY
• B.SKIP
• C.Differential
• D.Transaction log
• E.DBO_ONLY
• F.NO_CHECKSUM
• G.RESTART
• H.COPY_ONLY
• I.CHECKSUM
• J.CONTINUE_AFTER_ERROR
• K.SIMPLE
• L.BULK_LOGGED
• M.FULL
• N.NORECOVERY