You need to update the cube definition on the production server without overwriting any existing partitions
You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new
measure group in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any
existing partitions.
What should you do?
Which data type should you use?
You are a database solutions architect. Your company plans to develop a solution by using
a SQL Server 2008 instance. You design a new database that contains a table to store
Microsoft Office documents. You have the following business requirements: ·The
documents are part of the database backup. ·The snapshots of the database are used. You
need to use an appropriate data type to store the documents. Which data type should you
use?
You need to ensure that the following business requirements are met: The backup strategy supports point-in-tim
You administer a SQL Server 2008 database solution. All data modifications are performed
through stored procedures that use only the INSERT, UPDATE, or DELETE statements.
You are designing a backup strategy. You need to ensure that the following business
requirements are met: The backup strategy supports point-in-time recovery for failure at
any time of day. The transaction log uses the least amount of disk space. What should
you do?
You need to ensure that the roles and partitions previously deployed to the test environment are unaffected by
You maintain a SQL Server 2008 Analysis Services (SSAS) database in a test environment.
You plan to deploy changes from an SSAS project in a development environment to the test
environment.
You need to ensure that the roles and partitions previously deployed to the test environment
are unaffected by the deployment.
What should you do?
Which stored procedure option should you use?
You are a database developer at an independent software vendor. You create stored procedures
that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?
You need to ensure that the instance uses the new folder in the minimum amount of downtime
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains
a database.
You change the DataDir property of the instance to a new folder.
You need to ensure that the instance uses the new folder in the minimum amount of
downtime.
What should you do?
You need to ensure that the sales manager can view only the members in the Product dimension that relate to th
You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is
responsible for the sales of bikes in the Northeast region. You plan to grant the necessary
permissions to the sales manager to access the database. You have two roles named
Northeast Region and Bikes. The schemas of the two roles are as shown in the following
table.
The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product
dimension that relate to the Bikes category in the Northeast region.
What should you do?
You need to restore the database to its state at the start of the batch process in the least possible time
You administer a SQL Server 2008 instance that hosts a database. The backup strategy
used by the database is as shown in the following table. You run a batch process on
Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is
invalidated because a user has modified some data at 21:05 hr on the same day. You need
to restore the database to its state at the start of the batch process in the least possible
time. What should you do?
Which object should you modify?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database, you discover that a Duplicate Key error
occurs.
You need to modify the ErrorConfiguration property so that the error condition is reported
and processing continues.
Which object should you modify?
Which trace event should you use?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to identify the queries that take a long time to run.
Which trace event should you use?