Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 41:

  You design a report by using SQL Server 2008 Reporting Services (SSRS).

  Detail information is displayed each time the users render the report.

  You need to ensure that the following requirements are met:

  

  Summary information is displayed when the report is initially rendered.

  

  Detail information is displayed only when the users click a column header. What should you do?

  A. On the column that contains detail information, set the hidden property to True. Set the Visibility can be toggled by another report item property to True.
  B. On the column that contains detail information, set the hidden property to False. Set the Visibility can be toggled by another report item property to False.
  C. On the column that contains detail information, set the hidden property to True. Set the Visibility can be toggled by another report item property to False.
  D. On the column that contains detail information, set the hidden property to False. Set the Visibility can be toggled by another report item property to True.
  A. On the column that contains detail information, set the hidden property to True. Set the Visibility can be toggled by another report item property to True.

• Question 42:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a Sale dimension that includes the Category and Subcategory properties for Company.com.

  There is a rigid relationship type for properties.

  The data source for the Sale dimension alters the relationship between the Type and Sub Type values.

  You should make sure that you could run an XML to operate the dimension to reflect the change normally for Analysis (XMLA).

  Which is the correct answer?

  A. You should utilize the ProcessDefault command.
  B. You should utilize the ProcessClear command.
  C. You should utilize the ProcessIndexes command.
  D. You should utilize the ProcessDefault and the ProcessClear commands.
  D. You should utilize the ProcessDefault and the ProcessClear commands.

  ---

  Process Default Performs the minimum number of tasks required to fully initialize a mining object. For example, if you change a model and send Process Default to the structure, the server will process that model only. Process Full Drops the object stores and rebuilds the model. Metadata changes, such as adding a new column to a mining structure, require Process Full. Process Structure Reads and caches the training data in the structure. Does not affect the mining models inside the structure. Process Clear Structure Drops the cached data without affecting the mining models inside the structure. Disables drillthrough features. Consider Process Clear Structure if you need to dispose of the sourcedata used to train the models to reduce the disk footprint. Unprocess Deletes data from the mining object. When this command is sent to a structure, it deletes the cached training data in the structure and the model patterns

• Question 43:

  You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com.

  In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?

  A. You should back up the master database.
  B. You should back up the local database.
  C. You should back up the system database.
  D. You should back up the systemdb databse.
  A. You should back up the master database.

  ---

  Tricky question... Obvious answer is msdb* , but if you read more carefully they are asking for SQL Server recovery plan, not for SSIS packages...

  Master: The master database contains system information and high-level information about all databases on an SQL Server. If the master database becomes damaged, SQL Server may fail to start and user databases may become

  unavailable. There are many operations which change the content of the master database like creating and altering databases, adding and modifying logins, creating linked servers etc. But since one cannot keep backing up master after every

  such operation, schedule the master database to be backed up on a regular basis (for example: once every night, or once every week depending on the frequency of such changes to the database). This will backup the changes made to the

  user databases and SQL Server, which can then be recovered in case of a master database corruption.

  Note: Only full database backups of master can be performed. Transactional log, differential or filegroup backups of master are not allowed. Thus if you create a Database Maintenance Plan for all the system databases or if you select the

  master database and you select the Back up the transaction log as part of the maintenance plan option, the backup transaction log step for the master database will fail with this error message: Msdb: The msdb database is used by SQL

  Server, SQL Server Enterprise Manager, and SQL Server Agent to store data, including scheduled job information, backup and restore history information, DTS packages.

  Note: You will notice that, by default, the trunc. log on chkpt database option is set to true, for the msdb database. This helps ensure that the transaction log of the database does not fill up, and prevents problems that may occur due to

  inadequate disk space. Because the msdb database generally remains rather small, full database backups provide a fast alternative to transaction log backups for this database.

  *EXAM TIP

  When you deploy a package to SQL Server, the package is stored in the msdb database in a table named dbo.sysssispackages. Therefore, if you want to back up packages that have been deployed to SQL Server, you can back up the msdb

  database.

  The master database is the most important database of all and the most recent version of the backup should be available in the case of disaster.

  Backup of the master database should be made for:

  -

  Changing server-level configuration settings;

  -

  Changing database-level configuration settings; and

  -

  Changing any logon accounts details.

  The master database records all the system-level information for a SQL Server system. This includes instancewide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. Also, master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable. In SQL Server, system objects are no longer stored in the master database; instead, they are stored in the Resource database. The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as Service Broker and Database Mail.

• Question 44:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution has the following components:

  

  A dimension named DimTime that contains an attribute named Month

  

  A measure group named FactSales that references the DimTime dimension

  You need to ensure that the aggregations designed on FactSales always include the Month attribute.

  What should you do?

  A. Set the Usage property appropriately.
  B. Set the IsAggregatable property appropriately.
  C. Set the AggregationUsage property appropriately.
  D. Set the AttributeHierarchyEnabled property appropriately.
  C. Set the AggregationUsage property appropriately.

• Question 45:

  You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

  Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) report for the company. A parameter named Kind is contained in your developed report and you use

  it to filter a list of Sales.

  Besides, the list uses a dataset, which includes the queries of SELECT p.SalesID, p.Place,

  A. ListName, FROM SalesAmount.Sales AS p WHERE p.Kind = @Kind. To meet the business requirements, the report parameter is modified to allow multiple values. Now you are asked to modify the report to help search for multiple Kind values and minimize the development effort. What action should be performed to achieve the goal above?
  B. The query should be modified by using the IN operator instead of the = operator
  C. The query should be implemented in a stored procedure that uses dynamic SQL for execution
  D. The query should be modified in a table-valued user-defined function.
  E. The query should be implemented in a view
  F. The query should be implemented in a table-valued user-defined function.
  A. ListName, FROM SalesAmount.Sales AS p WHERE p.Kind = @Kind. To meet the business requirements, the report parameter is modified to allow multiple values. Now you are asked to modify the report to help search for multiple Kind values and minimize the development effort. What action should be performed to achieve the goal above?

• Question 46:

  You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses a third-party event based scheduler.

  You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network.

  You need to deploy this package to the ProdSSISpackages file system on the production server. You need to rename the package to Memberinformation_Prod.dtsx, and the event based scheduler will execute the renamed package.

  Which command syntax should you use?

  A. dtutil /FILE c:\ SSISpackagesXMemberInformation.dtsx /DestServer DBPROD /COPY SQL; MemberInformation_Prod.dtsx
  B. dtutil /SQL Member-Information /COPY DTS;c: \SSISpacckages\MemberInformation_Prod
  C. dtutil /FILE c:\SSISpackages\MemberInformation.dtsx /COPY SQL; MemberInformation_Prod.dtsx
  D. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE; W:\ProdSSISpackagea \MemberInformation Prod.dtax
  D. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE; W:\ProdSSISpackagea \MemberInformation Prod.dtax

• Question 47:

  You maintain a SQL Server 2008 Analysis Services (SSAS) instance.

  You plan to process the aggregations of a cube by using an XML for Analysts (XMLA) script.

  You need to ensure that only the aggregations are updated.

  What should you do?

  A. Execute a processStructure command.
  B. Execute a processUpdate command.
  C. Execute a processIndex command.
  D. Execute a processData command.
  A. Execute a processStructure command.

  ---

  B: processUpdate only supported for dimensions

  C: processIndex updates indexes and aggregations

  D: processData processes data only without updating aggregations or indexes

• Question 48:

  You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com. Some object show below in the cube

  *

  A time dimension named TimeDimension that has an attribute named TimeKiller.

  *

  A fact table named FactOrdersTable.

  Different hierarchies should be included in the Time dimension, You should take method to do it Which is the correct answer?

  A. You should design three dimension usage relationships between the Time dimension and the FactOrdersTable fact table.
  B. By defining a one-to-one relationship, you should design a single dimension usage relationship between the Time dimension and the FactOrdersTable fact table.
  C. By defining a regular relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table
  D. By defining a many-to-many relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table
  C. By defining a regular relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table

• Question 49:

  You are operating a SQL Server 2008 Integration Services (SSIS) instance through Business Intelligence Development Studio.

  Utilizing for Company.com, there is a common data flow component in the package which implements normally. You try to increase one sample of the common information flow component to the package. But the component could not show in

  thetoolbox .

  You should make sure that you should increase the common data flow component to the toolbox.

  Which is the correct answer?

  A. You should duplicate the assembly to the proper folder.
  B. You should increase the assembly to the default Assembly Cache.
  C. You should recompile the assembly through utilizing the SYSTEM32 utility.
  D. You should recompile the assembly through utilizing the Assembly Registration Tool
  A. You should duplicate the assembly to the proper folder.

• Question 50:

  You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.

  The dimension contains the Category and Subcategory attributes.

  The attributes have a Rigid relationship type.

  The data source for the Product dimension changes the relationship between the Category and Subcategory values.

  You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully reflect the change.

  What should you do?

  A. Use the ProcessAdd command.
  B. Use the ProcessUpdate command.
  C. Use the ProcessIndexes command.
  D. Use the ProcessClear and the ProcessDefault commands.
  D. Use the ProcessClear and the ProcessDefault commands.