Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MSTR > CPD > Flashcards

CPD Flashcards

0
Q

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

A

Fact table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

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

A

Data pivoting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the followings objects can you NOT place directly on a template?

A) Attributes
B) Metrics
C) Facts
D) Object prompts

A

Facts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following items is an example of an attribute?

A) Unit Sales
B) Month
C) Revenue
D) February

A

B) Month

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Attribute elements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Data pivoting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

before you can create facts or attributes you have to add the tables you want to use the project

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

They describe a logical association between attributes in the logical data model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

History List, Mobile and Update Cache

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Many-to-many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Filter definition prompt

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Physical schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Heterogeneous facts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Project source

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

The architect graphical interface is the primary tool for performing project design tasks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which type of metric do you define using only facts and aggregation functions?

A) simple
B) derived
C) compound
D) Smart

A

Simple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Indirect

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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.

A

The microstrategy Engine uses logical tables to generate report SQL.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

In microstrategy desktop, in which of the following views is quick sorting available?

A) grid
B) graph
C) SQL
D) design

A

Grid

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

you can configure user hierarchies as drill paths for reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

it enables you to include attributes and metrics in the report definition without displaying them in the report view.

21
Q

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

A

you may save prompt answers to reuse them later

22
Q

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

A

Compound

23
Q

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

A

multiple users can view schema Objects simultaneously by opening the projects in the read-only mode.

24
Q

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

A

it enables indented, hierarchical display of report results

25
Q

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

A

you can use them to define prompts

26
Q

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

A

you can modify the target of a shortcut

27
Q

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

A

Modify the column alias for the ID form

28
Q

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

A

Page-By

29
Q

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

A

facts can only map to a single fact expression

30
Q

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

A

you remove an attribute from the report objects window

31
Q

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

A

Public objects

32
Q

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

A

Value Prompt

33
Q

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

A

when you remove a table from the project

34
Q

Which of the following object is an example of an application object?

A) filter
B) attribute
C) hierarchy
D) user

A

Filter

35
Q

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

A

Moderately denormalized schema

36
Q

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

A

You can only create view filters based on objects in the report objects window

37
Q

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

A

automatic schema recognition can automatically creates attributes, attribute forms, attribute relationships, and facts.

38
Q

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

A

Thresholds

39
Q

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

A

The system hierarchy is created when you defined attributes and their relationships, and it is updated as you add, delete, and modify project attributes

40
Q

In a report Filter, on which of the following objects can you qualify?

A) attribute Element
B) fact
C) template
D) search

A

Attributes element

41
Q

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

A

you can aggregate or Group revenue data on a report by salary

42
Q

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

A

Or

43
Q

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

A

they can only view a specified number of elements at a time for the attributes

44
Q

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

A

[metric] * 15

45
Q

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

A

Enable smart metrics

46
Q

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

A

higher-level look up tables are generally desirable in the completely denormalized schemas to support specific types of analysis, such as aggregate queries

47
Q

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

A

Drilling

48
Q

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

A

move the time hierarchy to the schema objects\hierarchies\data explorer folder

49
Q

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

A

reports can have an empty filter

MSTR (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions