Which encryption type should you use?
You administer a SQL Server 2008 instance. The instance hosts a database that is used by
a Webbased application. The application processes 15,000 transactions every minute. A
table in the database contains a column that is used only by the application. This column
stores sensitive data. You need to store the sensitive data in the most secure manner
possible. You also need to ensure that you minimize the usage of memory space and
processor time. Which encryption type should you use?
You need to ensure that you can retrieve measure values based on the City and Country attributes
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimCustomer that contains the following three attributes:
Customer
City
Country
The Customer attribute is the key. The DimCustomer dimension is related to a measure
group
named Sales that has the Granularity property set to City.
You need to ensure that you can retrieve measure values based on the City and Country
attributes.
What should you do?
You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the weighted
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership.
The sum of all the values in the Ownership column for a single DimAccount member is
100%. You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer
dimension, the weighted value is calculated based on the Ownership measure.
What should you do?
You need to design a data access layer to simplify the extraction process
You are a database developer. You develop a database application for a SQL Server 2008
instance. The instance hosts a third-party database. You are not allowed to modify the
database schema. The database contains two tables that are as shown in the following
diagram. You plan to extract address information about full-time employees based on the
FullTimeIndicator flag. You need to design a data access layer to simplify the extraction
process. What should you do?
You need to optimize the performance of the application to meet the following requirement…
You have a legacy application. You do not have access to the application source code. The
application has a large denormalized table that contains 100 columns. The application uses
stored procedures and views to perform all data manipulation language (DML) activities on
the table. You need to optimize the performance of the application to meet the following
requirement: ·Reduce I/O ·Minimize the storage requirements ·Optimize insert, update, and
delete operations What should you do?
You need to create a measure that returns the number of customers who have placed orders
You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a
table named FactOrders that contains two columns as shown in the following table:
You need to create a measure that returns the number of customers who have placed
orders.
What should you do?
Which code segment should you use?
CORRECT TEXT
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You deploy a new server that has SQL Server 2012 installed. You need to create a table named
Sales.OrderDetails on the new server. Sales.OrderDetails must meet the following requirements:
Write the results to a disk.
Contain a new column named LineItemTotal that stores the product of ListPrice and Quantity for
each row.
The code must NOT use any object delimiters.
The solution must ensure that LineItemTotal is stored as the last column in the table. Which code
segment should you use?
To answer, type the correct code in the answer area.
You need to ensure that the application is deployed to the instance without loss of functionality
You administer a SQL Server 2008 instance. You plan to deploy a third-party database
application to the instance. The application uses stored procedures that are developed by
using SQL CLR integration. The application must be configured to enable the
EXTERNAL_ACCESS code access security setting. You need to ensure that the application
is deployed to the instance without loss of functionality. What should you do first?
You need to ensure that aggregations are not associated with the Price attribute
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You use
the DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?
Which control flow logic should you implement?
You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts
data from flat files and loads this data to a SQL Server 2008 database. The package
contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is
executed on holidays, the @IsHoliday variable is set to True. You need to implement the
following business logic in the control flow of the package:
When the ©IsWeekday variable is set to True, the Perform Weekday Processing Data Flow
task is executed.
When the ©IsWeekday variable is set to False, the Perform Weekend Processing Data Flow
task is executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task
is executed.
Which control flow logic should you implement?