QUESTION NO: 1
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
Correct Answer: B
Vote an answer
QUESTION NO: 2
You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up telephone numbers for these companies.
The view has the following definition:
You need to ensure that users can update only the phone numbers by using this view. What should you do?
You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up telephone numbers for these companies.
The view has the following definition:
You need to ensure that users can update only the phone numbers by using this view. What should you do?
Correct Answer: A
Vote an answer
QUESTION NO: 3
You administer a Microsoft SQL Server database instance.
You plan to migrate the database to Microsoft Azure SQL Database. You verify that all objects contained in the database are compatible with Microsoft Azure SQL Database.
You need to ensure that database users and required server logins are migrated to Microsoft Azure SQL Database.
What should you do?
You administer a Microsoft SQL Server database instance.
You plan to migrate the database to Microsoft Azure SQL Database. You verify that all objects contained in the database are compatible with Microsoft Azure SQL Database.
You need to ensure that database users and required server logins are migrated to Microsoft Azure SQL Database.
What should you do?
Correct Answer: B
Vote an answer
QUESTION NO: 4
You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance.
You need to create a TCP endpoint to be used only by a login named Application3. The solution must ensure that Application only uses the new endpoint.
Which three statements should you execute? Each correct answer presents part of the solution.
You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance.
You need to create a TCP endpoint to be used only by a login named Application3. The solution must ensure that Application only uses the new endpoint.
Which three statements should you execute? Each correct answer presents part of the solution.
Correct Answer: B,E,G
Vote an answer
QUESTION NO: 5
You administer a Microsoft SQL Server database server.
A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct issue or issues in the answer area. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
You administer a Microsoft SQL Server database server.
A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct issue or issues in the answer area. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Correct Answer:
Explanation
QUESTION NO: 6
You develop a database for a travel application.
You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone information.
What should you do?
You develop a database for a travel application.
You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone information.
What should you do?
Correct Answer: J
Vote an answer
QUESTION NO: 7
You administer a Microsoft SQL Server 2012 database.
The database contains a Product table created by using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the Product table.
What should you do?
You administer a Microsoft SQL Server 2012 database.
The database contains a Product table created by using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the Product table.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
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?
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?
Correct Answer: B
Vote an answer
QUESTION NO: 9
Which of the following features can you install if you are installing SQL Server 2012 Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration? (Choose all that apply.)
Which of the following features can you install if you are installing SQL Server 2012 Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration? (Choose all that apply.)
Correct Answer: A,B,D
Vote an answer
QUESTION NO: 10
You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?
You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?
Correct Answer: A
Vote an answer