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(39152)

Back to Parent Category
Create QuestionPDF   Start Exam
.
Question: You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package is stored in a folder on ABC-DB01. All Abc.com users must be able to view the package but must not be able to view the attribute values. You need to ensure that the attribute values are protected by password. What should you do?

Answer:You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on the SSIS package.


Question: You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package on a development server named ABCDB03. The SSIS package obtains data that will be inserted in a database named CKProducts from a remote SQL Server 2008 database server named TESKING-DB01. The data is published to the MSDB database on a production server named ABC-DB02. You should make sure that only users belonging to the appropriate database role are able to change and run the package. What should you do?

Answer:You should assign the users to a common database role in the MSDB database.


Question: You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The solution contains a dimension named CKProducts and a time dimension named CKTimer. Abc has a fact table that has a field named Quantity. You need to develop a measure named CKQuantity from the Quantity field order to display the number of products for certain times. What should you do?

Answer:The AggregationFunction property of CKQuantity should be set to LastNonEmpty.


Question: You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. The SSAS solution includes a time dimension named CKTime which includes a hierarchy named Year-By-Day. The solution also contains a measure group named CKMeasure. You own a measure named Quantity from CKMeasure. You need to develop a calculated member in order to show the Quantity measure in the previous time period for the current level of the Year-By-Day hierarchy. What should you do?

Answer:You should use ([CKMeasures].[Quantity],LASTPERIODS(1,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.


Question: You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. You are in the process of creating a new measure group in a cube. Abc.com has an application that keeps the partitions on the production copy of the cube. You need to obtain the cube definition on the production server while ensuring that you do not overwrite any existed partitions. What should you do?

Answer:You should consider using the Deployment Wizard in conjunction with the proper selection.


Question: You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. Your solution contains a data source view (DSV) that owns a table named CKUsers. The CKUsers table contains a field named UserKey and a field named ManagerKey. The ManagerKey references the manager of the Abc.com user. You need to create a relationship between the users and their managers in the DSV. What should you do?

Answer:You should consider developing a relationship as the source column and UserKey as the destination column using the ManagerKey.


Question: You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. CubeA has a time dimension named CKTime that has an attribute named Month and a fact table named FactUsersTable. You need to include different hierarchies in the CKTime dimension. What should you do?

Answer:You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a regular relationship.


Question: You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You create a cube that uses a dimension named DimCKUsers. The dimension has a property named User. Abc.com also hosts a Microsoft SQL Server 2008 Reporting Services (SSRS) project that includes a report on a user. You need to determine a way to browse the data. What should you do?

Answer:You should consider setting up a URL action on the User feature.


Question: You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) instance for Abc.com. You need to deploy a data mining structure that contains the Microsoft Clustering mining model from Scalable K-Means to Non-scalable K-Means.
What should you do?


Answer:You should modify the CLUSTERING_METHOD property.


Question: You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You need to scrutinize different data mining theories. You have to modify the design of the data mining structure to test. You decide to add the ordered content type columns in the data mining model as well as the underlying case table. You need to ensure that the Data Mining Viewer is suitable for modification in the data mining structure as well as the data mining model technology. What should you do?

Answer:You should consider selecting ProcessFull.


Question: You work as a database administrator for Abc.com. You are using a Business Intelligence Development Studio (BIDS) project for a data mining structure. You want to change the settings on the Chart tab. What will the result be?

Answer:It will result in the trend in the lift chart staying unchanged and the trend in the profit chart is changed.


Question: You work as a database administrator for Abc.com. You are in the process of developing a model of data mining by using the SQL Server 2008 Analysis Services (SSAS). In order to develop a structure you use the listed Data Mining Extensions (DMX) code:
CREATE MINING STRUCTURE [Abc] ([User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Abc] LONG DISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS) You need to develop the mining model that will use the above structure and in addition also use Microsoft algorithm. What should you do?


Answer:You should consider inserting the following code: ALTER MINING STRUCTURE [Abc] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Abc] PREDICT, [Distance], [Monthly Income])


Question: You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The SSAS method contains a dimension and a measure group. The dimension is named CKTime and the measure group is named CKProducts. CKTime includes a property named _Month. CKProducts connects with the CKTime dimension. You need to ensure that the design on CKProduct contain the _Month property. What should you do?

Answer:You should configure the AggregationUsage feature.


Question: You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) project. You need to include a parent-child hierarchy for the dimension. The child key feature is named CKUser and the parent key feature is named CKManager. As the root member you need to ensure that the top user is included. What should you do?

Answer:You should set the IsAggregatable property of CKManager to false.


Question: You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) sample. The SSAS sample includes a database that is used by members of the Sales group. You create a new role named Northern Region using {[Product]. [Place]. [Place]. [Northern]} allowed permission configuration. You assign the Sales group to the Northern Region role. You need to ensure that the users are able to browse data in the Northern Region role. What should you do?

Answer:You should consider adding the Roles= Northern Region; parameter to the connection string.


Question: You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database for Abc.com. The SSAS database contains a dimension named CKOrders. You are in the process of updating a role named Analyze. You decide to set the security for the Managers role at a later stage. You need to ensure that member of the Managers role are able to run data based on two or less customers. What should you do?

Answer:You should consider inserting the expression: [CKOrders].CurrentMember,,LEAVES).Count <= 2


Question: You work as a database administrator at Abc.com. Your duties include managing a SQL Server Analysis Services (SSAS) database named ABC- DB01. ABC-DB01 is configured to use security roles and is managed through a Microsoft ASP.NET application that is not located on ABC-DB01. You need to use Windows Authentication for the application. You need to ensure that the application users are able to access the SSAS database normally. You should also ensure that the security restrictions role is permitted. What should you do?

Answer:You should consider setting Kerberos as the authentication method.


Question: You work as a database developer at Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. You enable caching for a partition. You want to make sure that the SSAS method can query connected data when you update storage aspects. What should you do?

Answer:You should set the ProcessingMode property of the partition to Immediate.


Question: Abc.com has hired you as a database administrator for their network. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) database named CKProducts for Abc.com. CKProducts contains a number of measure groups. A measure group named Product Data permits the refresh option more frequently than the other measure groups. You need to ensure that Product Data functions on a schedule managed through SSAS. What should you do?

Answer:You should consider changing the features of the ProactiveCaching property.


Question: You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services (SSRS) instance. During routine monitoring, you discover that this instance does not render any extensions for Microsoft Office Word. How would you modify the instance to render these extensions?

Answer:The RSReportServer.config file should be modified on ABC-DB01.