Big data engineer ibm exploree

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 - answer-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 - answer-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 - answer-A. Efficient compression You need to enable impersonation. Which two properties in the file need to be marked true? A. $BIGSQL_HOME/conf B. DB2COMPOPT C. As D. c E. DB2_ATS_ENABLE - answer-C. As D. c 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 - answer-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 - answer-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 - answer-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 - answer-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 - answer-B. GRANT C. REVOKE What are Big SQL database tables organized into? A. Schemas B. Directories C. Files D. Hives - answer-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 - answer-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 - answer-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 - answer-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 - answer-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 - answer-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 - answer-A. graph operations C. batch processing D. machine learning Which is the java class prefix for the MapReduce v1 APIs? A. B. duce C. d D. - answer-C. d What is the preferred replacement for Flume? A. Hortonworks Data Flow B. Storm C. NiFi D. Druid - answer-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 - answer-D. ResourceManager Which component of the Apache Ambari architecture provides statistical data to the dashboard about the performance of a Hadoop cluster? A. Ambari Wizard B. Ambari Alert Framework C. Ambari Metrics System D. Ambari Server - answer-C. Ambari Metrics System Under the YARN/MRv2 framework, the Scheduler and ApplicationsManager are components of which daemon? A. ResourceManager B. ApplicationMaster C. TaskManager D. ScheduleManager - answer-A. ResourceManager Which three programming languages are directly supported by Apache Spark? A. Scala B. Java C. C++ D. Python E. .NET F. C# - answer-A. Scala B. Java D. Python Under the YARN/MRv2 framework, the JobTracker functions are split into which two daemons? A. JobMaster B. ResourceManager C. ScheduleManager D. TaskManager E. ApplicationMaster - answer-B. ResourceManager E. ApplicationMaster What are two common issues in distributed systems? A. Reduced performance when compared to a single server. B. Finding a particular node within the cluster. C. Distributed systems are harder to scale up. D. Partial failure of the nodes during execution. - answer-B. Finding a particular node within the cluster. D. Partial failure of the nodes during execution. Which component of an Hadoop system is the primary cause of poor performance? A. CPU B. disk latency C. network D. RAM - answer-B. disk latency Which Apache Hadoop application provides an SQL-like interface to allow abstraction of data on semi-structured data in a Hadoop datastore? A. Hive B. YARN C. Spark D. Pig - answer-A. Hive Which component of the Spark Unified Stack allows developers to intermix structured database queries with Spark's programming language? A. Mesos B. Spark SQL C. Java D. MLlib - answer-B. Spark SQL Hadoop uses which two Google technologies as its foundation? A. YARN B. Google File System C. Ambari D. HBase