SAS Admin Quiz

Posted on: | By: – Comments Off

SAS Admin Quiz

SAS admin Quiz : This SAS admin Quiz contains set of 60 SAS admin Quiz which will help to clear any exam which is designed for Expert.



1) stored processes can access libraries without having to manage library assignments in the stored process code. How  should the libraries be assigned?

  1. by pre-assignment
  2. by client application
  3. by default
  4. by Server application

Answer : A

 
 
2) A client wants to have their system set up so that stored processes can access libraries without having to manage library assignments in the stored process code. How should the libraries be assigned?

  1. by default
  2. by client application
  3. by pre-assignment
  4. by user access

Answer : C

 
 
3) an environment has a standard workspace server instantiated by the object spawner.What authentication is required  for this configuration?

  1. back-end authentication
  2. integrated authentication
  3. internal authentication
  4. host authentication

Answer : D

 
 
4) A customer’s environment has a standard workspace server instantiated by the object spawner.What authentication is required to support this configuration?

  1. back-end authentication
  2. No authentication happens
  3. host authentication
  4. internal authentication

Answer : C

 
 
5) A host is using an LDAP provider as a back-end authentication mechanism. For this setup, how does the SAS server view the authentication?

  1. integrated authentication
  2. back-end authentication
  3. internal authentication
  4. host authentication

Answer : D

 
 
6) A metadata repository is

  1. A library of tables
  2. A SAS dataset
  3. Xml file
  4. A SAS VIEW

Answer : A

 
 
7) A platform administrator needs to register OLAP cubes. What permission levels are required for this task?

  1. CM for the target folder andWMMfor the OLAP schema.
  2. WM for the OLAP schema and RMLE for the target folder.
  3. WM for the target folder and WMM for the OLAP schema.
  4. WM for the OLAP schema and WMM for the target folder.

Answer : C

 
 
8) For metadata library connections to an RDBMS, which statement is true?

  1. Security is only applied if the library is pre-assigned.
  2. Security can be applied only in the RDBMS.
  3. Security can be applied only in SAS metadata.
  4. Security can be applied in SAS metadata and in the RDBMS.

Answer : D

 
 
9) How does the Object spawner connects to the metadata server

  1. Using the information in Object Spawner config.xml
  2. Using the information in metadataConfig.xml
  3. using the information in Repository manager
  4. using content server config file

Answer : B

 
 
10) In order of precedence from highest to lowest, how are permissions on a metadata item evaluated?

  1. Directly applied and ACT applied,Inherited from parent, Inherited from default ACT
  2. ACT applied,Directly applied,Inherited from parent,Inherited from default ACT
  3. Inherited from parent, Inherited from default ACT,ACT applied,Directly applied
  4. Directly applied, Inherited from parent,ACT applied,Inherited from default ACT

Answer : A




 
11) Select the method for updating table metadata that provides for the most control over updating features and can be run in batch.

  1. Update Metadata option in Data Library Manager in SAS Management Console.
  2. Update Library Metadata task in SAS Enterprise Guide.
  3. Update Metadata option in SAS Data Integration Studio.
  4. METALIB procedure using SAS code.

Answer : D

 
 
12) The method for updating table metadata that provides for the most control over updating features and can be run in batch.

  1. Update Metadata option in Data Library Manager in SAS Management Console.
  2. Update Library Metadata task in SAS Enterprise Guide.
  3. METALIB procedure using SAS code.
  4. Update Metadata option in SAS Data Integration Studio.

Answer : C

 
 
13) The METALIB procedure enables you to update table metadata. Which method does NOT provide access to the METALIB procedure?

  1. SAS Management Console’s update metadata feature
  2. SAS Enterprise Guide Explorer’s library management feature
  3. SAS Data Integration Studio’s update table metadata feature
  4. custom code using PROC METALIB.

Answer : B

 
 
14) Which method does NOT provide access to the METALIB procedure?

  1. custom code using PROC METALIB.
  2. SAS Data Integration Studio’s update table metadata feature
  3. SAS Enterprise Guide Explorer’s library management feature
  4. SAS Management Console’s update metadata feature

Answer : C

 
 
15) The WriteMemberMetadata (WWM) permission is only found on which type of items?

  1. Data libraries
  2. Folders
  3. Information Maps
  4. Data sets

Answer : B

 
 
16) Which component of SAS is NOT usually used by a business user

  1. SAS AMO
  2. SAS IDP
  3. SAS WRS
  4. SAS SPDS

Answer : D

 
 
17) Which of the admin activity is reccomended to be carried out on a daily basis

  1. Checking the status of server
  2. secure the SAS configuration
  3. Establishing connectivity to Data sources
  4. Back up environment

Answer : A

 
 
18) which of the data sources needs to be registered in metadata so that they are available to most of  the SAS applications

  1. SAS Datasets
  2. SAS OLAP Cubes
  3. RDBMS Tables
  4. SAS Datasets/Olap Cubes/RDBMS Tables

Answer : D

 
 
19) Which of the metadata repository is a Required repository?

  1. Custom repository
  2. Foundation Repository
  3. Project Repository
  4. MetaData Repository

Answer : B

 
 
20) Which one best describes a Repository Manager

  1. A utility software
  2. a Metadata repository
  3. A specific admin role
  4. Foundation Repository

Answer : B




 
21) Which one is not a SAS middle tier component

  1. SAS IDP
  2. SAS Remote Services
  3. SAS Content Server
  4. Share Server

Answer : D

 
 
22) Which permissions are found on all metadata item types in SAS BI

  1. RM WM RMM RW Administer
  2. RM WM RW Administer
  3. RM WM Administer
  4. RM WM

Answer : D

 
 
23) Which permissions are found on all metadata item types?

  1. RM WM RW Administer
  2. RM WM RMM RW Administer
  3. RM WM
  4. RM WM Administer

Answer : C

 
 
24) advantage of pre-assigned libraries SAS EBI

  1. Libraries are available in stored processes with no additional steps.
  2. Metadata security is always applied to pre-assigned libraries.
  3. User-written formats are only available to pre-assigned libraries.
  4. Maintenance is reduced for the platform administrator.

Answer : A

 
 
25) Which statement is FALSE? Updating table metadata enables you to:

  1. add table metadata for tables that exist in the physical library but have no metadata in the repository.
  2. update table definitions to match corresponding physical tables.
  3. update table security settings at the metadata and operating system level.
  4. delete metadata for table definitions that exist in the metadata repository but do not have a corresponding table in the physical library.

Answer : C

 
 
26) Which statement regarding precedence principles for authorization is FALSE?

  1. Settings on an item have priority over settings on the item’s parent.
  2. If identity precedence and the type of setting do not resolve a conflict, the outcome is a denial.
  3. Explicit settings have priority over ACT settings.
  4. A direct member of multiple groups cannot have conflicting settings.

Answer : C

 
 
27) Which Tool allows a SAS BI /DW developer to create and manage metadata objects that define sources,Targets, and the sequence of steps for the extraction, transformation and loading of data?

  1. SAS Enterprise Guide
  2. SAS Information Delivery Portal
  3. SAS Data integration Studio
  4. SAS Management Console

Answer : C

 
 
28) Which one  is not a logging leve

  1. Trace
  2. Debug
  3. Warn
  4. Kill

Answer : D

 
 
29) A grey background colour for a permission indicate that it is

  1. Explicit Permission
  2. ACT permission
  3. Indirect
  4. by default

Answer : C

 
 
30) ACT stands for

  1. Access Control Template
  2. Advanced coding Technique
  3. Authorization control team
  4. Actual Controls

Answer : A




 
31) The location of the repository manager physical files can be found in:

  1. SAS Management Console.
  2. the metadata server’s omaconfig.xml file.
  3. the foundation repository.
  4. the metadata server’s sasv9.cfg file.

Answer : B

 
 
32) Which procedure allows a platform administrator to update table metadata?

  1. METAUPDATE_RULE
  2. METASELECT
  3. METATABLE
  4. METALIB

Answer : D

 
 
33) when using an LDAP provider as a back-end authentication mechanism. For this setup, howdoes the SAS server view the authentication?

  1. integrated authentication
  2. back-end authentication
  3. host authentication
  4. internal authentication

Answer : C

 
 
34) A platform administrator needs to associate a library with an application server. What permission level on the application server will the platform administrator need for this task?

  1. CM
  2. RMLE
  3. WM
  4. WMM

Answer : C

 
 
35) Given the following applications: – SAS Add-in for Microsoft Office – SAS Enterprise Guide By default,How do these applications assign libraries?

  1. by using the SAS/ACCESS interface
  2. by using the metadata LIBNAME engine
  3. by using the BASE SAS engine
  4. by using the server autoexec file

Answer : B

 
 
36) disadvantage of pre-assigned libraries?

  1. Pre-assigned libraries must be identical across all SAS client applications.
  2. The server will not be available to the user until all pre-assigned libraries have been assigned
  3. Pre-assigned libraries must be assigned using the autoexec file.
  4. The administrator cannot control which engine is used to access data in a pre-assigned library.

Answer : B

 
 
37) Which statement is a disadvantage of pre-assigned libraries?

  1. The server does not become available to the user until all pre-assigned libraries have been assigned.
  2. Pre-assigned libraries must be identical across all SAS client applications.
  3. Pre-assigned libraries must be assigned using the autoexec file.
  4. The administrator cannot control which engine is used to access data in a pre-assigned library.

Answer : A

 
 
38) Which statement is an advantage of pre-assigned libraries?

  1. Metadata security is always applied to pre-assigned libraries.
  2. Libraries are available in stored processes with no additional steps.
  3. User-written formats are available to pre-assigned libraries.
  4. Maintenance is reduced

Answer : B

 
 
39) Which statement is FALSE? Updating table metadata enables you to:

  1. add table metadata for tables that exist in the physical library but have no metadata in the repository.
  2. update table definitions to match corresponding physical tables.
  3. update table security settings at the metadata and operating system level.
  4. delete metadata for table definitions that exist in the metadata repository but do not have a corresponding table in the physical library.

Answer : C

 
 
40) Which statement regarding precedence principles for authorization is FALSE?

  1. Settings on an item have priority over settings on the item’s parent.
  2. If identity precedence and the type of setting do not resolve a conflict, the outcome is a denial.
  3. Explicit settings have priority over ACT settings.
  4. A direct member of multiple groups cannot have conflicting settings.

Answer : D




 
41) Which tool will be used to create repositories

  1. SAS Management Console
  2. SAS EG
  3. Repository manager tool
  4. Repository create.xml

Answer : A

 
 
42) Which is the component for backing up SAS BI metadata contents

  1. %BKPMETA
  2. METABKP utility
  3. OMABAKUP
  4. %Bkp

Answer : C

 
 
43) Which Metadata plugin is used for creating new groups

  1. User Manager
  2. Group Manager
  3. Authorizatio Manager
  4. Maintenance

Answer : A

 
 
44) Which of the below is not a predefined user group in SAS

  1. SAS Administrators
  2. SAS System Services
  3. SAS General Services
  4. SAS unrestricted Users

Answer : D

 
 
45) Unrestricteduser@SASPW is

  1. is an unrestricted user by default
  2. Is a Member of SAS Administrator Group by default
  3. Required user for installation of some of the components of SAS analytic platform
  4. is just an internal account

Answer : D

 
 
46) what is the need for outbound logins

  1. for viewing output
  2. for seamless access to database
  3. required for SAS output access to public users
  4. by default

Answer : B

 
 
47) How Outbound logins are created?

  1. It is defined in the Account tab of users
  2. Is defined in the authorization tab
  3. is defined in the outbound login tab in Authorization manager plug in
  4. by Server application

Answer : A

 
 
48) Which is not a way of getting permission setting for a SAS user

  1. Explicit Permission
  2. ACT
  3. indirect
  4. induced

Answer : D

 
 
49) Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?

  1. SAS Metadata Server
  2. SAS Workspace Server
  3. SAS/CONNECT Server
  4. SAS Content Server

Answer : D

 
 
50) Content has been exported from a SAS 9.1.3 environment into a SAS 9.2 development environment. After the export, the platform administrator attempts to promote an object from the SAS 9.2 development environment into a production environment.
What will be

  1. The promotion will not be allowed because objects from SAS 9.1.3 cannot be promoted to SAS 9.2.
  2. The promotion will not be allowed because objects in a development environment cannot be promoted to a production environment.
  3. The promotion will be allowed assuming the object type is allowed for promotion.
  4. The promotion will not be allowed because objects exported from a previous environment cannot be promoted.

Answer : C




 
51) A platform administrator needs to delete metadata for table definitions with the following characteristics:- the table definitions exist in the metadata repository – the table definitions do not have a corresponding table in the physical library After per

  1. delete repository
  2. delete physical library
  3. delete metadata folder
  4. update table metadata

Answer : D

 
 
52) when the table definitions exist in the metadata repository  the table definitions do not have a corresponding table in the physical library After performing impact analysis, what action should the platform administrator take?

  1. delete logical library
  2. update table metadata
  3. delete the table’s metadata folder
  4. delete physical library

Answer : B

 
 
53) A platform administrator wants to prevent all restricted users from accessing data that requires the Read permission. Which permission level(s) should the platform  administrator assign?

  1. RM and R for PUBLIC
  2. RM and R for PUBLIC and SAS Administrators
  3. R for PUBLIC
  4. RM for PUBLIC and SAS System Services

Answer : C

 
 
54) Given the following applications: – SAS Add-in for Microsoft Office – SAS Enterprise Guide By default, How do these applications assign libraries?

  1. by using the SAS/ACCESS interface
  2. by using the metadata LIBNAME engine
  3. by using the BASE SAS engine
  4. by using the server autoexec file

Answer : B

 
 
55) Which is not a way of invoking OMABAKUP Macro

  1. As Part of the backup and restore programs available with the installation
  2. OMABAKUP transformation in DI studio
  3. Using the code generated by Backup Wizard in SMC
  4. By writing a custome code to invoke the macro

Answer : B

 
 
56) A Green background colour for a permission indicate that it is

  1. Indirect
  2. ACT permission
  3. Explicit Permission
  4. by default

Answer : B

 
 
57) Upon initial install, all of the capabilities in the ‘Web Report Studio: Report Creation’ role are also included in which role?

  1. Web Report Studio: Report Viewing
  2. Web Report Studio: Advanced
  3. Web Report Studio: Content Management
  4. Web Report Studio: Administration

Answer : B

 
 
58) Every SAS platform implementation includes:

  1. a foundation repository and a repository manager.
  2. a foundation repository and a custom repository.
  3. a custom repository and a repository manager.
  4. multiple project repositories.

Answer : A

 
 
59) A platform administrator needs to retrieve from the metadata a complete LIBNAME statement including the user ID and password.
To complete this task, the platform administrator must be connected to SAS Management Console with what type of user access in t

  1. Access to the credentials associated with libraries created with the METALIB procedure.
  2. Access to credentials established by the LIBNAME engine.
  3. Access to credentials associated with users in the outbound login.
  4. Access to credentials for the authentication domain associated with the database server.

Answer : D

 
 
60) By default, which groups have WriteMetadata on the Foundation repository?

  1. PUBLIC
  2. SASUSERS
  3. ADMINISTRATORS ONLY
  4. SAS SYSTEM SERVICES ONLY

Answer : B

 
 
61) Given the following authorization settings for Library Sales2:
Library Sales2’s parent folder has an explicit grant of RM for Mary.
Library Sales2 has an explicit denial of RM for PUBLIC.
Which statement is true?
 

  1. Mary can see Library Sales2.
  2. Mary can see data flagged as PUBLIC in Library Sales2.
  3. Mary cannot see Library Sales2.
  4. Mary can see Library Sales2, but not any data flagged as PUBLIC.

Answer : C

 
 
62) Which statement is FALSE regarding the WriteMemberMetadata (WMM) permission?

  1. By default, it mirrors the WriteMetadata permission.
  2. It only applies to folders.
  3. If WriteMetadata is granted, then you should not deny WMM.
  4. WMM is inherited from one folder to another folder.

Answer : D




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz