Tag Archives: Question

Interview Question #12: Command Manager v9.3.1 and Intelligent Cubes

Question

In Command Manager 9.3.1, you can use scripts to manage Intelligent Cube Caches.

True

False

 

 

 

 

 

Answer

True

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Administration Course

Interview Question #11: History List Messages Stored in a Database

Question

Which of the following is possible only when History List messages are stored in a database?

A. History List Messages are available in a two-tier environment.

B. When deleting History List messages using a schedule, a single session is created on the Intelligence Server.

C. History List messages can be shared across cluster nodes.

D. You can duplicate History List messages on reprompt or refresh.

E. Both B and C.

 

 

 

 

 

Answer

B. When deleting History List messages using a schedule, a single session is created on the Intelligence Server.

Benefits of Using Database-Based History List Storage

  • Access additional information about each History List message, such as message and job execution statistics. As a result, you can effectively monitor and manage the History List based on its actual usage by the users.
  • The database backing of the History List provides greater scalability and improved performance. Instead of accessing a multitude of large files that usually reside on the server machine, you retrieve users’ inbox information from a database.
  • When the administrative task to delete History List messages is triggered, it creates only one session on the Intelligence Server rather than multiple separate sessions for each user.
  • Use the History List Messages monitor to monitor and manage messages for each MicroStrategy user.

 

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Administration Course

Interview Question #10: Placing Hierarchies in Report Template in MicroStrategy

Question

Which of the following about placing hierarchies in the report template is true?

A. You can only place one hierarchy in the report template.

B. The report level is always resolved to the lowest level attribute in the hierarchy.

C. You can use user hierarchies as well as the System Hierarchy on the template.

D. For the SQL Engine to resolve the level of the report, one or more attributes from the same hierarchy should be referenced in the report filter.

E. Both B and D.

 

 

 

 

 

Answer

D. For the SQL Engine to resolve the level of the report, one or more attributes from the same hierarchy should be referenced in the report filter.

 

Why the others are false

A. You can only place one hierarchy in the report template. You can place any number on the report.

B. The report level is always resolved to the lowest level attribute in the hierarchy. Since the hierarchy contains several attributes, the SQL Engine does not automatically know which attribute to place on the result set.

C. You can use user hierarchies as well as the System Hierarchy on the template. Cannot use System Hierarchy.

E. Both B and D. B is False.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Engine Essentials Course

Interview Question #9: Governing VLDB Properties

Question

Which of the following VLDB properties govern the length of a SQL string as well as the time a SQL pass takes to execute? (Select all that apply).

A.  SQL Time Out (Per Pass)

B.  Preserve All Lookup Table Elements

C.  Result Set Row Limit

D.  Maximum SQL/MDX Size

E.  Allow Index on Metric

Answer

Both

A.  SQL Time Out (Per Pass)

and

D.  Maximum SQL/MDX Size

 

Maximum SQL/MDX Size and SQL Time Out (Per Pass)

The Maximum SQL/MDX Size and SQL Time Out (Per Pass) VLDB Properties govern the length of a SQL string as well as the time a SQL pass can take to execute.

Maximum SQL/MDX Size sets the maximum size (in bytes), on a pass-by-pass basis, of the SQL that the ODBC driver sends to the warehouse. Or, in the case of MDX, it sets the maximum size of the MDX that is sent to multidimensional cube sources such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services.

If a pass exceeds the limit, the report execution terminates and an error message displays:

I9-1

The possible value for this VLDB property is any valid integer. The default value is 0 (No limit).

SQL Time Out (Per Pass) sets the maximum duration allowed (in seconds) for each SQL pass (even intermediate passes). If any pass of SQL runs longer then its allocated time, the report fails and an error message displays:

I9-2

The value you enter to define this VLDB property must be an integer.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Engine Essentials Course

Interview Question #8 : Many-to-Many Relationships in MicroStrategy

Question

Which of the following issues can result from many-to-many relationships?

A. Exclusion of some attribute elements when drilling

B. Multiple join paths to fact tables

C. Missing values on reports including all attributes from the hierarchy

D. Multiple counting when aggregating data from base fact tables

E. Lost analytical capability

Answer

Both

D. Multiple counting when aggregating data from base fact tables

      and

E. Lost analytical capability

 

Challenges of Many-to-Many Relationships

Because many-to-many relationships require distinct relationship tables, you have to design the logical data model and data warehouse schema in such a way that you can accurately analyze the relationship in regard to any relevant fact data.

If the structure of your logical data model and data warehouse schema does not adequately address the complexities of querying attribute data that contains many-to-many relationships, you can have problems like lost analytical capability and multiple counting.

I will be exploring both of these topics more next week as Tips and Tricks.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Advanced Data Warehousing Course

Interview Question #7: Object Manager

Question

As a MicroStrategy developer, you are constantly using Object Manager to migrate objects that you develop inside the Subject Areas folder in your project. To save time, what object can you create to enable you to go straight to this folder when you open Object Manager?

A. Layout

B. Project Source

C. Script

D. Template

E. You cannot accomplish this in the Object Manager.

Answer

A. Layout

Opening multiple project sources at once in Object Manager

You may need to migrate objects between the same projects on multiple occasions. For example, you may need to move objects from your development environment to your test environment on a regular basis. Object Manager allows you to save the projects and project sources that you are logged in to as a layout. Later, instead of opening each project and project source individually, you can open the layout and automatically re-open those projects and project sources.

The default file extension for Object Manager Layout files is .omw.

To open an existing Object Manager layout

  1. From the File menu, select Open Layout. The Select Layout dialog box opens.

  2. Select a layout and click Open. A Login dialog box opens for each project source specified in the layout.

  3. For each Login dialog box, type a MicroStrategy login ID and password. The login must have the Use Object Manager privilege.

  4. Click OK. The project sources open. You are automatically logged in to the projects specified in the layout, as the user you logged into the project source with.

To save a workspace as an Object Manager layout

  1. Log in to any project sources and projects that you want to save in the layout.

  2. From the File menu, select Save Layout. The Save Layout dialog box opens.

  3. Specify a location and name for the layout file and click Save. The layout is saved.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Administration: Application Management Course

Interview Question #6: Warehouse Tables Options

Question

Which of the following options in the Warehouse Tables pane would you use to view the first 100 rows of data in a table?

A. Show Table Structure

B. Show Top 100 Rows

C. Show Sample Data

D. Select Database Instance

E. You cannot accomplish this in the Warehouse Tables pane.

Answer

C. Show Sample Data

The Warehouse Tables pane, shown below on the left side, displays a list of the data sources available for the project.

Interview 6-2

Note: If the Warehouse Tables pane is not displayed, from the Home tab, in the Panels area,

click Show the Warehouse tables section:

Interview 6-1

 

You can right-click a data source and select from the tasks listed below.

  • Select Mapping Color: Defines the color associated with the data source. A table that is included in a project display this color to distinguish what data source it is from.
  • Update: Updates all the tables for the data source to reflect their definitions in the data source.
  • Warehouse Catalog Options: Opens the Warehouse Catalog options dialog box to define various settings for data warehouse connection and operation defaults using Architect, including:
    • Warehouse Connection: These options allow you to modify the database instance and database login used to connect the data warehouse to a project.
    • Read Settings: These options allow you to customize the SQL that reads the Warehouse Catalog for every platform except Microsoft Access.
    • Table Prefixes: These options allow you to specify whether table prefixes are displayed in table names and how prefixes are automatically defined for tables that are added to the project.
  • Select Database Instance: Opens the Select Database Instance dialog box to select data sources to display in Architect.

Interview 6-3

 

You can expand a data source to view the tables available in the data source (see screenshot above). You can right-click a table and select from the tasks listed below:

  • Add Table to Project: The table is included in the project schema. You can then create attributes and facts on the columns of the table. This option is not available if the table is already included in the project.
  • Show Element: Displays the table included in the project in the Project Tables View. This option is only available if the table is already included in the project.
  • Show Sample Data: Displays a subset of the data available in the table. This lets you determine the type of data that is available in the table.
  • Update Structure: Updates the table to reflect its definition in the data source.

The Warehouse Tables pane also allows you to add tables from multiple data sources to your project.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Architect: Project Design Essentials Course

Interview Question #5: Analysis Using Enterprise Manager

Question

If you want to analyze the average length of time users must wait for their documents or reports to process, as well as the number of errors that were received in Enterprise Manager, which area of analysis would enable you to track this information?

A.   Performance Analysis

B.   Operations Analysis

C.   Real-Time Analysis

D.   Project Analysis

E.   You cannot accomplish this with Enterprise Manager

Answer

B. Operations Analysis

The Operations Analysis folder in Enterprise Manager contains the following analysis areas, each with its own reports:

  • Concurrency analysis (including user/session analysis)
  • Data load
  • Delivery processing analysis
  • Inbox Message Analysis
  • Report processing analysis
  • Resource utilization analysis (including top consumers)

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Administration: Application Management Course

Interview Question #4: Slowly Changing Dimensions

Question

Which type of Slowly Changing Dimension (SCD) would you use if your data was time dependent and you do not require historical comparisons?

A.  Like vs. Like

B.  As Is vs. As Was (Type II)

C.  As Is vs. As Is (Type I)

D.  As Is vs. As Was

Answer

C.   As Is vs. As Is (Type I) involves analyzing all data in accordance with the attribute relationships as they currently exist.

Regardless of how relationships change over time, you aggregate and qualify all data (current and historical) based on the current values in the lookup and relationship tables. If aggregate tables exist, you either have to modify how the values roll up to reflect the current attribute relationships, or you have to ignore the tables when you perform this type of analysis.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Advanced Data Warehousing Course

 

Interview Question #3: Converting a Consolidation to a Custom Group

Question

Can you always convert a consolidation to a custom group and vice versa?

Answer

You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables.