1Z0-591 | What Precise 1Z0-591 exam Is?


Q41. The ODBC DSN is never used for _______. 

A. Initial import of the physical layer metadata on a Windows server 

B. Query execution and data access on a Windows server 

C. Initial import of the physical layer metadata, query execution, and data access on a Windows Server 

D. Changing passwords 

E. Comparing RPDs 

Answer:

Q42. A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator? 

A. Create a derived measure by using the addition function that adds each product value together. 

B. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog. 

C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product. 

D. Create a derived metric by using the Expression Builder. 

Answer: AC

Q43. Identify the two true statements about alias tables. 

A. Alias tables are set up to avoid triangular or circular joins. 

B. Alias tables are set up to include best practice naming conventions for physical table names. 

C. Alias tables are set up to create another physical copy of the data. 

D. Alias tables are set up to create a copy of the data with a filter applied to it. 

Answer: B

Q44. Which two options are valid Repository Variable names? 

A. USER 

B. CurrentDay 

C. CurrentMonth 

D. Date 

Answer: BC 

Q45. Which task can be performed after the Administrator link has been reached through logging into OBIEE? 

A. Associate map layers to columns 

B. Manage access to Subject Areas 

C. SSO enablement 

D. Start or Stop BI Managed Servers 

Answer: BCD 

Q46. A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query? 

A. By specifying a one-to-many join between the tables with the small and largenumbers of values 

B. By specifyingadriving table 

C. By specifying a many to one join between the tables with the small and large numbers of values 

D. By creating your logical join by using theJoins Manager 

E. By creating your joins by using the Business Model Diagram 

Answer:

Q47. Which are the three types of tables available to physical tables in the physical layer? 

A. Physical Table 

B. Stored Proc 

C. Select 

D. View 

E. Table 

Answer: ABC

Q48. The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS? 

A. Oracle RDBMS 

B. Microsoft SQL Server 

C. IBMDB2 

D. Teradata 

Answer: ABC 

Q49. What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office? 

A. Edit Analysis 

B. Refresh All 

C. Edit Prompts and Levels 

D. Publish 

Answer: BC

Q50. DSNs are set up for access to which data sources? 

A. ODBC Data Sources 

B. Oracle Data Sources 

C. IBM Data Sources 

D. Teradata Data Sources 

Answer: A