You need to monitor the data that passes through each path in the data flow by using the Business Intelligence
You design a SQL Server 2008 Integration Services (SSIS) package that contains several
data flows.
You need to monitor the data that passes through each path in the data flow by using the
Business Intelligence Development Studio. You also need to ensure that data flow logic is
retained.
What should you do?
What should you do?
You administer a SQL Server 2008 instance. The instance hosts a database that contains
sensitive data. You plan to implement a database backup strategy for the database. You
need to ensure that all backups of the database are encrypted. You also need to prevent
unauthorized access of the backups. What should you do?
Which data flow component should you select?
You are designing a SQL Server 2008 Integration Services (SSIS) package.
The package includes a Data Flow task that copies several million rows. The data flow
requires a match against a reference table that contains 10,000 rows. Each row in the
reference table will be used during the data flow.
You need to ensure that the data flow executes in the minimum amount of time.
Which data flow component should you select?
Which query should you use?
Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both
tables contain more than 100 million rows. Each table has a Primary Key column named
SalesOrderId. The data in the two tables is distinct from one another.
Business users want a report that includes aggregate information about the total number of global
sales and total sales amounts.
You need to ensure that your query executes in the minimum possible time.
Which query should you use?
What should you specify in the full-text query?
You are a database developer. You plan to design a database solution by using SQL Server
2008. You have a Web site supported by a database that has the full-text search
component installed. You plan to create a table named Courses that will have the following
structure. Users of the Web site will search for courses based on the CourseTitle field. You
need to construct a full-text query that ensures the following compliances when a user
launches the search for a course: ·Rows are returned when the exact search phrase is
found. ·Rows are in order of how well they match with the search phrase. What should you
specify in the full-text query?
You need to apply the configuration to the deployed package
You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration to the deployed package.
What should you do?
Which DMV should you use?
You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute a query for more than 30,000 ms.
Which DMV should you use?
You need to ensure that if the Finance department does not approve the batch process, the batch operation can
You administer a SQL Server 2008 instance that hosts a large financial database. The
database has the following backup strategies: A full database backup is performed once
a week. A differential backup is performed every day. A transaction log backup is
performed every hour. You plan to execute an end-of-year batch process that takes two
hours to run. The batch process will modify about five percent of data within the database.
You need to ensure that if the Finance department does not approve the batch process, the
batch operation can be rolled back in minimum possible time. What should you do prior to
starting the batch process?
You need to allow the Managers role to access aggregate data based on only three or less employees
You update a role named Managers for the Human Resources cube in your SQL Server
2008 Analysis Services (SSAS) database. The database contains a dimension named
Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less
employees.
What should you do?
Which XML for Analysis (XMLA) command should you use?
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to refresh data in a partition every two hours.
You need to implement the incremental processing strategy.
Which XML for Analysis (XMLA) command should you use?