Microsoft SQL Server 2008 Business Intelligence Development and Maintenance 70-448

The flashcards below were created by user Anonymous on FreezingBlue Flashcards.

  1. What does SSRS stand for?
    Sequel Server Reporting Services
  2. You are designing a SQL Server Integration Services (SSIS) package task to call a child package named Child.dtsx. In Master.dtsx, you have created a FilePath variable. You would like child.dtsx to use the value of the FilePath variable that is stored in Master.dtsx.

    How would you accomplish this? (Each correct answer presents part of the solution.  Choose two.)

    1. In Parent.dtsx, create a Parent Package Variable configuration. Set the Parent variable for the configuration to FilePath. In Master.dtsx, edit the Set Values property of the Execute Package task to \package.varible [FilePath] 

    2. In Child.dtsx, create a variable named FilePath. Set the scope of the variable to Master

    3. In Child.dtsx, create a variable named FilePath. Set the scope of the variable to Child.

    4. In Child.dtsx, create a Parent Package Variable configuration. Set the Parent varible for the configuration to FilePath
    Answer both 3. and 4.

    The Parent Package Variable configuration pulls the value of a variable from a parent package. Set the scope of the variableto Child because your are working within the Child package. The scope of the variable in the child package cannot be set to Master because Master is not part of the Child.dtsx package.
  3. You are managing several SQL Server Integration Services (SSIS) packages.

    Using a command-line utility, you want to encrypt the entire MyPackage.dtsx package with the password abc123.

    What would the command-line syntax be to encrypt MyPackage.dtsx with a package password?

    1. DTexec /file MyPackage.dtsx /encrypt file;MyPackage.dtsx;3; abc12

    2. DTutil /file MyPackage.dtsx /encrypt file;MyPackage.dtsx; abc123

    3. DT exec /encrypt package; MyPackage.dtsx;EncryptSensitiveWithPassword; abc123

    4. DTutil /file MyPackage.dtsx /encrypt package;MyPackage.dtsx;3; abc123
    Answer: 2

    • Explanation:
    • The DTUtil command-line utility generally allows you to copy, move, and delete packages, but you can encrypt and decrypt packages as well.

    The syntax for the DTUtil utility to encrypt a package is as follows:

    DTutil /file {package Name} /encrypt file; {package Name};{EncryptionLevel}; {Password}

    • The encryption level is a numeric indicator related to the EncryptionLevel property:
    • 0 = Don'tSaveSensitive
    • 1 = EncryptSensitiveWithUserKey
    • 2 = EncryptSensitiveWithPassword
    • 3 = EncryptAllWithPassword
    • 4 = EncryptAllWithUserKey
    • 5 = SQLServerStorage

    The DTexec utility can execute an encrypted package but does not have the functionality to encrypt a package.
  4. You have a measure group that contains several partitions. One of the partitions stores historical data for several years and is rarly queried. You need to select storage mode that saves storage space on the SSAS server, but you still want to take advantage of aggregations.

    How should you configure these partitions?

    1. Set the partition's StorageMode property to HOLAP and define aggregation on the partition.

    2. Use the Automatic MOLAP Proactive Caching setting.

    3. Set the partition's StorageMode property to ROLAP, set the Slice property to the date dimension member that defines the underlying historical data, and define aggregations on the partition.

    4. Set the partition's StorageMode property to MOLAP.
    Answer: 1 only


    With HOLAP, SSAS stores aggregations in SSAS, but the underlying data remains in the relational database.

    ROLAP, which contains no aggregations, consumes the least storage space because the all the data is left in the relational database.

    With ROLAP, aggregations are not stored in SSAS.

    When you define a partition with a MOLAP storage mode, both the data and the aggregations are stored in SSAS.
  5. You are managing a SQL Server Analysis Services (SSAS) cube. You want to back up an SSAS database in SQL Server Management Studio (SSMS) and the C:\temp folder to appear in the list of backup locations in SSMS when you perform a backup of a database.

    What must you do for the C:\Temp folder to appear in the backup folder list?

    1. You cannot save backup files to any location other than the default backup folder.

    2. Add the C:\Temp folder to the BackupDir server property.

    3. Add the C:\Temp folder to the DataDir server property.

    4. Add the C:\Temp folder to the AllowedBrowsingFolders server Property.
    Anser: 4 only

    • Explanation:
    • The allowed backup folders are listed in the AllowedBrowsingFolders server property.
    • The default backup folder backup folder is the location of the installation folder in Program Files asspecified by the BackupDir server property. If you want to save the backup file to a different folder, add that folder to the AllowedBrowsingFolders property.  The DataDir property defines the default location for the MOLAP and HOLAP data for the cubes and dimensions within an SSAS installation.
  6. You are developing a new report and need to call a method through custom code.

    Choose the correct syntax for calling custom code methods.
    (Each correct answer presents a complete solution Choos Two.)

    1. Static Method Call - <Namespace>.<Cla ssName>.<Method>()

    2. Instance Method Call - Code.<Instance>. Method>()

    3. Static Method Call - Code.<Instance>.<Method>()

    4. Instance Method Call - <Namespace>.<ClassName>.<Method>()
    Answer: Both 1 and 2


    Reporting Services can call static and instance methods in externally referenced code.

    Static methods can be called directly from the class in the form <Namespace>.<ClassName>.<Method>().

    Instance methods require an instance name to be defined in the References tab of the Report Properties dialog box. The format of an instance method is Code.<Instance>.<Method>().

    Static methods cannot be called using an instance name.

    Instance methods cannot be called directly from the class.
  7. You have a sales summary report that needs to be emailed out regularly to the business development team for each member of the team.  Therefore you want to set up the data-driven subscription to make that an automated process.

    Which of the following conditions have to be met to create the data-driven subscription for the sales summary report?

    (Each correct answer presents part of the solution.Choose three.)

    1. You have to collect data for subscription properties with a single query.

    2. An antivirus program must be running.

    3. You must use the My Reports folder.

    4. You have to store the credentials for accessing source data on the report server.

    5. SQL Server Agent must be running.
    Answer:  1, 4 and 5


    • The report must use stored credentials or no credentials to retrieve data at run time. You cannot subscribe to a report that is configured to use the impersonated  credentials of the current user to connect to an external data source.
    • The SQL Server Agent must be running because the query to retrieve the subscribers must be validated.  If the query cannot be validated, the subscription task cannot be completed. A data-driven subscription must specify a query or command that retrieves subscriber data. The query should produce one row for each subscriber.

    Although running an antivirus program is always a good practice, it is not necessary for data-driven subscriptions

    Usage of the My Report folder is not necessary for data-driven subscriptions.
  8. You are designing a SQL Server Integration Services (SSIS) package and have five tasks contained in a seq transactions so that if any of the tasks fail, the transaction will roll back. You want to add an Execute the logging data to roll back.

    How must you configure each of the SQL Server logging tasks?

    1. Set TransactionOption in each Execute SQL task to Required.

    2. Set TransactionOption in each Execute SQL task to NotSupported.

    3. Set TransactionOption in each Execute SQL task to False.

    4. Add a sequence container for each Execute SQL task and place each Execute SQL task in a sequence container.  Set TransactionOption to Supported.
    Answer: 2 only


    You can force a task not to participate in a transaction by setting its TransactionOption setting to NotSupported.

    The Required option would set the transaction to roll back on failure.

    If you choose the Supported option, each task joins the transaction and inherits the properties of the parent

    • False is not an option under TransactionOption.
Card Set:
Microsoft SQL Server 2008 Business Intelligence Development and Maintenance 70-448
2013-07-02 21:35:26
70 448 sql Microsoft certification

Set of card to help learn and prepare for certification for mcts exam 70-448
Show Answers: