QUESTION 1
You have a customer who has several SQL Server 2012 database servers.
You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.
The customer identifies that the following must be supported for the column store indexes.
Data manipulation language (DML) statements
Nonclustered columnstore indexes
Clustered columnstore indexes
Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2016 database.
What should you identify?
A. clustered columnstore indexes
B. nonclustered columnstore indexes
C. data manipulation language (DML) statements
D. partitioning
Correct Answer: A
Explanation
Explanation/Reference:
Explanation: SQL Server 2016 has the features of SQL Server 2012 plus updateable clustered columnstore indexes. This feature is required here as DML
statements must be supported in the warehouse.
Reference: Columnstore Indexes Described
https://msdn.microsoft.com/en-us/library/gg492088(v=sql.120).aspx

QUESTION 2
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in
the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure.
What should you use?
A. Activity Monitor
B. Sp_who3
C. SQL Server Management Studio (SSMS) Object Explorer
D. SQL Server Data Collector
E. SQL Server Data Tools (SSDT)
F. SQL Server Configuration Manager
Correct Answer: A
Explanation
Explanation/Reference:
Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server. Activity Monitor is a tabbed
document window with the following expandable and collapsible panes: Overview, Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive
Queries.
The Activity User Tasks Pane shows information for active user connections to the instance, including the following column:
* Login: The SQL Server login name under which the session is currently executing.
The Recent Expensive Queries Pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds, including
the following column:
* CPU (ms/sec): The rate of CPU use by the query
References:https://technet.microsoft.com/en-us/library/cc879320(v=sql.105).aspx