Microsoft Administering Microsoft SQL Server 2012/2014 Databases - 070-462 Exam Practice Test
Question 1
You administer a Microsoft SQL Server 2012 default instance.
The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server.
You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.
Which three actions should you perform? Each correct answer presents part of the solution.
The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server.
You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.
Which three actions should you perform? Each correct answer presents part of the solution.
Correct Answer: B,E,F
Question 2
You have a large partitioned fact table in a data warehouse. The table is stored as a clustered index.
You need to modify the indexing solution to minimize the amount of disk space required to store the table.
What should you do?
You need to modify the indexing solution to minimize the amount of disk space required to store the table.
What should you do?
Correct Answer: D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 3
You administer a Microsoft SQL Server database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
Correct Answer: C
Question 4
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
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.)
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
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:
Explanation
References:
Question 5
You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
Correct Answer: A
Question 6
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?
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?
Correct Answer: A
Question 7
You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from an existing server to the new server.
You want to evaluate the new server's performance based on the workloads of the existing server.
To do so, you need to run the workloads captured from the existing server against the new server from multiple computers.
Which SQL Server tool should you use?
You want to evaluate the new server's performance based on the workloads of the existing server.
To do so, you need to run the workloads captured from the existing server against the new server from multiple computers.
Which SQL Server tool should you use?
Correct Answer: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 8
You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
Correct Answer: A
Question 9
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
Correct Answer: D
Question 10
You are migrating an OLTP database from Microsoft Azure SQL Database to on-premise. You are planning the installation of a Microsoft SQL Server server failover cluster.
The server has the following partitions:
You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors. The tempdb database cannot be placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is currently 200GB in size. It will not substantially increase in size in the next 3 years.
You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate database or databases to their corresponding hard disk or disks 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.)
The server has the following partitions:
You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors. The tempdb database cannot be placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is currently 200GB in size. It will not substantially increase in size in the next 3 years.
You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate database or databases to their corresponding hard disk or disks 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.)
Correct Answer:
Explanation
Question 11
You plan to install a Microsoft SQL Server 2012 instance.
The instance will support a database that has the following requirements:
* Store Excel workbooks on the file system.
* Access the workbooks through Transact-SQL.
* Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?
The instance will support a database that has the following requirements:
* Store Excel workbooks on the file system.
* Access the workbooks through Transact-SQL.
* Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?
Correct Answer: B
Question 12
Which feature should you enable and configure so session requests addressed to a specific instance can be allocated different processor resources based on session request properties?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 13
You administer a Microsoft SQL Server database that has multiple tables in the Sales schema.
Some users must be prevented from deleting records in any of the tables in the Sales schema.
You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?
Some users must be prevented from deleting records in any of the tables in the Sales schema.
You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?
Correct Answer: C
