Download New Updated 70-458 Questions With 98 Percent Same As Real 70-458 Exam! (91-100)

New Braindump2go 70-458 Exam Questions Updated Today! Want to know New Questions in 2015 70-458 Exam? Download Free Braindump2go 70-458 Exam Preparation Materials Now!

Microsoft
Exam Code: 70-458
Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Exam

QUESTION 91
You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database.
You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?

A.    SQL user without login
B.    SQL user with a custom SID
C.    SQL user with login
D.    Domain user

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ff929071.aspx ¹

QUESTION 92
You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment.
All DBAs are members of the DOMAINJrDBAs Active Directory group.
You grant DOMAINJrDBAs access to the SQL Server.
You need to create a server role named SpecialDBARole that can perform the following functions:
- View all databases.
- View the server state.
- Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAINJrDBAs to the server role.
You also need to provide the least level of privileges necessary.
Which SQL statement or statements should you use? Choose all that apply.

A.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
B.    ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAINJrDBAs];
C.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
D.    GRANT VIEW DEFINITION TO [SpecialDBARole];
E.    CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
F.    GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];

Answer: BCF
Explanation:
http://msdn.microsoft.com/en-us/library/ee677634.aspx ²
http://msdn.microsoft.com/en-us/library/ms188659.aspx ³
http://msdn.microsoft.com/en-us/library/ms191291.aspx ⁴

QUESTION 93
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.    Query the sys.dm_db_index_usage_stats DMV.
B.    Query the sys.dm_db_missing_index_details DMV.
C.    Use the Database Engine Tuning Advisor.
D.    Query the sys.dm_db_missing_index_columns DMV.

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms174202.aspx ⁵

QUESTION 94
Drag and Drop Question
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.
You need to encrypt the database files at the page level.
You also need to encrypt the transaction log files.
Which four 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.)

Answer:

Explanation:
http://msdn.microsoft.com/en-us/library/bb510663.aspx ⁶
http://msdn.microsoft.com/en-us/library/bb934049.aspx ⁷

QUESTION 95
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database.
The database uses SQL Server Agent jobs to perform regular FULL and LOG backups.
The database uses the FULL recovery model.
You plan to perform a bulk import of a very large text file.
You need to ensure that the following requirements are met during the bulk operation:
- The database transaction log is minimally affected.
- The database is online and all user transactions are recoverable.
- All transactions are fully recoverable prior to the import.
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.)

Answer:

Explanation:
http://technet.microsoft.com/en-us/library/ms187048.aspx ^{10 8}
http://technet.microsoft.com/en-us/library/ms189272.aspx ⁹

QUESTION 96
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 Sales_2.ndf is corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

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

Answer: A
Explanation:
http://technet.microsoft.com/en-us/library/ms187048.aspx ^{10 8}
http://msdn.microsoft.com/en-us/library/aa337540.aspx ¹¹

QUESTION 97
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.
You need to establish the correct order for loading each table to maximize parallel processing. Which order should you use?

A.    1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance
B.    1. DimCurrency, DimOrganization in parallel
2. DimScenario, DimAccount in parallel
3. FactFinance
C.    1. DimCurrency, FactFinance in parallel
2. DimOrganization, DimScenario, DimAccount in parallel
D.    1. FactFinance
2. DimOrganization, DimScenario, DimAccount in parallel
3. DimCurrency
E.    1. DimCurrency
2. DimOrganization
3. DimScenario, DimAccount in parallel
4. FactFinance

Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms139892.aspx ¹²
http://msdn.microsoft.com/en-us/library/ms141261.aspx ¹³

QUESTION 98
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 A
B.    Option B
C.    Option C
D.    Option D

Answer: B

QUESTION 99
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs.
Your solution must minimize deployment and development efforts.
What should you do?

A.    Create a reusable custom logging component.
B.    Use the gacutil command.
C.    Use the Project Deployment Wizard.
D.    Run the package by using the dtexec /rep /conn command.
E.    Add a data tap on the output of a component in the package data flow.
F.    Create an OnError event handler.
G.    Use the dtutil /copy command.
H.    Deploy the package by using an msi file.
I.    Run the package by using the dtexec /dumperror /conn command.
J.    Run the package by using the dtexecui.exe utility and the SQL Log provider.
K.    Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to
store the configuration.

Answer: C

QUESTION 100
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.
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place.
The methodology has the following requirements:
- The deployment process must be simplified.
- All the logs must be centralized in SQL Server.
- Log data must be available via reports or T-SQL.
- Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.
What should you do?

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

Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms140246.aspx ¹⁴
http://msdn.microsoft.com/en-us/library/hh231187.aspx

http://www.braindump2go.com/70-458.html

1. http://msdn.microsoft.com/en-us/library/ff929071.a spx
2. http://msdn.microsoft.com/en-us/library/ee677634.a spx
3. http://msdn.microsoft.com/en-us/library/ms188659.a spx
4. http://msdn.microsoft.com/en-us/library/ms191291.a spx
5. http://msdn.microsoft.com/en-us/library/ms174202.a spx
6. http://msdn.microsoft.com/en-us/library/bb510663.a spx
7. http://msdn.microsoft.com/en-us/library/bb934049.a spx
8. http://technet.microsoft.com/en-us/library/ms18704 8.aspx
9. http://technet.microsoft.com/en-us/library/ms18927 2.aspx
10. http://technet.microsoft.com/en-us/library/ms18704 8.aspx
11. http://msdn.microsoft.com/en-us/library/aa337540.a spx
12. http://msdn.microsoft.com/en-us/library/ms139892.a spx
13. http://msdn.microsoft.com/en-us/library/ms141261.a spx
14. http://msdn.microsoft.com/en-us/library/ms140246.a spx