Wave Analytics Interview Questions Part-2
11. What is an analytics Lens?
A lens is a viewer for your dataset data.It's like a particular view into a dataset’s data. You can create many lenses for one dataset. and it can be used alone or can be grouped into a dashboard.
A lens is a viewer for your dataset data.It's like a particular view into a dataset’s data. You can create many lenses for one dataset. and it can be used alone or can be grouped into a dashboard.
12. What is a Salesforce Analytics Query Language (SAQL)?
SAQL (Salesforce Analytics Query Language) is used to access data in Analytics datasets. It consists of a sequence of statements that are made up of filter, group, order , identifiers, literals, or special characters. Statements can be multiple lines and must end witha semicolon. Every statement has a result, and you can chain statements together. SAQL is compositional.
13. What is the purpose of metadata.json file in analytics dataset?
When you upload a CSV file through UI or External Data API it's recommended to provide the metadata json file. It describes the structure of the data file(.csv) in JSON format. It's optional but without this every field in dataset treated as text data type.
When you upload a CSV file through UI or External Data API it's recommended to provide the metadata json file. It describes the structure of the data file(.csv) in JSON format. It's optional but without this every field in dataset treated as text data type.
14. What is XMD file? what is the purpose of it?
15. What is the Maximum file size for external data API upload?
The Maximum file size per external data upload 40 GB.
The Maximum file size per external data upload 40 GB.
16. What is the Maximum file size for user interface upload?
When you upload data from the UI, there is a limit on the size of data restricted to 512MB Only.
When you upload data from the UI, there is a limit on the size of data restricted to 512MB Only.
17. What are the InsightsExternalData and InsightsExternalDataPar Objects?
InsightsExternalData: It enables you to configure and control external data uploads. You can use it to provide metadata, trigger the start of the upload process, check status, and request cancelation and clean up the dataset.
InsightsExternalDataPart: It enables you to upload an external data file into parts. Each part should not exceed more then 10MB.
InsightsExternalData: It enables you to configure and control external data uploads. You can use it to provide metadata, trigger the start of the upload process, check status, and request cancelation and clean up the dataset.
InsightsExternalDataPart: It enables you to upload an external data file into parts. Each part should not exceed more then 10MB.
18. What is the maximum size of the file accepts InsightsExternalDataPart object?
When you upload data from the External Data API, the limit on the size of data is 40GB.
When you upload data from the External Data API, the limit on the size of data is 40GB.
19. What is the maximum number of columns (fields) can we upload from external CSV file?
Upto 5,000 columns and it including up to 1,000 date fields. These limits may change on every release of Salesforce. check the latest limits on External Data API Limits
Upto 5,000 columns and it including up to 1,000 date fields. These limits may change on every release of Salesforce. check the latest limits on External Data API Limits
20. What is the difference between Values table, Compare table and Pivot table?
COMMENTS