Jun 2016 updated: 70-458 exam dumps pdf

Exam Code: 70-458 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-458 Exam.

2016 Jun 70-458 Study Guide Questions:

Q21. RAG DROP 

You administer a Microsoft SQL Server database. 

You want to import data from a text file to the database. 

You need to ensure that the following requirements are met: 

. Data import is performed from a Windows batch file. 

. Data is loaded as a unit and is minimally logged. 

Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.) 


Answer: 



Q22. 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 


Q23. 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 S 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 implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failoverto this secondary database. 

You need to ensure that all transactions will be replicated to the secondary database. 

Which backup option should you use? 

A. Differential 

B. Transaction log 

C. FULL 

D. SIMPLE 

E. BULK_LOGGED 

F. SKIP 

G. RESTART 

H. STANDBY 

I. CHECKSUM 

J. DBO_ONLY 

K. COPY_ONLY 

L. NORECOVERY 

M. NO_CHECKSUM 

N. CONTINUE_AFTER_ERROR 

Answer: L 


70-458  real exam

Far out exam 70-458 vce:

Q24. RAG 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.) 


Answer: 



Q25. You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. 

You need to use DQS profiling to obtain the required statistics. 

Which DQS activity should you use? 

A. Cleansing 

B. Knowledge Discovery 

C. Matching Policy 

D. Matching 

Answer: A 


Q26. You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. 

All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs 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 DOMAIN\JrDBAs 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 [DOMAIN\JrDBAs]; 

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: B,C,F 


70-458  real exam

Certified mcp 70-458:

Q27. 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 OH Schema:: Customers FROM Soles 

C. REVOKE SELECT ON Object::Regions FROM Soles 

D. REVOKE SELECT ON Schema:Customers FROM Soles 

E. DENY SELECT ON Object::Regions FROM UserA 

F. DENY SELECT ON Schema:Customers FROM UserA 

G. REVOKE SELECT ON Object::Regions FROM UserA 

H. REVOKE SELECT ON Schema::Customers FROM UserA 

I. EXEC sp_oddrolemember 'Sales', 'UserA' 

J. EXEC sp_droprolemember 'Sales', 'UserA' 

Answer: D 


Q28. You administer a Microsoft SQL Server 2012 database instance. 

You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. 

You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database. 

What should you do? 

A. Back up the database from the local server and restore it to Windows Azure SQL Database. 

B. Use the Copy Database wizard. 

C. Use the Database Transfer wizard. 

D. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database. 

Answer: D 


Q29. You are designing a data warehouse with two fact tables. The first table contains sales per 

month and the second table contains orders per day. 

Referential integrity must be enforced declaratively. 

You need to design a solution that can join a single time dimension to both fact tables. 

What should you do? 

A. Create a time dimension that can join to both fact tables at their respective granularity. 

B. Merge the fact tables. 

C. Create a time mapping table. 

D. Join the two fact tables. 

Answer: B 


Q30. A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. 

To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file. 

You need to implement the change to the existing package while minimizing the development effort. 

What should you use to call the web service to retrieve the daily exchange rates? 

A. a Script component 

B. a Web Service source 

C. a Web Service task 

D. a Script task 

Answer: C 



see more 70-458 dumps