get the app get the app       get the app       get the app

70-448 MS SQL Server 2008, Business Intelligence

Exam Name70-448 MS SQL Server 2008, Business Intelligence
Description70-448 MS SQL Server 2008, Business Intelligence questions and Answers exams contains the questions from various interview of IT industry.These questions are helpful to crack the IT interview.
Exam TypeMASTER EXAM
Authenticity10005
creatorAnirudh(39272)

Back to Parent Category
Create QuestionPDF   Start Exam
.
Question: You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB03. You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for the ABC.com network. ABC.com has informed you that ABC- DB03 will be hosting the package. You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03 becomes inactive. How can this be achieved?

Answer:The master database should be backed up.


Question: You work as a database administrator at ABC.com. Your duties include administering a SQL Server 2008 Analysis Services (SSAS) sample named ABC-DB01. You receive an instruction from the CIO to log all queries. You then decide to make the necessary changes to the QueryLogconnection String feature. What should your next step be?

Answer:A valid connection string should be set on ABC-DB01.


Question: You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role. While querying ABC- DB05, you are presented with a Duplicate Key error. You receive an instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve this problem. Which of the following actions should you take?

Answer:The dimension should be modified.


Question: You work as a database administrator for ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB01 that contains a single partition. ABC-DB01 is hosting a SQL Server 2008 Analysis Services (SSAS) role. You are tasked with the responsibility of ensuring that information is updated in the partition every thirty minutes. Identify the command that will assist you in updating the partition?

Answer:The ProcessAdd command should be used.


Question: You work as a database administrator for ABC.com. The ABC.com network has a SQL Server 2008 Analysis Services (SSAS) instance on a database server named ABC-DB05. ABC-DB05 contains a DataDir feature. You receive notification from management to change the feature to a folder named Features. It is imperative that Features is used in as little time as possible.
How can you achieve this?


Answer:By running the database.


Question: You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 database server named ABC-DB01. You are in the process of creating a complex report on ABC-DB01 using SQL Server 2008 Reporting Services (SSRS). You receive an instruction to have the report cached for the first twenty minutes upon commencing the request. You then decide to configure ABC-DB01 to comply with the stipulation. Which of the following actions should you take?

Answer:Report execution caching should be configured.


Question: You work as a database administrator for ABC.com. You are responsible for a SQL Server 2008 computer named ABC-DB01, which hosts a SQL Server 2008 Reporting Services (SSRS) sample. A new ABC.com policy permits users to move reports via e-mail. ABC-DB01 should therefore be configured for the delivery of e-mail. How can you configure ABC-DB01 to send or receive e-mail messages?

Answer:The RSReportServer.config file should be modified.


Question: You work as a database administrator for ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB01. ABC- DB01 is hosting the SQL Server Analysis Services (SSAS). ABC-DB01 hosts numerous measure groups including a group named ABCSales that makes more use of the refresh option that the other groups. You receive an instruction from the CIO to supervise ABCSales via ABC-DB01. You thus decide to monitor it in a table.
How can you achieve this?


Answer:The features of the ProactiveCaching property should be modified.


Question: You work as a database administrator for ABC.com. The ABC.com network contains a database server named ABC-DB02 that is configured to host the SQL Server 2008 Analysis Services (SSAS) role. ABC-DB02 contains a single partition. You receive an instruction from the CIO to implement caching on the partition. Several times during the day the storage data is updated on ABC-DB02. You therefore need to configure the partition to ensure that the role is able to query the connected data whilst being updated. You then decide to make the necessary modifications to the ProcessingMode feature. What should your next step encompass?

Answer:The partition should be modified to Immediate.


Question: You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05. You are in the process of deploying a SQL Server Analysis Services (SSAS) instance. The SSAS instance contains a dimension, named Exams, which has a property named Screen Shots. You are tasked with seeing that the aggregations and the Screen Shots property are not connected to each other. You decide to have the AttributeHierarchyEnabled feature configured to complete this task. Which of the following actions should you take?

Answer:The Screen Shots feature should be configured to False.


Question: You create a SQL Server 2008 Analysis Services (SSAS) solution.

Your solution contains a cube with a dimension named Factories. The dimension has a property names ProductionLines. This solution also includes data about the suers employed at each factory.

You need to provide a way to browse the data within the dimension.

What should you do?


Answer:Set get values from a query in the Report Parameters dialog.


Question: You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.

You need to enable the DNN application to connect to the report.

What should you do?


Answer:Deploy the report to the Report Server.


Question: You develop a SQL Server 2008 Reporting services (SSRS) instance of a report model.

The organization requires that users of a report be able to dynamically change the server environment.

You need to create a parameter that gives the user the option to choose the server before report execution.

What should you do?


Answer:Create a dynamic data source from a dataset that includes a list of distinct servers.


Question: The data warehouse is missing information that exists in the Excel files.

You need to discover why the data warehouse is missing data.

What should you verify first to begin troubleshooting?


Answer:That MSDTC has been started on the system.


Question: The package extracts data from a remote server and inserts it in the PROD database on the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server.

You need to ensure that users can view, execute, and delete their own packages.

What should you do?


Answer:Assign the users to the db_ssisltduser role.


Question: You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.

You need maintain SSAS performance by preventing the partition from entering ROLAP mode.

What should you do?


Answer:Set the OnlineMode property for thepartition to OncacheComplete.


Question: You maintain a SQL Server 2008 Analysis Services (SSAS) database.

You are troubleshooting query performance by using SQL Profiler.

You are identifying the queries that take a long time to run. You determine the time used by the Storage Engine.

You need to determine the time used by the Formula Engine.

What trace event should you use?


Answer:Query Cube End


Question: 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 more than 10 commands prior to disconnecting.

Which DMV should you use?


Answer:Discover_Sessions


Question: You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance.

You plan to document the Analysis Services performance information.

You need to collect information related to cache hits from the memory when the database is processed.

Which object should you use?


Answer:MSAS 2008: Storage Engine Query


Question: 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.

Same row are not matching due to a mismatched case type

You need to ensure that the data flow executes to match all rows correctly.

Which data flow component should you select?


Answer:A Lookup transformation along with the No cache option