Which of the following is the data type that should be configured for the Name 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 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?
How can you ensure that stored procedures on ABC-Dev1 comply with the company naming convention?
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 a new SQL Server named ABC-Dev1. The server will be used by users
in the Development department for testing their applications.
You need to ensure that all stored procedures start with “usp_” to comply with the
company naming convention.
How can you ensure that stored procedures on ABC-Dev1 comply with the company
naming convention?
Which of the following is being discussed?
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?
You need to optimize the table so that the storage space used for each row is minimized
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
You need to create a table for a database. The table will have between 1 million and 5
million rows. The table will have columns that have null-valued rows 70% of the time.
You need to optimize the table so that the storage space used for each row is minimized.
What should you do?
Which of the following is the argument being discussed?
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 query hint
argument that instructs the query optimizer to make use of statistical data instead of the initial
values for all local variables when the query is compiled and optimized.
Which of the following is the argument being discussed?
Which of the following would be most suitable secure storage solution?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company has a Windows Azure subscription. The company uses a cloud-based SQL
Server environment hosted on SQL Azure.
Developers in your company are creating an ecommerce web site. You are designing a
database for the website. The database will be hosted on SQL Azure.
The database will store and reuse web site login details and customer credit card numbers.
You need to ensure the usernames, passwords and credit card details are securely stored
in the database.
Which of the following would be most suitable secure storage solution?
Which of the following are benefits of using table-valued parameters?
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 benefits
of using table-valued parameters.
Which of the following are benefits of using table-valued parameters?
Which of the following is TRUE with regards to table-valued parameters
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 tablevalued parameters.
Which of the following is TRUE with regards to table-valued parameters
Which of the following is the argument being discussed?
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 query hint
argument that instructs the query optimizer to make use of a particular value for a local variable
when the query is compiled and optimized.
Which of the following is the argument being discussed?
Which of the following is the command being discussed?
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 TransactSQL management command that ends a user procedure that is based on the session ID or unit of
work.
Which of the following is the command being discussed?