Which of the following is TRUE with regards to FILESTREAM?
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.)
Which of the following failover types should you configure for the availability group?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You are configuring a highly-available database solution using an AlwaysOn availability
group on two servers running SQL Server 2012. The two servers are in separate
datacenters. The two datacenters are connected by a WAN link with a network latency of
more than 200ms.
Which of the following failover types should you configure for the availability group?
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 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 need to ensure that the stored procedure supports dirty reads
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the stored procedure supports dirty reads.
What should you do?
Which of the following is the correct Transact-SQL statement for achieving your goal?
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?
How should you configure the backup solution?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
The sales and marketing departments contain a total of 60 users. Each user uses a custom
application that stores data in a SQL Server database. Each user has a separate database.
A server named ABC-SQL1 hosts the 60 databases.
You need to configure a backup solution for all the databases. The solution must ensure
that any new databases configured on ABC-SQL1 are automatically added to the backup
schedule.
The backup schedule consists of a full backup every night, a differential backup every hour
and a transaction log backup every 15 minutes.
How should you configure the backup solution?
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 reason
for using the OFFSET-FETCH clause of the ORDER BY Transact-SQL statement.
Which of the following describes the clause’s purpose?
What should you configure?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
Computer users use custom applications that store data in SQL Server databases hosted
on a server named ABC-SQL1.
You discover that the Windows Application event log on ABC-SQL1 contains error events.
You need to configure a solution that will run an application whenever an event with a
specific event ID number is generated in the Windows Application event log.
What should you configure?
Which of the following is TRUE with regards to FileTable?
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.)
Which of the following SQL Server features should you configure?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy three new servers running SQL Server 2012 Standard Edition.
You need to configure the three servers to host databases that must be highly available.
Automatic failover is required in the event of a server failure.
Which of the following SQL Server features should you configure?