You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named Sales.Orders with the following script.

Each order is tracked by using one of the following statuses:
* Fulfilled
* Shipped
* Ordered
* Received
You need to design the database to ensure that that you can retrieve the following information:
* The current status of an order
* The previous status of an order.
* The date when the status changed.
* The solution must minimize storage.
More than one answer choice may achieve the goal. Select the BEST answer.

• A. To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate. Update rows as the order status changes.
• B. Implement change data capture on the Sales.Orders table.
• C. To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate.
  Update the value of each column from null to the appropriate date as the order status changes.
• D. Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
Your company is developing a new business intelligence application that will access data in a Microsoft Azure SQL Database instance. All objects in the instance have the same owner.
A new security principal named BI_User requires permission to run stored procedures in the database. The stored procedures read from and write to tables in the database. None of the stored procedures perform IDENTIFY_INSERT operations or dynamic SQL commands.
The scope of permissions and authentication of BI_User should be limited to the database. When granting permissions, you should use the principle of least privilege.
You need to create the required security principals and grant the appropriate permissions.
Solution: You run the following Transact-SQL statement in the database:

Does the solution meet the goal?

• A. No
• B. Yes

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.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts a customer database named DB1.
Customers connect to hosted database instances by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).
You need to grant the developers permission to alter views for DB1 while following the principle of least privilege.
Which permission should you grant?

• A. db_datawriter
• B. sysadmin
• C. DDLAdmin
• D. dbo
• E. dbcreator
• F. View Database State
• G. View Definition
• H. View Server State

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 website.
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 username, passwords and credit card details are securely stored in the database.
Which of the following would be the most suitable secure storage solution?

• A. IPSec
• B. Transparent Data Encryption (TDE)
• C. Encrypting File System (EFS)
• D. Data encryption
• E. Secure Sockets Layer (SSL)