Big Data Engineer IBM Explore

Big Data Engineer IBM Explore Which definition best describes RCAC? A. It limits access by using views and stored procedures. B. It grants or revokes certain directory privileges. C. It limits the rows or columns ret ...

Big Data Engineer IBM Explore Which definition best describes RCAC? A. It limits access by using views and stored procedures. B. It grants or revokes certain directory privileges. C. It limits the rows or columns returned based on certain criteria. D. It grants or revokes certain user privileges - ✔✔C. It limits the rows or columns returned based on certain criteria. You have a distributed file system (DFS) and need to set permissions on the the /hive/warehouse directory to allow access to ONLY the bigsql user. Which command would you run? A. hdfs dfs -chmod 700 /hive/warehouse B. hdfs dfs -chmod 666 /hive/warehouse C. hdfs dfs -chmod 770 /hive/warehouse D. hdfs dfs -chmod 755 /hive/warehouse - ✔✔A. hdfs dfs -chmod 700 /hive/warehouse What is an advantage of the ORC file format? A. Efficient compression B. Big SQL can exploit advanced features C. Supported by multiple I/O engines D. Data interchange outside Hadoop - ✔✔A. Efficient compression You need to enable impersonation. Which two properties in the bigsql-conf.xml file need to be marked true? A. $BIGSQL_HOME/conf B. DB2COMPOPT C. bigsql.alltables.io.doAs D. bigsql.impersonation.create.table.grant.public E. DB2_ATS_ENABLE - ✔✔C. bigsql.alltables.io.doAs D. bigsql.impersonation.create.table.grant.public You are creating a new table and need to format it with parquet. Which partial SQL statement would create the table in parquet format? A. STORED AS parquet B. CREATE AS parquetfile C. STORED AS parquetfile D. CREATE AS parquet - ✔✔C. STORED AS parquetfile Which directory permissions need to be set to allow all users to create their own schema? A. 666 B. 777 C. 700 D. 755 - ✔✔B. 777 You need to determine the permission setting for a new schema directory. Which tool would you use? A. umask B. GRANT C. HDFS D. Kerberos - ✔✔A. umask Using the Java SQL Shell, which command will connect to a database called mybigdata? A. ./jsqsh mybigdata B. ./jsqsh go mybigdata C. ./java mybigdata D. ./java tables - ✔✔A. ./jsqsh mybigdata Which two commands would you use to give or remove certain privileges to/from a user? A. INSERT B. GRANT C. REVOKE D. LOAD E. SELECT - ✔✔B. GRANT C. REVOKE What are Big SQL database tables organized into? A. Schemas B. Directories C. Files D. Hives - ✔✔A. Schemas When connecting to an external database in a federation, you need to use the correct database driver and protocol. What is this federation component called in Big SQL? A. Wrapper B. Data source C. User mapping D. Nickname - ✔✔A. Wrapper Which statement best describes a Big SQL database table? A. A directory with zero or more data files. B. The defined format and rules around a delimited file. C. A container for any record format. D. A data type of a column describing its value - ✔✔A. A directory with zero or more data files Which tool would you use to create a connection to your Big SQL database? A. Jupyter B. DSM C. Ambari D. Scheduler - ✔✔B. DSM What is the default directory in HDFS where tables are stored? A. /apps/hive/warehouse/schema B. /apps/hive/warehouse/ C. /apps/hive/warehouse/data D. /apps/hive/warehouse/bigsql - ✔✔B. /apps/hive/warehouse/ Which command creates a user-defined schema function? A. ALTER MODULE PUBLISH FUNCTION B. TRANSLATE FUNCTION C. ALTER MODULE ADD FUNCTION D. CREATE FUNCTION - ✔✔D. CREATE FUNCTION Apache Spark provides a single, unifying platform for which three of the following types of operations? A. graph operations B. record locking C. batch processing D. machine learning E. ACID transactions F. transaction processing - ✔✔A. graph operations C. batch processing D. machine learning Which is the java class prefix for the MapReduce v1 APIs? A. org.apache.hadoop.mr B. org.apache.mapreduce C. org.apache.hadoop.mapred D. org.apache.mr - ✔✔C. org.apache.hadoop.mapred What is the preferred replacement for Flume? A. Hortonworks Data Flow B. Storm C. NiFi D. Druid - ✔✔A. Hortonworks Data Flow Under the YARN/MRv2 framework, which daemon arbitrates the execution of tasks among all the applications in the system? A. ScheduleManager B. ApplicationMaster C. JobMaster D. ResourceManager - ✔✔D