CPD Flashcards
Which type of table stores ID and Description information for attributes and enables you to easily browse attribute data?
A) lookup table
B) relationship table
C) fact table
Fact table
What report manipulation involves moving attributes or metrics from rows to columns or columns to rows?
a) quick sorting
B) exporting
C) page-by
D) data pivoting
Data pivoting
Which of the followings objects can you NOT place directly on a template?
A) Attributes
B) Metrics
C) Facts
D) Object prompts
Facts
Which of the following items is an example of an attribute?
A) Unit Sales
B) Month
C) Revenue
D) February
B) Month
Which of the following components represents the unique values of an attribute but is NOT explicitly included in a logical data model?
A) Attribute elements
B) Attributes
C) Hierarchies
D) Attributes Relationships
Attribute elements
What reports manipulation involves moving attributes or metrics from rows to columns or columns to rows?
A) Quick sorting
B) Exporting
C) Page-by
D) Data pivoting
Data pivoting
Which of the following statements about project creation in microstrategy architect is true?
A) you must re-create the metadata shell before you can create a new project in existence metadata
B) before you can create facts or attributes you have to add the tables you want to use the project
C) you create user hierarchies on the project tables tables view tab in the architect graphical interface
before you can create facts or attributes you have to add the tables you want to use the project
Which of the following statements describes attributes relationships?
A) they describe logical associations between attributes in the logical data model
B) they represent measures that you use to analyze your business
C) they represent groupings of directly related attributes
They describe a logical association between attributes in the logical data model
Which of the following types of subscriptions can you create in Desktop?
A) history list, cache, printer, and refresh cube
B) e-mail, file,and printer
C) history list, mobile, Update Cache
D) history list, file, printer, refresh Cube, Mobile, and Cache
History List, Mobile and Update Cache
The data warehouse for a retail company stores information about items, customers, and customers orders. how would you define the relationship between the item attribute and the order attribute?
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many
Many-to-many
Which of the following types of prompts enables you to qualify on a metric?
A) object prompt
B) set qualification prompt
C) filter definition prompt
D) hierarchy prompt
Filter definition prompt
Which of the following is a physical representation of the structure of the data warehouse?
A) logical data model
B) relationship
C) physical schema
D) hierarchy
Physical schema
Data for the unit price fact is stored in four different tables and three of these tables the column is called unit_price. In the fourth table, the column is called unit_cost. which of the following concepts does this scenario illustrates?
A) fact levels
B) heterogeneous facts
C) fact column aliases
D) homogeneous facts
Heterogeneous facts
In the microstrategy desktop, which of the following objects represent a connection to the metadata?
A) database instance
B) database login
C) project source
D) project
Project source
Which of the following statements about the architect graphical interface is true?
A) when you open the architect graphical interface, it loads metrics you need to modify.
B) The architect graphical interface leads you through the process of creating application objects
C) you can create a project object in the architect graphical interface
D) The architect graphical interface is the primary tool for performing project design tasks
The architect graphical interface is the primary tool for performing project design tasks
Which type of metric do you define using only facts and aggregation functions?
A) simple
B) derived
C) compound
D) Smart
Simple
The LU_year table stores the IDs and descriptions of the year attribute. The LU_category table stores IDs and descriptions of the category attribute. The year_cat_SLS fact table stores year IDs, category IDs, and revenue fact data. Considering these three tables only, what type of relationship exists between the year in the category attributes?
A) none
B) direct
C) indirect
Indirect
Which of the following statements about logical tables is true?
A) logical tables store warehouse data in the microstrategy project
B) The microstrategy Engine uses logical tables to generate report SQL.
C) in the architect graphical interface when you add a table to the project, Micro strategy automatically creates compounds metrics.
D) logical tables are created only for the corresponding lookup tables in the data warehouse, not for the fact tables.
The microstrategy Engine uses logical tables to generate report SQL.
In microstrategy desktop, in which of the following views is quick sorting available?
A) grid
B) graph
C) SQL
D) design
Grid
Which of the following statements about user hierarchies is true?
A) you can configure user hierarchies as drill paths for reports
B) you can include prompts to attributes in user hierarchies to limit the data that displays to users.
C) user hierarchies are configuration objects
you can configure user hierarchies as drill paths for reports
Which of the following statements about micro strategy OLAP services is true?
A) it enables you to run reports against the cubes of the other business intelligence vendors.
B) it enables you to include attributes and metrics in the report definition without displaying them in the report view.
C) it enables you to create Metrics inside the report that you can then use in other reports
D) it is a required product for desktop developers to build reports
it enables you to include attributes and metrics in the report definition without displaying them in the report view.
Which of the following statements about prompted report is true?
A) you either place prompt in the filter or in the template, but you cannot create a report with prompts in both places
B) you may save prompt answers to reuse them later
C) after you answer the prompts, the report is automatically saved as a static report
D) object prompts must go in the report template
you may save prompt answers to reuse them later
The vehicle attribute has an ID form that maps to both model_ID and make_ID columns in the LU_vehicle table. What type of attribute is it?
A) compound
B) homogeneous
C) heterogeneous
Compound
Which of the following statements about the MicroStrategy architect mode is true?
A) multiple users can view schema Objects simultaneously by opening the projects in the read-only mode.
B) The read-only mode allows users to view and update schema objects.
C) The edit mode is available to all users for a project at any given time
multiple users can view schema Objects simultaneously by opening the projects in the read-only mode.
Which of the following statements about using the outline mode to display reports is true?
A) it requires Micro strategy OLAP services
B) it executes new SQL against the data warehouse when you expand or collapse levels
C) it enables indented, hierarchical display of report results
D) it only works in microstrategy web
it enables indented, hierarchical display of report results
Which of the following statements about search objects is true?
A) you can use them to define prompts
B) you can place them directly on a template
C) you can use them to define facts
D) you can place them directly in a filter
you can use them to define prompts
Which of the following statements about project shortcuts is true?
A) you can modify the target of a shortcut
B) you can only create shortcuts to reports and metrics
C) you have to create the shortcut in the same folder in which the original object resides
you can modify the target of a shortcut
The customer age attribute has an ID form the calculates the difference between the customers birth date and the Current date. What should you do to assure that the MicroStrategy Engine uses the correct data type for the ID form when generating SQL for the temporary tables?
A) Modify the column alias for the ID form
B) ensure that the attribute is heterogeneous
C) create a Derived attribute form expression for the ID form
D) modify the lockup table for the attribute
Modify the column alias for the ID form
Which of the following features can use to display a subset of a report result set?
A) Banding
B) thresholds
C) page-by
D) Pivoting to columns
Page-By
Which of the following statements about fact is false?
A) facts can only map to a single fact expression
B) aggregating facts produces meaningful results
C) facts can map to a fact expression of combines multiple columns from a table
facts can only map to a single fact expression
With Microstrategy OLAP services, which of the following scenarios requires new SQL generated for a report?
A) you add a metric from the report object window to the template
B) you create a View filter on an attribute in the report objects window
C) you create a metric using two metrics that are in the report objects window
D) you remove an attribute from the report objects window
you remove an attribute from the report objects window
In micro strategy desktop which of the following folders do report developers use to make reports available to end-users?
A) my personal objects
B) schema objects
C) public objects
D) shared objects
Public objects
Which type of prompt enables users to answer prompts by entering a date, number, text string or Big decimal?
A) filter definition prompt
B) value prompt
C) object prompt
D) hierarchical prompt
Value Prompt
After which of the following actions should you update the project schema?
A) when you use a fact to create a new Metric
B) when you create an attribute qualification filter
C) when you remove a table from the project
D) when you move an attribute from one folder to another
when you remove a table from the project
Which of the following object is an example of an application object?
A) filter
B) attribute
C) hierarchy
D) user
Filter
The products user how your team consists of category subcategory and item. The lu_category table contains category IDs and descriptions. The lu_subcategory table contains the category and subcategory IDs and subcategory descriptions. The Lu_item table contains the categories, subcategory,bitem IDs and item descriptions. What type of schema do these tables represent?
A) completely normalized schema
B) moderately denormalized schema
C) completely denormalized schema
Moderately denormalized schema
Which of the following statements about View filters is true?
A) you can add view filters to reports in the design View
B) you can only create view filters based on objects in the report objects window
C) View filter conditions are part of the SQL for a report
You can only create view filters based on objects in the report objects window
Which of the following statements about the automatic schema recognition in the architect graphical interface is true?
A) automatic schema recognition can automatically create user hierarchies
B) automatic schema recognition can automatically creates compound metrics, prompts, and filters
C) automatic schema recognition can automatically creates attributes, attribute forms, attribute relationships, and facts.
D) automatic schema recognition can automatically create simple and compound metrics
automatic schema recognition can automatically creates attributes, attribute forms, attribute relationships, and facts.
In desktop, which of the following features enables you to change the format of metric values based on conditions that you define?
A) thresholds
B) Custom autostyles
C) Number formatting
D) custom banding
Thresholds
Which of the following statements about system hierarchies is true?
A). You can delete the system hierarchy
B) The system hierarchy only contains the highest level attributes in a project
C) The system hierarchy is generally more efficiency and convenient for browsing attributes than user hierarchies
D) The system hierarchy is created when you defined attributes and their relationships, and it is updated as you add, delete, and modify project attributes
The system hierarchy is created when you defined attributes and their relationships, and it is updated as you add, delete, and modify project attributes
In a report Filter, on which of the following objects can you qualify?
A) attribute Element
B) fact
C) template
D) search
Attributes element
You create salary as an attribute form of the employee attribute. Which of the following functions is not available to you using this form?
A) you can sort the employees on the report based on their salaries
B) you can aggregate or Group revenue data on a report by salary
C) you can filter a report based on employee salaries
D) you can display employees salaries on a report
you can aggregate or Group revenue data on a report by salary
A report filter contains two conditions column: year 2010 and West region. Which of the following set operators would you use if you want The results set to display all of the data for 2010 regardless of the region and all of the data for the West region regardless of year?
A) and
B) or
C) and not
D) or not
Or
If you create and user hierarchy that has a limit defined on one of its attributes, What happens when users browse that attribute?
A) they cannot view the elements for the attribute
B) they cannot browse from that attribute to another attribute in the hierarchy
C) they can only view a specified number of elements at a time for the attributes
D) they can only browse from that attribute to The immediate Child attribute
they can only view a specified number of elements at a time for the attributes
Which of the following metric definitions is an example of a compound metric?
A) [metric] * 15
B) avg(fact)
C) sum(fact1) - Sum(fact2)
D) avg(sum(fact))
[metric] * 15
You have a report with the percentage metric that has the following three values: 25%, 50%, and 75%. You also have a total subtotal on this metric that displays a value of 150%. In Micro strategy desktop, what can you do to calculate the total subtotal so that it displays a value of 50%, which is an average of the three values rather than a straight sum?
A) disable the total subtotal
B) change the format of metric
C) enable Smart metrics
D) define a threshold
Enable smart metrics
Which of the following statements about schema design is true?
A) all the tables in your data warehouse schema must be of the same schema type
B) higher-level look up tables are generally desirable in the completely denormalized schemas to support specific types of analysis, such as aggregate queries
C) Denormalization decreases the size of the warehouse tables
higher-level look up tables are generally desirable in the completely denormalized schemas to support specific types of analysis, such as aggregate queries
After you run a report, what report manipulation enables you to view data at levels other than the original level of the report?
A) drilling
B) advanced sorting
C) data pivoting
D) custom banding
Drilling
The time user hierarchy consists of the year, quarter, month, and day attributes. The year attribute is the only entry point for the hierarchy and all attributes are unlocked. Which of the following actions must be performed to ensure that the time user is available for browsing?
A) define the custom sort order for the Time hierarchy
B) define a filter on all attributes and in the hierarchy
C) define a filter only on the attributes designated as entry points
D) move the time hierarchy to the schema objects\hierarchies\data explorer folder
move the time hierarchy to the schema objects\hierarchies\data explorer folder
Which of the following statements about reports is true?
A) reports can have an empty filter
B) reports must have at least one attribute and one metric
C) reports must have a view filter
D) you cannot change the information displayed in the report details section
reports can have an empty filter
