1Z0-630 - Siebel 7.7 Server Architect Professional Core Exam
Go back to Oracle
Siebel Answer's subject areas correspond to which Analytics Administration Tool layer?
Which of the following object-level security action settings are done in the Siebel Analytics repository using the Administration Tool? Choose two.
Create a new repository group
Create a new user in the repository
ABC wants to track the difference between the amount billed and the amount collected from its customers for every quarter. Which of the following methods would NOT be used in this situation?
Create a new physical column using the Calculation Wizard
To set the number of elements at each level of a dimension, which number would you use?
The number of distinct rows in a physical column
Which of the following is NOT true of consistency check?
It guarantees that the business model is correctly built
When double-clicking ABC.rpd in the Analytics/Repository directory, the Analytics Server architect gets the message The repository 'ABC.rpd' can only be opened as Read-Only. Do you want to open it? What can you tell from that message? Choose two.
Siebel Analytics Server is running
ABC. rpd is a default repository specified in the NQSConfig.ini
ABC Company is using Microsoft SQL Server ABC database and no data warehouse. After establishing connection to the ABC database using ODBC, how would you verify that the connection to be used with the Siebel Analytics was established? Choose two.
By running a query against ABC tables using MS SQL Query Analyzer
By testing the connection via the Siebel Analytics ODBC Client tool
Which of the following is true of the query logging level?
You can set the logging level for individual users in Siebel Analytics Administration Tool > Manage > Security> Users
What do the logical joins do? Choose two.
They help the Analytics Server choose best physical path between multiple physical tables in each logical table
They determine cardinality between logical tables
After modifying and saving the Analytics repository file offline, which steps are necessary to reload the modified metadata? Choose two.
Restart the Siebel Analytics Server
Restart the Siebel Analytics Web service
ABC Company wants to analyze their sales figure by time period, products, product hierarchies, and sales rep. In this case, what would be the dimension?
Time period, products, product hierarchies, and sales rep
How would you make it possible to check out objects automatically in the Siebel Analytics Administration Tool?
By navigating to Tools > Options > General > Check out objects automatically
How do you invoke Time Series Wizard in the Siebel Analytics Administration Tool?
In the Business Model and Mapping layer, select a business model and right-click > Time Series Wizard
Which of the following is NOT true of Connection Pool?
Only one connection pool is allowed for each Physical layer database
Pat is a server architect who is new to an integrated Siebel Analytics. Which of the following tools would Patuse to find out which presentation columns are related to a particular logical column of the Siebel Analytics repository?
ABC is a multinational corporation. It wants to measure its revenue based on the country, region, and city by setting up columns to measure Country Revenue, Region Revenue, and City Revenue. Where would ABC's server architect set the grand total level?
None of the above; It needs to create an All-Country Grand total level and set it there
What information does the Administration Tool log when checking out a project? Choose three.
Which of the following are true of the prebuilt Siebel Analytics Repository? Choose three.
Prebuilt connection pools reduce the overhead of connecting to a database
Many prebuilt star schemas support the prebuilt Siebel Analytics applications
Measures can come from multiple stars and case statements determine correct data sources to access
Which of the following is NOT true of the Siebel Analytics repository?
Objects within a presentation catalog can derive from multiple business models
ABC wants to measure its revenue based on the country, region, and city by setting up columns to measure Country Revenue, Region Revenue, and City Revenue. Which measure type is ABC using?
Which of the following is NOT necessary when specifying the most economical source?
Create a new physical table source manually