SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Interview Questions
+
-
Hadoop Interview Questions
+
-
Fiori Interview Questions
+
-
S/4HANA Interview Questions
+
-
SAP Cloud Platform

Full-Text Search with SAP HANA - Interview Questions

Question 1: Which of the following statements regarding full-text indexes are true? Note: There are 3 correct answers to this question.
  1. A full-text index is updated automatically when data changes in the corresponding table column.
  2. A full-text index is bound to a table column.
  3. A full-text index is fully managed by the system (for example, when doing backup/restore).
  4. An implicit full-text index requires more memory than an explicit full-text index plus the original data.
Answer A,B,C
Question 2: Which of the following are valid configuration options for a full-text index? Note: There are 3 correct answers to this question.
  1. TEXT MINING COLUMN "myTMColumn"
  2. FAST PREPROCESS ON
  3. LANGUAGE DETECTION ('fr', 'de')
  4. SEARCH ONLY OFF
Answer B,C,D
Question 3: What is "freestyle search"?
  1. A search on one column
  2. A search on multiple columns with multiple CONTAINS
  3. A search in a single database container
  4. A search on multiple columns with a single CONTAINS
Answer D
Question 4: When running a full-text search query using the SQL CONTAINS() predicate, which of the following query options are supported by SAP HANA? Note: There are 3 correct answers to this question.
  1. Proximity search
  2. Image search
  3. Wildcard search
  4. Phrase search
Answer A,C,D
Question 5: Which of the following fuzzy search options are supported by SAP HANA? Note: There are 3 correct answers to this question.
  1. termMappingTable
  2. abbrevationSimilarity
  3. (de)composeWords
  4. maxNGrams
Answer A,B,C
Question 6: Which of the following modes are supported when using search rules for matching in SAP HANA? Note: There are 3 correct answers to this question.
  1. Matching a set of records in batch mode
  2. Matching a single record using predefined search rules
  3. Matching predefined search rules using a single procedure call
  4. Matching a single record using dynamically defined search rules
Answer A,B,D
Question 7: What is the correct syntax to create a fuzzy index within the CREATE FULLTEXT INDEX statement?
  1. FUZZY INDEX ON
  2. ENABLE FUZZY
  3. CREATE FUZZY SEARCH INDEX
  4. FUZZY SEARCH INDEX ON
Answer D
Question 8: Which of the following can be defined in a search model in SAP HANA? Note: There are 3 correct answers to this question.
  1. The data types of the table columns
  2. The default columns for search
  3. The facets
  4. Highlighting and snippets
Answer B,C,D
Question 9: Which of the following property type annotations are supported for search modeling using Core Data Services (CDS) and ESH_CONFIG? Note: There are 3 correct answers to this question.
  1. Search.termMappingDictionary and Search.termMappingListID
  2. EnterpriseSearch.defaultPresentationMode
  3. EnterpriseSearch.snippets.enabled
  4. EnterpriseSearch.filteringFacet
Answer A,C,D
Question 10: When creating search models, which annotations control the inclusion of data from a 1:n join into the search result? Note: There are 2 correct answers to this question.
  1. "generateList": "ALL"
  2. "isCollection": true
  3. "isArray": true
  4. "@EnterpriseSearchHana.layoutStructuredObject.defaultExpand": "ALL"
Answer D
Question 11: Which of the following statements regarding the built-in procedure ESH_SEARCH are true?
  1. ESH_SEARCH provides an interface for reporting and analytics; it takes an XML/A input and returns a multidimensional cube.
  2. ESH_SEARCH provides an OData interface for matching and duplicate detection; it takes an XML input and returns a graph-like response.
  3. ESH_SEARCH provides an interface for federated search; it takes an OData-like input and returns an OData-like JSON response.
  4. ESH_SEARCH provides a REST interface for Google search; it takes a JSON input and returns a spatial response.
Answer C
Question 12: Which of the following standard OData query options are supported by ESH_SEARCH? Note: There are 2 correct answers to this question.
  1. $inlinecount
  2. $skip
  3. $expand
  4. $top
Answer B,D
Question 13: Which of the following query concepts are supported by the query language used in the 'query' parameter? Note: There are 3 correct answers to this question.
  1. Reachability constraints such as (document)-[writtenBy]-(Frank)
  2. Operators such as OR, NOT, ~(fuzzy), ^(boost)
  3. Attribute filters such as country:us and amount:[100 200]
  4. Attribute conditions on spatial data types such as loc:COVERED_BY:POLYGON()
Answer B,C,D
Question 14: How can you retrieve the metadata of the search models defined in an SAP HANA system?
  1. Use the administration cockpit http://server:port/sap/hana/admin/cockpit/
  2. Use system tables
  3. Use the default OData service
  4. Use the built-in procedure ESH_SEARCH()
Answer D
Question 15: Which of the following user interface controls does the generic SAPUI5-based search UI provide? Note: There are 3 correct answers to this question.
  1. Related links
  2. Detail
  3. Summary
  4. Facets
Answer B,C,D
Question 16: Which UI framework is used by the generic search UI?
  1. Angular.js
  2. Polymer
  3. SAPUI5
  4. Neocortex
Answer C
Question 17: Which database objects can be accessed via the generic SAPUI5-based search UI?
  1. Calculation views
  2. Search models
  3. SQL views
  4. Full-text indexes
Answer B
Question 18: What is SAP HANA enterprise search?
  1. A set of natural language processing (NLP) features in SAP HANA
  2. A set of search models provided by SAP partners
  3. A connector to Elasticsearch
  4. A search solution that provides full-text search across multiple SAP systems
Answer D
Question 19: What are the major differences between SAP HANA enterprise search and "search in SAP HANA"? Note: There are 3 correct answers to this question.
  1. SAP HANA enterprise search supports search-specific query analysis out-of-the box; SAP HANA does not.
  2. SAP HANA enterprise search is a Java solution; SAP HANA runs on ABAP.
  3. SAP HANA enterprise search provides tools for user/domain-specific relevance ranking ("boosting"); SAP HANA does not.
  4. SAP HANA enterprise search leverages the search models provided by SAP Business Suite and SAP S/4HANA; SAP HANA does not include search models.
Answer A,C,D
Question 20: Which of the following statements regarding SAP HANA file processing - on-premise and in the cloud (planned) - are true? Note: There are 2 correct answers to this question.
  1. SAP HANA file processing can be leveraged to replicate content from a source system into SAP HANA for search purposes.
  2. SAP HANA file processing creates a distributed full-text index.
  3. SAP HANA file processing provides services to collect and analyze unstructured content/documents.
  4. SAP HANA file processing provides an easy-to-understand user interface for end users.
Answer A,C
Question 21: Which of the following statements regarding SAP HANA graph are true? Note: There are 2 correct answers to this question.
  1. SAP HANA graph is a native graph engine on SAP HANA.
  2. SAP HANA graph exposes a SPARQL endpoint
  3. SAP HANA graph uses a proprietary format to store "connected data"
  4. SAP HANA graph supports the "property graph model".
Answer A,D



Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy