70-461

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You deploy a new server that has SQL Server 2012 installed. You need to create a table named Sales.OrderDetails on the new server. Sales.OrderDetails must meet the following requirements: • Write the...

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?A . Convert all indexes to...

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a query that calculates the total sales of each OrderId from the Sales.Details table. The solution must meet the following requirements: • Use one-part names to reference columns....

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 SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number...

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 1 MB in size. The media files will require fast access and will be retrieved frequently. What should...

CORRECT TEXT You have an XML schema collection named Sales.InvoiceSchema. You need to declare a variable of the XML type named XML1. The solution must ensure that XML1 is validated by using Sales.InvoiceSchema. Which code segment should you use? To answer, type the correct code in the answer area.View AnswerAnswer:...

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a view named uv_CustomerFullName to meet the following requirements: • The code must NOT include object delimiters. • The view must be created in the Sales schema. •...

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 stage" string to the Summary column of the recent 10 entries based on the values in...

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.) Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record...

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 person. Which Transact- SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that...