70-457 Exam Questions
153 real 70-457 exam questions with expert-verified answers and explanations. Page 1 of 4.
- Question #1
You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory (It...
- Question #2
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition. You need to improve the performance o...
- Question #4
You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with m...
- Question #9
You develop a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerId. You need to create a query th...
- Question #10
You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction...
- Question #11
Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named...
- Question #12
You use a Microsoft SQL Server 2012 database. You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transa...
- Question #13
You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code. You need to protect the code from being viewed by your c...
- Question #14
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You...
- Question #15
You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent th...
- Question #16
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements: - Returns a result set based on supplied parameters. - E...
- Question #17
You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistoncal. You write the following Transact-SQL query: INSERT INTO OrdersHistorical SELECT - FROM...
- Question #18
You develop a Microsoft SQL Server 2012 database. You need to create and call a stored procedure that meets the following requirements: - Accepts a single input parameter for Custo...
- Question #19
You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the...
- Question #20
Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non- cluster...
- Question #21
You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than...
- Question #22
You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules...
- Question #23
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 follow...
- Question #24
You develop a Microsoft SQL Server 2012 database that contains tables named Employee and Person. The tables have the following definitions: You create a view named VwEmployee as sh...
- Question #25
You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a colum...
- Question #26
You develop a Microsoft SQL Server 2012 database that contains a table named Products. The Products table has the following definition: You need to create an audit record only when...
- Question #27
A table named Profits stores the total profit made each year within a territory. The Profits table has columns named Territory, Year, and Profit. You need to create a report that d...
- Question #28
You use Microsoft SQL Server 2012 database to develop a shopping cart application. You need to rotate the unique values of the ProductName field of a table-valued expression into m...
- Question #29
You administer a Microsoft SQL Server database that supports a shopping application. You need to retrieve a list of customers who live in territories that do not have a sales perso...
- Question #30
You support a database structure shown in the exhibit. (Click the Exhibit button.) You need to write a query that displays the following details: - Total sales made by sales people...
- Question #31
You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you...
- Question #32
You administer a Microsoft SQL Server database that supports a banking transaction management application. You need to retrieve a list of account holders who live in cities that do...
- Question #33
You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.) C...
- Question #34
You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.) C...
- Question #35
You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named Productld, ProductName, and CreatedDateTime. The tabl...
- Question #36
You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3. You have permissions on both Database1 and Database2. You plan to write and deploy...
- Question #37
You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sal...
- Question #38
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...
- Question #39
You generate a daily report according to the following query: You need to improve the performance of the query. What should you do?
- Question #40
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Order...
- Question #46
You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the following columns: Id is the Primary Key. You need to append the "This is in a draft...
- Question #47
You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named DeleteJobCandidate. You need to ensure that if DeleteJobCandidate encounter...
- Question #48
You use Microsoft SQL Server 2012 to create a stored procedure as shown in the following code segment. (Line numbers are included for reference only.) The procedure can be called w...
- Question #49
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition. You need to ensure that users are abl...
- Question #50
You use Microsoft SQL Server 2012 to develop a database application. Your application sends data to an NVARCHAR(MAX) variable named @var. You need to write a Transact-SQL statement...
- Question #51
You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that...
- Question #52
Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification number through the @EmpID parameter. You need to build a sin...
- Question #53
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Order...
- Question #54
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Order...
- Question #55
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Order...
- Question #56
You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory ( I...
- Question #57
You develop a Microsoft SQL Server 2012 database that contains a table named Customers. The Customers table has the following definition: You need to create an audit record only wh...
- Question #58
You develop a Microsoft SQL Server 2012 database that has two tables named SavingAccounts and LoanAccounts. Both tables have a column named AccountNumber of the nvarchar data type....
- Question #59
You develop a Microsoft SQL Server 2012 database. You create a view that performs the following tasks: - Joins 8 tables that contain up to 500,000 records each. - Performs aggregat...
- Question #60
You are a database developer of a Microsoft SQL Server 2012 database. The database contains a table named Customers that has the following definition: You need to ensure that the C...