HOTSPOT
You have a database named Sales.
You need to create a table named Customer that includes the columns described in the following table:

How should you complete the Transact SQL statement? To answer, select the appropriate Transact-SQLsegments in the answer area.
Hot Area:

HOTSPOT
You are developing an app that allows users to query historical company financial data. You are reviewing
email messages from the various stakeholders for a project.
The message from the security officer is shown in the Security Officer Email exhibit below.
TO: Database developer
From: Security Officer
Subject: SQL object requirements
We need to simplify the security settings for the SQL objects. Having a assign permissions at every object in
SQL is tedious and leads to a problem. Documentation is also more difficult when we have to assign
permissions at multiple levels. We need to assign the required permissions at one object, even though that
object may be obtaining from other objects.
The message from the sales manager is shown in the Sales Manager Email exhibit below.
TO: Database developer
From: Sales Manager
Subject: Needed SQL objects
When creating objects for our use, they need to be flexible. We will be changing the base infrastructure
frequently. We need components in SQL that will provide backward compatibility to our front end applications
as the environments change so that do not need to modify the front end applications. We need objects that can
provide a filtered set of the data. The data may be coming from multiple tables and we need an object that can
provide access to all of the data through a single object reference.
This is an example of the types of data we need to be able to have queries against without having to change
the front end applications.

The message from the web developer is shown in the Web Developer Email exhibit below.
TO: Database developer
From: Web Developer
Subject: SQL Object component
Whatever you will be configuring to provide access to data in SQL, it needs to connect using the items
referenced in this interface. We have been using this for a long time, and we cannot change this from end
easily. Whatever objects are going to be used in SQL they must work using object types this interface
references.

You need to create one or more objects that meet the needs of the security officer, the sales manager and the
web developer.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Note: This question is part of a series of questions that present the same scenario. Each question in the series
contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stored information about the
employees of your company.
You need to implement the following auditing rules for the Employees table:
– Record any changes that are made to the data in the Employees table.
– Customize the data recorded by the audit operations.
Solution: You implement a user-defined function on the Employees table.
Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series
contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stored information about the
employees of your company.
You need to implement the following auditing rules for the Employees table:
– Record any changes that are made to the data in the Employees table.
– Customize the data recorded by the audit operations.
Solution: You implement a check constraint on the Employees table.Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series
contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stored information about the
employees of your company.
You need to implement the following auditing rules for the Employees table:
– Record any changes that are made to the data in the Employees table.
– Customize the data recorded by the audit operations.
Solution: You implement a stored procedure on the Employees table.
Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
– Employee ID
– date and time employee checked in to work
– date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
– Employee ID
– date and time employee checked in to work
– date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
– Employee ID
– date and time employee checked in to work
– date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
The Account table was created using the following Transact-SQL statement:

There are more than 1 billion records in the Account table. The Account Number column uniquely identifies
each account. The ProductCode column has 100 different values. The values are evenly distributed in the
table. Table statistics are refreshed and up to date.
You frequently run the following Transact-SQL SELECT statements:

You must avoid table scans when you run the queries.
You need to create one or more indexes for the table.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
The Account table was created using the following Transact-SQL statement:

There are more than 1 billion records in the Account table. The Account Number column uniquely identifies
each account. The ProductCode column has 100 different values. The values are evenly distributed in the
table. Table statistics are refreshed and up to date.
You frequently run the following Transact-SQL SELECT statements:

You must avoid table scans when you run the queries.
You need to create one or more indexes for the table.
Solution: You run the following Transact-SQL statement:
CREATE CLUSTERED INDEX PK_Account ON Account(ProductCode);
Does the solution meet the goal?