Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

MicroStrategy CPA Exam Practice Questions, Exams of Business Fundamentals

London Institute of Business and Technology (LIBT)Business Fundamentals

This is a collection of questions and answers about the MicroStrategy platform, a business intelligence tool. It explores intelligence server configuration, user management, data mining, load balancing, change journaling, authentication, and clustering. Questions cover functionalities in two-tier and three-tier environments, including ODBC connections, user connection mapping, and Command Manager automation. The document also examines Integrity Manager tests, cache management, data import, and internationalization. Furthermore, it delves into Distribution Services, Health Center, Object Manager, and System Manager, offering insights into their functions and best practices. This content aims to test and improve understanding of MicroStrategy's capabilities and administrative tasks, serving as a valuable resource for business intelligence and data analytics professionals and students.

Typology: Exams

2024/2025

Available from 05/22/2025

locaz-turus-1
locaz-turus-1 🇺🇸

5

(1)

13K documents

1 / 8

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CPA Test Questions
Which of the following is an advantage of running Intelligence Server as an application in the
Windows Environment? correct answer You can change certain advance tuning settings that are
not available when Intelligence Server is running as a service
Which of the following monitors can you use to view a list of executing, queued, or cancelled
job requests in a projects? correct answer Jobs monitor
MicroStrategy users are an example of which of the following types of objects? correct answer
Configuration Objects
You have been tasked to create a new user group in your MicroStrategy environment. You also
need to create 20 users with similar profile to add to this group, and assign each user to a
different security filter.
Which of the following MicroStrategy administrative tools can you use to automate this task?
correct answer MicroStrategy Command Manager
Which of the following MicroStrategy functionalities are available in *both* a two-tier and
three-tier environments? correct answer *Data Mining*, In-Memory Analytics, *Freeform
SQL*, Query Builder, XDA support..
Which of the following statements about load balancing in MicroStrategy Web is true? correct
answer Load balancing ensures that a new user is connected to the intelligence server with the
least number of open sessions.
Which of the following Change Journal Filtering Options do you enable if you *only* want to
see the objects version IDs that were modified? correct answer Show version changes only
Which of the following actions can you perform in the Change Journal Manager? correct answer
Enable change journaling; purge the change journal log
pf3
pf4
pf5
pf8

Partial preview of the text

Download MicroStrategy CPA Exam Practice Questions and more Exams Business Fundamentals in PDF only on Docsity!

CPA Test Questions Which of the following is an advantage of running Intelligence Server as an application in the Windows Environment? correct answer You can change certain advance tuning settings that are not available when Intelligence Server is running as a service Which of the following monitors can you use to view a list of executing, queued, or cancelled job requests in a projects? correct answer Jobs monitor MicroStrategy users are an example of which of the following types of objects? correct answer Configuration Objects You have been tasked to create a new user group in your MicroStrategy environment. You also need to create 20 users with similar profile to add to this group, and assign each user to a different security filter. Which of the following MicroStrategy administrative tools can you use to automate this task? correct answer MicroStrategy Command Manager Which of the following MicroStrategy functionalities are available in both a two-tier and three-tier environments? correct answer Data Mining, In-Memory Analytics, Freeform SQL, Query Builder, XDA support.. Which of the following statements about load balancing in MicroStrategy Web is true? correct answer Load balancing ensures that a new user is connected to the intelligence server with the least number of open sessions. Which of the following Change Journal Filtering Options do you enable if you only want to see the objects version IDs that were modified? correct answer Show version changes only Which of the following actions can you perform in the Change Journal Manager? correct answer Enable change journaling; purge the change journal log

Which of the following statements about authentication modes is true? correct answer In MicroStrategy Web, you can specify different authentication modes for different projects. Which of the following Intelligence Server components is invoked during object browsing? correct answer Metadata Server Which of the following statements about MicroStrategy Clustering is false? correct answer There is a technical hard limit on the maximum nodes and only 4 nodes can be connected into a cluster Which of the following statements about ODBC are true? correct answer You can create ODBC connections using MicroStrategy Connectivity Wizard The ODBC protocol enables applications such as MicroStrategy to communicate with databases Which of the following statements about user connection mapping are true? correct answer Using connection mapping, you can assign different database instances to different users in the same project In a four-tier MicrosStrategy business intelligence environment, MicroStrategy Web communicates with the Intelligence Server using which of the following protocols? correct answer TCP/IP Which of the following Command Manager script allows you to assign a security filter to a user? correct answer CREATE SECURITY FILTER "SECFILTER1" IN PROJECT... APPLY SECURITY FILTER "SECFILTER1" FOLDER "\PROJECT.." TO USER "DEVELOPER" FOR PROJECT "MiscroStrategy Tutorial"

An Intelligent Cube is Filed but not Active. Which of the following actions will load the cube as an accessible set of data for multiple reports? correct answer Activate Which of the following describes the behavior of the Update option in Data Refresh of Intelligent Cubes? correct answer If new data is returned, it is added to the Intelligent Cube, and if the data returned is already in the Intelligent Cube, it is updated where applicable What type of Internationalization is depicted by the following? select CATEGORY_ID, CATEGORY_NAME_PL from LU_CATEGORY where LOCALE_ID = 1029 AND where CATEGORY_ID in (5,10,15); correct answer Row-level data internationalization Which types of internationalization is available in the MicroStrategy platform? correct answer • Interface language

  • Metadata (or object) language
  • Data language
  • Number and date formatting locale
  • Intelligence Server language Several of your company's employees have reported that their documents have been running slowly. In Enterprise Manager, which area of analysis would enable you to track this information and provide possible solutions? correct answer Operations Analysis

Which of the following statements about Distribution Services is true? correct answer A security filter defined on a MicroStrategy group is also propagated for a contact who is linked to a member user of that group Which of the following Distribution Services subscriptions is true? correct answer You can have unlimited Distribution Services subscriptions Which of the following statements about Distribution Services is true? correct answer A contact can receive a zipped file instead of the regular PDF file An administrator creates User X as a member of the predefined MicroStrategy Web Professional group. User X will have the privileges of which of the following groups? correct answer MicroStrategy Web Professional, MicroStrategy Web Analyst, and MicroStrategy Web reporter only Which of the following about Health Center is true? correct answer The administrator can receive email alerts from Health Center with information about problems which have occurred You want to use Object Manager to copy Filter A1 from Project Alpha to Project Beta. Filter A1 is composed of Report A, which does not exist in Project Beta. Can you still copy Filter A1 to Project Beta? correct answer Yes, because Object Manager will automatically copy Report A as well Which of the following about Health Center is true? correct answer The administrator is able to define what information is to be sent to Technical Support within the Diagnostic Package In Object Manager, when you try to copy an object from Project A to Project B, the conflict resolution windows displays the status Exists Differently.

If you click Read-Only, which of the following actions can you perform assuming you have the permissions? correct answer You can execute a report Which of the following subscriptions are available in MicroStrategy Desktop? correct answer History List, Cube Refresh, Mobile, Cache Update Which of the following statements about Subscription Administration is true? correct answer A Desktop user can unsubscribe himself from the subscription, but he cannot change the personalization for the report's subscription Which of the following about passthrough execution is true? correct answer You can enable passthrough execution for selected database instances Which of the following represents a difference in Project Merge if compared to Object Manager? correct answer You do not have to manually select the objects to migrate Which of the following strategies should an administrator take to efficiently manage available resources on Intelligent Server? correct answer Disconnect idle Web and Desktop users, and define appropriate privileges for certain users You are granted the Execute permission but do not have access to Use the permission for attribute A. Which of the following actions can you perform with respect to attribute A? correct answer You cannot use attribute A to create new reports, but you can execute reports containing attribute A Which of the following MicroStrategy System Manager workflow components is most useful for checking of a file or folder exists? correct answer Decision

MicroStrategy System Manager would be most useful for solving which of the following scenarios? correct answer Administrators need to reduce the amount of careful supervision and time it takes to add virtual machines to an Intelligent Server cluster Which of the following security features can you use to assign groups of users different sets of privileges for different Projects? correct answer Security Roles