Глава девятая 9

Which text feature do you use to find sentiment in textual data?. Full-text index. Fuzzy text search. Text analysis. Text mining.

You create a full-text index. For what text feature clause do you need to specify a configuration?. SEARCH ONLY. FUZZY SEARCH INDEX. TEXT MINING. TEXT ANALYSIS.

What is the recommended way to create full-text indexes going forward?. User-defined functions. Procedures. Core Data Services. SQL statements in the SQL Console.

For which data types does SAP HANA automatically create full-text indexes? (There are 3 correct answers.). NVARCHAR. SHORTTEXT. BINTEXT. CLOB. TEXT.

What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement?. LIKE. ANY. IN. CONTAINS.

What do you use in a SQL query to sort fuzzy text search results by relevance?. RANK(). SCORE(). SORT BY. TOP.

What API would you use in SAP HANA SPS 11 to display search results in an ABAP system?. The esh_search procedure. SAP HANA Simple Info Access API (SINA). SAP HANA Text Mining XS JavaScript API. SAP HANA Text Analysis XS JavaScript API.

In what type of view can you use fuzzy text search directly?. Analytic views. Calculation views of type dimension. Calculation views of type cube. Attribute views.

True or False: The full-text index is stored in table $TA. True. False.

What spatial data type would you use to store multiple shop locations?. ST_Point. ST_MultiPoint. ST_Polygon. ST_MultiLineString.

Which spatial data formats can you import into SAP HANA? (There are 2 correct answers.). Scalable Vector Graphic (SVG). Well Known Text (WKT). ESRI shapefiles. GeoJSON.

What PAL algorithm category can you use for supervised learning?. Classification. Clustering. Association. Social network analysis.

What PAL algorithm would you use to analyze shopping baskets?. K-means. Decision tree. Apriori. Link prediction.

What must be installed for PAL to work?. SAP HANA BFL. SAP HANA AFL. SAP HANA AFM. SAP HANA SINA.

What SAP HANA information object does AFM create?. Attribute view. Calculation view. Table function. Procedure.