You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 instance in their environment.
ABC.com’s SQL Server 2012 instance includes a single-user database that has no user-created
stored procedures or user-created functions configured. You have been instructed to make sure
that the memory used for query plan caching is reduced.
Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find unused indexes.
Which of the following is the correct Transact-SQL statement for achieving your goal?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the
properties of sparse columns.
Which of the following are data types that cannot be identified as SPARSE? (Choose all that
apply.)

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the
FILESTREAM SQL Server technology.
Which of the following is TRUE with regards to FILESTREAM? (Choose all that apply.)

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com subscribes to SQL Azure, which hosts a ABC.com database.
You are preparing to create the schema for a table that will be populated with rows not exceeding
1 million.
The table will include an ID column, which should make use of a data type that allows for an
incremental numeric value to identify the row.
Which of the following is the data type that should be configured for the ID column?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find indexes that require
defragmentation.
Which of the following is the correct Transact-SQL statement for achieving your goal?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the reason
for using the OFFSET-FETCH clause of the ORDER BY Transact-SQL statement.
Which of the following describes the clause’s purpose?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain

named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the
FileTable feature.
Which of the following is TRUE with regards to FileTable? (Choose all that apply.)

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com subscribes to SQL Azure, which hosts a ABC.com database.
You are preparing to create the schema for a table that will be populated with rows not exceeding
1 million.
The table will include a Name column, which should make use of a data type that allows for an
alphanumeric code that has five characters.
Which of the following is the data type that should be configured for the Name column?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain

named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a SQL
Server Encryption option that runs real-time I/O encryption and decryption of the data and log files.
Which of the following is being discussed?