- Home
- Microsoft
- Developing Microsoft SQL Server Databases
- Microsoft.70-464.v2018-12-10.q112
- Question 3
Valid 70-464 Dumps shared by ExamDiscuss.com for Helping Passing 70-464 Exam! ExamDiscuss.com now offer the newest 70-464 exam dumps, the ExamDiscuss.com 70-464 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-464 dumps with Test Engine here:
Access 70-464 Dumps Premium Version
(200 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 3/112
You need to create an indexed view that contains an aggregation.
Which function is required in the view definition?
Which function is required in the view definition?
Correct Answer: B
Explanation/Reference:
Explanation:
COUNT_BIG is a scalar aggregate function.
The capability of the query optimizer to take advantage of indexed views when it processes queries has improved over earlier version, such as support for aggregate functions.
For example, the following query that contains a scalar aggregate function in its SELECT list:
SELECT COUNT_BIG (*) FROM dbo.TableT
Can be matched with an index created on this view:
CREATE VIEW V2 WITH SCHEMABINDING AS
SELECT COUNT_BIG (*) AS Cnt
FROM dbo.TableT
Note: COUNT_BIG returns the number of items in a group. COUNT_BIG works like the COUNT function.
The only difference between the two functions is their return values. COUNT_BIG always returns a bigint data type value. COUNT always returns an int data type value.
References:
https://technet.microsoft.com/en-us/library/ms187864(v=sql.105).aspx
Explanation:
COUNT_BIG is a scalar aggregate function.
The capability of the query optimizer to take advantage of indexed views when it processes queries has improved over earlier version, such as support for aggregate functions.
For example, the following query that contains a scalar aggregate function in its SELECT list:
SELECT COUNT_BIG (*) FROM dbo.TableT
Can be matched with an index created on this view:
CREATE VIEW V2 WITH SCHEMABINDING AS
SELECT COUNT_BIG (*) AS Cnt
FROM dbo.TableT
Note: COUNT_BIG returns the number of items in a group. COUNT_BIG works like the COUNT function.
The only difference between the two functions is their return values. COUNT_BIG always returns a bigint data type value. COUNT always returns an int data type value.
References:
https://technet.microsoft.com/en-us/library/ms187864(v=sql.105).aspx
- Question List (112q)
- Question 1: You have a SQL Server instance named SQL\Instance1. Instance...
- Question 2: You plan to modify a procedure that contains hundreds of lin...
- Question 3: You need to create an indexed view that contains an aggregat...
- Question 4: You need to implement a solution that addresses the page spl...
- Question 5: You need to implement a solution that meets the security req...
- Question 6: You need to modify the function in CountryFromID.sql to ensu...
- Question 7: You need to convert the functionality of Legacy.sql to use a...
- Question 8: You have a SQL Server 2012 environment that contains two ser...
- Question 9: You need to recommend a solution to ensure that SQL1 support...
- Question 10: You have a SQL Server 2012 database named Database1. Databas...
- Question 11: You have a database that contains a table named Department. ...
- Question 12: You need to create the object used by the parameter of usp_I...
- Question 13: You need to identify the cause of the page split issues. Whi...
- Question 14: Your network contains a server named SQL1 that has SQL Serve...
- Question 15: You execute the following code: (Exhibit) You create a noncl...
- Question 16: You use SQL Server 2014 to maintain the data used by applica...
- Question 17: You need to ensure that a new execution plan is used by usp_...
- Question 18: You have a database that uses the following management views...
- Question 19: You need to provide referential integrity between the Office...
- Question 20: You attempt to process an invoice by using usp_InsertInvoice...
- Question 21: You are testing disaster recovery procedures. When you attem...
- Question 22: Your company has a main office in London and a branch in New...
- Question 23: You discover that the usp_GetOrdersAndItems stored procedure...
- Question 24: Your company has a SQL Azure subscription. You implement a d...
- Question 25: You use SQL Server 2012 to store data used by an e-commerce ...
- Question 26: You execute IndexManagement.sql and you receive the followin...
- Question 27: You need to implement a solution that meets the site require...
- Question 28: You need to ensure that if any of the statements in usp_Upda...
- Question 29: You are testing disaster recovery procedures. You attempt to...
- Question 30: You need to modify InsertInvoice to comply with the applicat...
- Question 31: You have a database named Database1. Database1 has two store...
- Question 32: You create a table named Customers by using the following co...
- Question 33: You have a table named Table1 that stores customer data. Eac...
- Question 34: You need to modify usp_GetOrdersAndItems to ensure that an o...
- Question 35: You need to encapsulate a T-SQL script into a reusable user-...
- Question 36: You plan to create a new column in a disk-based table. The c...
- Question 37: You have a SQL Server 2012 database named Database1. Databas...
- Question 38: You plan to modify a stored procedure to use temporary data....
- Question 39: You need to implement a solution that addresses the index mo...
- Question 40: You need to implement a solution that resolves the salary qu...
- Question 41: You plan to design an application that temporarily stores da...
- Question 42: You have a server that has SQL Server 2012 installed. You ne...
- Question 43: You are creating a stored procedure named usp1. Usp1 will cr...
- Question 44: You have a SQL Azure database. You execute the following cod...
- Question 45: You need to provide referential integrity between the Sessio...
- Question 46: You have a database hosted on SQL Azure. You are developing ...
- Question 47: You execute usp_SelectEmployeesByName multiple times, passin...
- Question 48: You have the following query on a disk-based table: (Exhibit...
- Question 49: You have a Microsoft SQL Azure database that contains a tabl...
- Question 50: You use SQL Server to maintain the data used by applications...
- Question 51: You need to implement a solution that addresses the bulk ins...
- Question 52: You execute the following code. (Exhibit) After populating t...
- Question 53: B\Batch 1 While testing usp.GetFutureSessions, you discover ...
- Question 54: You have a database named Database1. You execute the followi...
- Question 55: You have a SQL Server 2012 instance that hosts a single-user...
- Question 56: An administrator provides a digital certificate named Server...
- Question 57: You discover that usp.SelectSpeakersByName executes slowly i...
- Question 58: You have a database named database1. Database developers rep...
- Question 59: You are planning the ManufacturingSteps table. You need to d...
- Question 60: You need to implement a solution that addresses the upload r...
- Question 61: You have a table named Rooms that contains three columns. Yo...
- Question 62: Which code segment should you use to define the ProductDetai...
- Question 63: You have an index for a table in a SQL Azure database. The d...
- Question 64: You need to create a function that will use a SELECT stateme...
- Question 65: You have a SQL Server 2012 database that contains a table na...
- Question 66: You execute usp_TestSpeakers. You discover that usp_SelectSp...
- Question 67: You need to recommend a solution to ensure that SQL1 support...
- Question 68: Developers report that usp_UpdateSessionRoom periodically re...
- Question 69: You execute IndexManagement.sql and you receive the followin...
- Question 70: You have an application that uses a view to access data from...
- Question 71: You have a SQL Server 2012 database named Database1. You exe...
- Question 72: You have a database that is accessed by 300 concurrent users...
- Question 73: You need to identify which long running transactions use an ...
- Question 74: You need to create a script that automates the export of the...
- Question 75: You have a database that contains a user-defined function na...
- Question 76: You have a Microsoft SQL Azure database. You have the follow...
- Question 77: You need to create the InvoiceStatus table in DB1. How shoul...
- Question 78: You have a database for a mission-critical web application. ...
- Question 79: You need to modify the Orders table to store the XML data us...
- Question 80: Which data type should you use for CustomerID?...
- Question 81: You are creating a table named Orders. You need to ensure th...
- Question 82: You need to create the object used by the parameter of usp_U...
- Question 83: You have a SQL Azure database. You need to identify which ke...
- Question 84: You have database objects that were created by using the fol...
- Question 85: You execute the following code: (Exhibit) You have a stored ...
- Question 86: You have a Microsoft SQL Azure database named DBAzure1. You ...
- Question 87: You create a view by using the following code: (Exhibit) Sev...
- Question 88: You need to modify usp_SelectSpeakersByName to support serve...
- Question 89: You need to implement a solution that meets the job applicat...
- Question 90: You plan to create a stored procedure that inserts data from...
- Question 91: You need to design a solution that meets the refactoring req...
- Question 92: You have a database named DB1. You plan to configure change ...
- Question 93: You need to modify Production.ProductDetails_Insert to compl...
- Question 94: You plan to migrate an instance of SQL Server 2008 to a new ...
- Question 95: You have a SQL Server 2012 database named DB1 that is access...
- Question 96: You need to create a function that filters invoices by Custo...
- Question 97: You are creating a table to support an application that will...
- Question 98: You have a SQL Server 2012 database named DB1. You have a ba...
- Question 99: You have a Microsoft SQL Azure database that contains a tabl...
- Question 100: You are evaluating the table design. You need to recommend a...
- Question 101: You need to add a new column named Confirmed to the Attendee...
- Question 102: You need to implement a change to usp_ExportOpenings that me...
- Question 103: You have a SQL Server 2012 instance. You plan to create an a...
- Question 104: You plan to execute the following code: (Exhibit) You need t...
- Question 105: You need to ensure that usp_AddXMLOrder can be used to valid...
- Question 106: You need to add a new column named Confirmed to the Employee...
- Question 107: You execute the following code: (Exhibit) The execution plan...
- Question 108: You plan to create a database that has multiple tables. The ...
- Question 109: You have an index for a table in a SQL Azure database. The d...
- Question 110: A company has a main office in London and a branch office in...
- Question 111: You plan to create a new table that has the following requir...
- Question 112: You run the following code: (Exhibit) You need to ensure tha...
